FileMaker Query Language or FQL

290 topics in this forum

1. My first ExecSQL Join

   By Ron Cates, October 19, 2015
   • 2 replies
   • 1.1k views
   • 
   • Fitch
   • October 22, 2015

2. Filemaker not importing to mySQL correctly

   By John.M, October 7, 2015
   • 1 reply
   • 1.4k views
   • 
   • Wim Decorte
   • October 7, 2015

3. Querying time stamp field with a just a date.

   By Matt Klein, October 6, 2015
   • 1 reply
   • 1.9k views
   • 
   • eos
   • October 6, 2015

4. Results do not match Find

   By bcooney, October 1, 2015
   • 9 replies
   • 1.6k views
   • 
   • beverly
   • October 4, 2015

5. Execute SQL Function Returned Object?

   By Tyra, October 2, 2015
   • 3 replies
   • 1.3k views
   • 
   • beverly
   • October 3, 2015

6. SQL sum issue

   By madman411, September 22, 2015
   • 1 reply
   • 1.4k views
   • 
   • eos
   • September 22, 2015

7. Problems related variable sum

   By Gonçalo Casanova, September 17, 2015
   • 8 replies
   • 2.1k views
   • 
   • Gonçalo Casanova
   • September 20, 2015

8. Convert Date from SQL to FM Syntax

   By Phillip Prahl, September 15, 2015
   • 4 replies
   • 4.8k views
   • 
   • Phillip Prahl
   • September 17, 2015

9. ExecuteSQL Question

   By aguest, September 9, 2015
   • 7 replies
   • 1.4k views
   • 
   • Wim Decorte
   • September 10, 2015

10. Average of most recent records

    By benmort81, September 1, 2015
    • 2 replies
    • 2.1k views
    • 
    • benmort81
    • September 1, 2015

11. Get ESQL to return always 2 decimal places (currency)?

    By Justin Close, August 17, 2015
    • 5 replies
    • 6.5k views
    • 
    • beverly
    • September 1, 2015

12. Update data in Oracle using Filemaker

    By Suha, August 28, 2015
    • 2 replies
    • 1.2k views
    • 
    • beverly
    • September 1, 2015

13. Update statement

    By Suha, August 22, 2015
    • 4 replies
    • 1.2k views
    • 
    • Suha
    • August 28, 2015

14. GROUP BY + SORT BY

    By Reid, August 19, 2015
    • 2 replies
    • 3.1k views
    • 
    • Reid
    • August 20, 2015

15. Very simple JOIN

    By sal88, August 20, 2015
    • 2 replies
    • 878 views
    • 
    • sal88
    • August 20, 2015

16. the top 10

    By David Nelson, May 11, 2015
    • 5 replies
    • 3.7k views
    • 
    • sal88
    • August 18, 2015

17. What I thought was a simple margin calculation in ExecuteSQL.......

    By Stu412, August 14, 2015
    • 9 replies
    • 1.7k views
    • 
    • Stu412
    • August 17, 2015

18. Two separate relationships

    By sal88, August 7, 2015
    • 5 replies
    • 1.3k views
    • 
    • sal88
    • August 11, 2015

19. FQL UPDATE

    By Joshua, July 28, 2015
    • 5 replies
    • 1.4k views
    • 
    • Joshua
    • July 28, 2015

20. Is WHERE RECORD = ? possible

    By Joshua, July 23, 2015
    • 6 replies
    • 1.3k views
    • 
    • Joshua
    • July 28, 2015

21. Querying a filemaker db with SQL

    By tomentourage, July 7, 2015
    • 9 replies
    • 3.8k views
    • 
    • Wim Decorte
    • July 26, 2015

22. Group By - requires all Select fields

    By rivet, June 28, 2015
    • 2 replies
    • 1.6k views
    • 
    • beverly
    • July 25, 2015

23. Show related records in text field

    By madman411, July 12, 2015
    • 4 replies
    • 1.1k views
    • 
    • beverly
    • July 25, 2015

24. How to Debug FQL

    By no1tmorrow, July 2, 2014
    • 10 replies
    • 2.3k views
    • 
    • beverly
    • July 25, 2015

25. ExecuteSQL - Join tables

    By aguest, July 14, 2015
    • 2 replies
    • 7.5k views
    • 
    • aguest
    • July 14, 2015

26. Unique record selection

    By Greg Hains, June 13, 2015
    • 4 replies
    • 1.2k views
    • 
    • Greg Hains
    • June 17, 2015

27. Mimic Quick Find in SQL

    By Scott, June 17, 2015
    • 1 reply
    • 926 views
    • 
    • Kris M
    • June 17, 2015

28. SQL "AS" statement

    By Joshua, June 1, 2015
    • 6 replies
    • 1.4k views
    • 
    • Joshua
    • June 1, 2015

29. ExecuteSQL with conditional Arguments

    By James Gill, May 18, 2015
    • 6 replies
    • 2.2k views
    • 
    • David Jondreau
    • May 20, 2015

30. Problem with fieldname characters

    By El_Pablo, May 15, 2015
    • 4 replies
    • 1.1k views
    • 
    • eos
    • May 15, 2015

31. FQL SORT BY Date, Time

    By Joshua, May 7, 2015
    • 3 replies
    • 1.6k views
    • 
    • eos
    • May 7, 2015

32. Get product number if

    By Charity, May 6, 2015
    • 3 replies
    • 944 views
    • 
    • eos
    • May 6, 2015

33. Missing Data

    By pdxpro, April 23, 2015
    • 1 reply
    • 942 views
    • 
    • Rick Whitelaw
    • April 24, 2015

34. executeSQL SUM help for executeSQL newbie

    By infoweb, March 22, 2015
    • 5 replies
    • 3.8k views
    • 
    • infoweb
    • March 23, 2015

35. Distinct Value but return different column.

    By Ocean West, March 18, 2015
    • 3 replies
    • 1.5k views
    • 
    • dansmith65
    • March 19, 2015