FileMaker Query Language or FQL

247 topics in this forum

1. Sending Variable to WHERE IN in ExecuteSQL Not Working

   By SRayNoriega, October 11
   • 5 replies
   • 142 views
   • 
   • SRayNoriega
   • Tuesday at 04:52 PM

2. Does FQL actually work?

   By losferwords@outgun.com, May 10   

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

3. GROUP BY in ExecuteSQL

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

4. Control Column Widths in ExecuteSql

   By vanderark1, June 8   

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

5. JSON parsing performance comparison

   By crayfish, June 6   

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

6. 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
   • 228 views
   • 
   • comment
   • June 4

7. Large MSSQL data set error

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

8. JSON Error: Unterminated String

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

9. Help with cURL

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

10. 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
    • 1,021 views
    • 
    • 357manch
    • May 16

11. Select sum related records

    By sal88, March 5   

    • sum
    • related
    • (and 1 more)

      Tagged with:

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

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

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

13. ExecuteSQL fails to return matching record

    By Tom R., April 5   

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

14. 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,704 views
    • 
    • Diver
    • February 28

15. Execute SQL Insert Into

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

16. Rental Inventory Availability

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

17. How to average a subquery

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

18. Completely lost with ExecuteSQL

    By Peter Barfield, November 26, 2016   

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

19. ExecuteSQL Relationship Issue?

    By scain101, November 16, 2016   

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

20. Search script and ExecuteSQL

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

21. 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
    • 709 views
    • 
    • DataLackey
    • October 28, 2016

22. Group and summarize using ExecuteSQL ( )

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

23. ExecuteSQL and Running Totals

    By Sam Reicht, June 26, 2016   

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

24. Simple ExecuteSQL expression is wrong.

    By doughemi, July 20, 2016   

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

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

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