FileMaker Query Language or FQL

289 topics in this forum

1. Filemaker not importing to mySQL correctly

   By John.M, October 7, 2015   

   • mysql
   • import issues
   • 1 reply
   • 1.3k views
   • 
   • Wim Decorte
   • October 7, 2015

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

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

3. Results do not match Find

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

4. Execute SQL Function Returned Object?

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

5. SQL sum issue

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

6. Problems related variable sum

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

7. Convert Date from SQL to FM Syntax

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

8. ExecuteSQL Question

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

9. Average of most recent records

   By benmort81, September 1, 2015   

   • average
   • aggregate
   • (and 1 more)

      Tagged with:

     • average
     • aggregate
     • executesql
   • 2 replies
   • 1.9k views
   • 
   • benmort81
   • September 1, 2015

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

    By Justin Close, August 17, 2015   

    • currency
    • esql
    • (and 1 more)

       Tagged with:

      • currency
      • esql
      • 2 decimal
    • 5 replies
    • 6.3k views
    • 
    • beverly
    • September 1, 2015

11. Update data in Oracle using Filemaker

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

12. Update statement

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

13. GROUP BY + SORT BY

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

14. Very simple JOIN

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

15. the top 10

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

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

    By Stu412, August 14, 2015   

    • sql
    • summary
    • 9 replies
    • 1.6k views
    • 
    • Stu412
    • August 17, 2015

17. Two separate relationships

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

18. FQL UPDATE

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

19. Is WHERE RECORD = ? possible

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

20. Querying a filemaker db with SQL

    By tomentourage, July 7, 2015   

    • sql
    • 9 replies
    • 3.5k views
    • 
    • Wim Decorte
    • July 26, 2015

21. Group By - requires all Select fields

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

22. Show related records in text field

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

23. How to Debug FQL

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

24. ExecuteSQL - Join tables

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

25. Unique record selection

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

26. Mimic Quick Find in SQL

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

27. SQL "AS" statement

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

28. ExecuteSQL with conditional Arguments

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

29. executesql Problem with fieldname characters

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

30. FQL SORT BY Date, Time

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

31. Get product number if

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

32. Missing Data

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

33. executeSQL SUM help for executeSQL newbie

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

34. Distinct Value but return different column.

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

35. Small SQL Query Help

    By Justin P., March 13, 2015   

    • sql
    • 3 replies
    • 2.2k views
    • 
    • Justin P.
    • March 16, 2015