FileMaker Query Language or FQL

260 topics in this forum

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

   By Rich, 7 hours ago
   • 1 reply
   • 15 views
   • 
   • Tom Assia
   • 1 hour ago

2. sql help

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

3. Query data

   By Tom Assia, July 17
   • 2 replies
   • 106 views
   • 
   • Tom Assia
   • July 17

4. SQL to FQL rules

   By normanicus, July 6
   • 2 replies
   • 122 views
   • 
   • normanicus
   • July 8

5. 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
   • 2,877 views
   • 
   • neutralbay
   • April 27

6. group by and count

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

7. Non-alphanumeric name field syntax

   By Rich, April 5
   • 2 replies
   • 247 views
   • 
   • Rich
   • April 6

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

   By Tom R., March 28   

   • executesql
   • 5 replies
   • 199 views
   • 
   • Fitch
   • March 30

9. Problems with SQL sum

   By Eli Walker, January 27   

   • sum
   • sql
   • (and 1 more)

     Tagged with:

     • sum
     • sql
     • join
   • 4 replies
   • 297 views
   • 
   • bcooney
   • January 28

10. SQL SLOW

    • 1
    • 2

    By OneStop, January 10
    • 35 replies
    • 777 views
    • 
    • LaRetta
    • January 18

11. Simple Join

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

12. Set a flag using SQL through a portal

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

13. 4 Table SQL Search

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

14. 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
    • 322 views
    • 
    • bcooney
    • October 27, 2017

15. Sending Variable to WHERE IN in ExecuteSQL Not Working

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

16. Does FQL actually work?

    By losferwords@outgun.com, May 10, 2017   

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

17. GROUP BY in ExecuteSQL

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

18. Control Column Widths in ExecuteSql

    By vanderark1, June 8, 2017   

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

19. JSON parsing performance comparison

    By crayfish, June 6, 2017   

    • json
    • 5 replies
    • 855 views
    • 
    • MonkeybreadSoftware
    • June 8, 2017

20. 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
    • 394 views
    • 
    • comment
    • June 4, 2017

21. Large MSSQL data set error

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

22. JSON Error: Unterminated String

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

23. Help with cURL

    By nesor, May 19, 2017
    • 4 replies
    • 875 views
    • 
    • nesor
    • May 20, 2017

24. Insert from URL with new cURL Options

    By 357manch, May 16, 2017   

    • insert from url
    • json
    • (and 3 more)

      Tagged with:

      • insert from url
      • json
      • curl
      • dropbox
      • filemaker 16
    • 0 replies
    • 2,505 views
    • 
    • 357manch
    • May 16, 2017

25. Select sum related records

    By sal88, March 5, 2017   

    • sum
    • related
    • (and 1 more)

      Tagged with:

      • sum
      • related
      • sql
    • 1 reply
    • 622 views
    • 
    • beverly
    • May 5, 2017