FileMaker Query Language or FQL

256 topics in this forum

1. group by and count

   By jhollingsworth, Sunday at 03:50 AM
   • 2 replies
   • 34 views
   • 
   • Lee Smith
   • 23 hours ago

2. Non-alphanumeric name field syntax

   By TeacherEd, April 5
   • 2 replies
   • 109 views
   • 
   • TeacherEd
   • April 6

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

   By Tom R., March 28   

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

4. FM SQL ExecuteSQL syntax troubles for IN clause

   By Justin Close, June 9, 2015   

   • sql
   • executesql
   • (and 1 more)

     Tagged with:

     • sql
     • executesql
     • in
   • 14 replies
   • 2,265 views
   • 
   • benmort81
   • March 9

5. Problems with SQL sum

   By Eli Walker, January 27   

   • sum
   • sql
   • (and 1 more)

     Tagged with:

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

6. SQL SLOW

   • 1
   • 2

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

7. Simple Join

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

8. Set a flag using SQL through a portal

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

9. 4 Table SQL Search

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

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

11. Sending Variable to WHERE IN in ExecuteSQL Not Working

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

12. Does FQL actually work?

    By losferwords@outgun.com, May 10, 2017   

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

13. GROUP BY in ExecuteSQL

    By abross86, June 13, 2014
    • 10 replies
    • 3,855 views
    • 
    • comment
    • July 1, 2017

14. Control Column Widths in ExecuteSql

    By vanderark1, June 8, 2017   

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

15. JSON parsing performance comparison

    By crayfish, June 6, 2017   

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

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

17. Large MSSQL data set error

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

18. JSON Error: Unterminated String

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

19. Help with cURL

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

20. 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,130 views
    • 
    • 357manch
    • May 16, 2017

21. Select sum related records

    By sal88, March 5, 2017   

    • sum
    • related
    • (and 1 more)

      Tagged with:

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

22. Repeating fields and brackets won't return any results

    By Electric_Soul, April 25, 2017
    • 3 replies
    • 369 views
    • 
    • Electric_Soul
    • April 27, 2017

23. ExecuteSQL fails to return matching record

    By Tom R., April 5, 2017   

    • executesql
    • 4 replies
    • 600 views
    • 
    • Tom R.
    • April 6, 2017

24. Execute SQL Insert Into

    By PELE, November 9, 2016
    • 7 replies
    • 924 views
    • 
    • Todd Dignan
    • January 26, 2017

25. Rental Inventory Availability

    By Ron Neville, January 2, 2017
    • 3 replies
    • 696 views
    • 
    • Wim Decorte
    • January 5, 2017