FileMaker Query Language or FQL

263 topics in this forum

1. Cannot get a simple SUM

   By filemakerdeveloper40, January 19
   • 4 replies
   • 183 views
   • 
   • Ocean West
   • January 30

2. fmp17 ExecuteSQL() ORDER BY FIELD function

   By dwdata, December 28, 2018
   • 3 replies
   • 154 views
   • 
   • dwdata
   • January 1

3. Counting two of the same values

   By Rich, September 25, 2018
   • 5 replies
   • 464 views
   • 
   • comment
   • September 28, 2018

4. Why an extra line feed/carriage return in scripted E-SQL calculation

   By Rich, August 15, 2018
   • 3 replies
   • 287 views
   • 
   • Tom Assia
   • August 17, 2018

5. sql help

   By shredded, July 31, 2018
   • 4 replies
   • 238 views
   • 
   • Fitch
   • August 2, 2018

6. Query data

   By Tom Assia, July 17, 2018
   • 2 replies
   • 237 views
   • 
   • Tom Assia
   • July 17, 2018

7. SQL to FQL rules

   By normanicus, July 6, 2018
   • 2 replies
   • 252 views
   • 
   • normanicus
   • July 8, 2018

8. FM SQL ExecuteSQL syntax troubles for IN clause

   By Justin Close, June 9, 2015   

   • sql
   • executesql
   • (and 1 more)

     Tagged with:

     • sql
     • executesql
     • in
   • 15 replies
   • 3,450 views
   • 
   • neutralbay
   • April 27, 2018

9. group by and count

   By jhollingsworth, April 22, 2018
   • 2 replies
   • 274 views
   • 
   • Lee Smith
   • April 23, 2018

10. Non-alphanumeric name field syntax

    By Rich, April 5, 2018
    • 2 replies
    • 411 views
    • 
    • Rich
    • April 6, 2018

11. ExecuteSQL query works with values, but not field references

    By Tom R., March 28, 2018   

    • executesql
    • 5 replies
    • 346 views
    • 
    • Fitch
    • March 30, 2018

12. Problems with SQL sum

    By Eli Walker, January 27, 2018   

    • sum
    • sql
    • (and 1 more)

      Tagged with:

      • sum
      • sql
      • join
    • 4 replies
    • 453 views
    • 
    • bcooney
    • January 28, 2018

13. SQL SLOW

    • 1
    • 2

    By OneStop, January 10, 2018
    • 35 replies
    • 1,560 views
    • 
    • LaRetta
    • January 18, 2018

14. Simple Join

    By jimlongo, December 2, 2017
    • 6 replies
    • 462 views
    • 
    • bcooney
    • December 3, 2017

15. Set a flag using SQL through a portal

    By WF7A, November 22, 2017
    • 2 replies
    • 366 views
    • 
    • WF7A
    • November 27, 2017

16. 4 Table SQL Search

    By shredded, November 20, 2017
    • 1 reply
    • 386 views
    • 
    • Fitch
    • November 22, 2017

17. Issue with ValueCount and ExecuteSQL

    By NewBoard, October 26, 2017   

    • inspector
    • accepted
    • (and 3 more)

      Tagged with:

      • inspector
      • accepted
      • executesql
      • valuecount
      • merge variable
    • 1 reply
    • 477 views
    • 
    • bcooney
    • October 27, 2017

18. Sending Variable to WHERE IN in ExecuteSQL Not Working

    By SRayNoriega, October 11, 2017
    • 5 replies
    • 709 views
    • 
    • SRayNoriega
    • October 17, 2017

19. Does FQL actually work?

    By losferwords@outgun.com, May 10, 2017   

    • sql
    • fql
    • 17 replies
    • 1,785 views
    • 
    • Wim Decorte
    • August 15, 2017

20. GROUP BY in ExecuteSQL

    By abross86, June 13, 2014
    • 10 replies
    • 4,459 views
    • 
    • comment
    • July 1, 2017

21. Control Column Widths in ExecuteSql

    By vanderark1, June 8, 2017   

    • executesql
    • 17 replies
    • 917 views
    • 
    • ggt667
    • June 12, 2017

22. JSON parsing performance comparison

    By crayfish, June 6, 2017   

    • json
    • 5 replies
    • 1,109 views
    • 
    • MonkeybreadSoftware
    • June 8, 2017

23. Creating report with a lot of subsummaries and monthly columns - using executesql queries?

    By Rachel, June 4, 2017   

    • portal
    • executesql
    • (and 2 more)

      Tagged with:

      • portal
      • executesql
      • report
      • subsummary
    • 2 replies
    • 515 views
    • 
    • comment
    • June 4, 2017

24. Large MSSQL data set error

    By CoZiMan, May 26, 2017
    • 5 replies
    • 480 views
    • 
    • beverly
    • May 26, 2017

25. JSON Error: Unterminated String

    By nesor, May 21, 2017
    • 3 replies
    • 715 views
    • 
    • Wim Decorte
    • May 23, 2017