FileMaker Query Language or FQL

239 topics in this forum

1. GROUP BY in ExecuteSQL

   By abross86, June 13, 2014
   • 10 replies
   • 2,915 views
   • 
   • comment
   • July 1

2. Control Column Widths in ExecuteSql

   By vanderark1, June 8   

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

3. 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
   • 141 views
   • 
   • comment
   • June 4

4. Does FQL actually work?

   By losferwords@outgun.com, May 10   

   • sql
   • fql
   • 8 replies
   • 287 views
   • 
   • Lee Smith
   • May 29

5. Large MSSQL data set error

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

6. Select sum related records

   By sal88, March 5   

   • sum
   • related
   • (and 1 more)

     Tagged with:

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

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

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

8. ExecuteSQL fails to return matching record

   By Tom R., April 5   

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

9. 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,506 views
   • 
   • Diver
   • February 28

10. Execute SQL Insert Into

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

11. How to average a subquery

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

12. Completely lost with ExecuteSQL

    By Peter Barfield, November 26, 2016   

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

13. ExecuteSQL Relationship Issue?

    By scain101, November 16, 2016   

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

14. Search script and ExecuteSQL

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

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

16. Group and summarize using ExecuteSQL ( )

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

17. ExecuteSQL and Running Totals

    By Sam Reicht, June 26, 2016   

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

18. Simple ExecuteSQL expression is wrong.

    By doughemi, July 20, 2016   

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

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

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

20. SQL Query Error

    By Ron Neville, August 14, 2016   

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

21. New to SQL

    By Ron Neville, August 2, 2016
    • 3 replies
    • 344 views
    • 
    • Fitch
    • August 2, 2016

22. Execute SQL across databases

    By rpan, August 2, 2016
    • 2 replies
    • 413 views
    • 
    • rpan
    • August 2, 2016

23. Criteria on other side of join

    By sal88, July 31, 2016   

    • join
    • sql
    • (and 2 more)

      Tagged with:

      • join
      • sql
      • executesql
      • criteria
    • 0 replies
    • 426 views
    • 
    • sal88
    • July 31, 2016

24. Help with executeSQL and Like ?

    By JoVac, June 21, 2016
    • 2 replies
    • 354 views
    • 
    • JoVac
    • June 23, 2016

25. Defining Column Width within SQL Select

    By Mr. Ignoramus, May 21, 2016
    • 19 replies
    • 896 views
    • 
    • comment
    • June 22, 2016