FileMaker Query Language or FQL

246 topics in this forum

1. Does FQL actually work?

   By losferwords@outgun.com, May 10   

   • sql
   • fql
   • 17 replies
   • 830 views
   • 
   • Wim Decorte
   • August 15

2. GROUP BY in ExecuteSQL

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

3. Control Column Widths in ExecuteSql

   By vanderark1, June 8   

   • executesql
   • 17 replies
   • 404 views
   • 
   • ggt667
   • June 12

4. JSON parsing performance comparison

   By crayfish, June 6   

   • json
   • 5 replies
   • 343 views
   • 
   • MonkeybreadSoftware
   • June 8

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

   By Rachel, June 4   

   • portal
   • executesql
   • (and 2 more)

     Tagged with:

     • portal
     • executesql
     • report
     • subsummary
   • 2 replies
   • 181 views
   • 
   • comment
   • June 4

6. Large MSSQL data set error

   By CoZiMan, May 26
   • 5 replies
   • 169 views
   • 
   • beverly
   • May 26

7. JSON Error: Unterminated String

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

8. Help with cURL

   By nesor, May 19
   • 4 replies
   • 561 views
   • 
   • nesor
   • May 20

9. Insert from URL with new cURL Options

   By 357manch, May 16   

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

     Tagged with:

     • insert from url
     • json
     • curl
     • dropbox
     • filemaker 16
   • 0 replies
   • 658 views
   • 
   • 357manch
   • May 16

10. Select sum related records

    By sal88, March 5   

    • sum
    • related
    • (and 1 more)

      Tagged with:

      • sum
      • related
      • sql
    • 1 reply
    • 294 views
    • 
    • beverly
    • May 5

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

    By Electric_Soul, April 25
    • 3 replies
    • 224 views
    • 
    • Electric_Soul
    • April 27

12. ExecuteSQL fails to return matching record

    By Tom R., April 5   

    • executesql
    • 4 replies
    • 313 views
    • 
    • Tom R.
    • April 6

13. FM SQL ExecuteSQL syntax troubles for IN clause

    By Justin Close, June 9, 2015   

    • sql
    • executesql
    • (and 1 more)

      Tagged with:

      • sql
      • executesql
      • in
    • 13 replies
    • 1,589 views
    • 
    • Diver
    • February 28

14. Execute SQL Insert Into

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

15. Rental Inventory Availability

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

16. How to average a subquery

    By madmac33, December 28, 2016
    • 7 replies
    • 404 views
    • 
    • jbante
    • December 30, 2016

17. Completely lost with ExecuteSQL

    By Peter Barfield, November 26, 2016   

    • executesql
    • 5 replies
    • 374 views
    • 
    • comment
    • November 27, 2016

18. ExecuteSQL Relationship Issue?

    By scain101, November 16, 2016   

    • sql
    • 3 replies
    • 410 views
    • 
    • scain101
    • November 19, 2016

19. Search script and ExecuteSQL

    By JohanA, October 27, 2016
    • 7 replies
    • 447 views
    • 
    • JohanA
    • October 30, 2016

20. Load Data Local Infile SQL Query

    By DataLackey, October 25, 2016   

    • sql
    • executesql
    • (and 3 more)

      Tagged with:

      • sql
      • executesql
      • mysql
      • external data source
      • amazon rds
    • 10 replies
    • 638 views
    • 
    • DataLackey
    • October 28, 2016

21. Group and summarize using ExecuteSQL ( )

    By Ron Cates, September 13, 2016
    • 2 replies
    • 345 views
    • 
    • Ron Cates
    • September 14, 2016

22. ExecuteSQL and Running Totals

    By Sam Reicht, June 26, 2016   

    • running total
    • sql
    • 3 replies
    • 513 views
    • 
    • beverly
    • September 14, 2016

23. Simple ExecuteSQL expression is wrong.

    By doughemi, July 20, 2016   

    • executesql
    • 6 replies
    • 582 views
    • 
    • beverly
    • September 14, 2016

24. SELECT WHERE first letter lowercase followed by any upper case letter

    By Ron Cates, August 5, 2016
    • 6 replies
    • 485 views
    • 
    • Ron Cates
    • August 30, 2016

25. SQL Query Error

    By Ron Neville, August 14, 2016   

    • sql
    • 6 replies
    • 619 views
    • 
    • Kevin Frank
    • August 15, 2016