FileMaker Query Language or FQL

261 topics in this forum

1. Counting two of the same values

   By Rich, September 25
   • 5 replies
   • 365 views
   • 
   • comment
   • September 28

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

   By Rich, August 15
   • 3 replies
   • 263 views
   • 
   • Tom Assia
   • August 17

3. sql help

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

4. Query data

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

5. SQL to FQL rules

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

6. 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
   • 3,341 views
   • 
   • neutralbay
   • April 27

7. group by and count

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

8. Non-alphanumeric name field syntax

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

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

   By Tom R., March 28   

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

10. Problems with SQL sum

    By Eli Walker, January 27   

    • sum
    • sql
    • (and 1 more)

      Tagged with:

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

11. SQL SLOW

    • 1
    • 2

    By OneStop, January 10
    • 35 replies
    • 1,302 views
    • 
    • LaRetta
    • January 18

12. Simple Join

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

13. Set a flag using SQL through a portal

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

14. 4 Table SQL Search

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

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

16. Sending Variable to WHERE IN in ExecuteSQL Not Working

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

17. Does FQL actually work?

    By losferwords@outgun.com, May 10, 2017   

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

18. GROUP BY in ExecuteSQL

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

19. Control Column Widths in ExecuteSql

    By vanderark1, June 8, 2017   

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

20. JSON parsing performance comparison

    By crayfish, June 6, 2017   

    • json
    • 5 replies
    • 1,050 views
    • 
    • MonkeybreadSoftware
    • June 8, 2017

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

22. Large MSSQL data set error

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

23. JSON Error: Unterminated String

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

24. Help with cURL

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

25. 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
    • 3,065 views
    • 
    • 357manch
    • May 16, 2017