FileMaker Query Language or FQL

288 topics in this forum

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

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

2. Results do not match Find

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

3. Execute SQL Function Returned Object?

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

4. SQL sum issue

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

5. Problems related variable sum

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

6. Convert Date from SQL to FM Syntax

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

7. ExecuteSQL Question

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

8. Average of most recent records

   By benmort81, September 1, 2015   

   • average
   • aggregate
   • (and 1 more)

      Tagged with:

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

9. 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
   • 5.9k views
   • 
   • beverly
   • September 1, 2015

10. Update data in Oracle using Filemaker

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

11. Update statement

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

12. GROUP BY + SORT BY

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

13. Very simple JOIN

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

14. the top 10

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

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

    By Stu412, August 14, 2015   

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

16. Two separate relationships

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

17. FQL UPDATE

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

18. Is WHERE RECORD = ? possible

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

19. Querying a filemaker db with SQL

    By tomentourage, July 7, 2015   

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

20. Group By - requires all Select fields

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

21. Show related records in text field

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

22. How to Debug FQL

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

23. ExecuteSQL - Join tables

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

24. Unique record selection

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

25. Mimic Quick Find in SQL

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

26. SQL "AS" statement

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

27. ExecuteSQL with conditional Arguments

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

28. executesql Problem with fieldname characters

    By El_Pablo, May 15, 2015
    • 4 replies
    • 949 views
    • 
    • eos
    • May 15, 2015

29. FQL SORT BY Date, Time

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

30. Get product number if

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

31. Missing Data

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

32. executeSQL SUM help for executeSQL newbie

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

33. Distinct Value but return different column.

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

34. Small SQL Query Help

    By Justin P., March 13, 2015   

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

35. pc ExecuteSQL - does it not follow portal filtering processes?

    By Stu412, March 9, 2015   

    • sql
    • portal
    • (and 1 more)

       Tagged with:

      • sql
      • portal
      • executesql
    • 4 replies
    • 3k views
    • 
    • Kris M
    • March 9, 2015