FileMaker Query Language or FQL

279 topics in this forum

1. ExecuteSQL to find records in table and related tables

   By Solvax, December 30, 2020
   • 4 replies
   • 57 views
   • 
   • Solvax
   • December 30, 2020

2. Executesql to show the sum in one row.

   By Raj Toofanny, November 14, 2020
   • 5 replies
   • 107 views
   • 
   • comment
   • November 17, 2020

3. Query where both table and field names contain spaces

   By kfeete, August 19, 2020
   • 7 replies
   • 146 views
   • 
   • kfeete
   • August 21, 2020

4. INSERT INTO ON DUPLICATE KEY UPDATE -- Possible?

   By gczychi, July 25, 2020
   • 0 replies
   • 64 views
   • 
   • gczychi
   • July 25, 2020

5. Simple JOIN Problem

   By gczychi, July 16, 2020
   • 2 replies
   • 158 views
   • 
   • gczychi
   • July 16, 2020

6. ExecuteSQL GROUP BY and HAVING clauses issue

   By alonjr, May 4, 2020
   • 12 replies
   • 2.1k views
   • 
   • alonjr
   • May 5, 2020

7. ExecuteSQL: How do I sort my columns by count value, but only display the value in the results?

   By Jay86, March 29, 2020
   • 5 replies
   • 1.8k views
   • 
   • comment
   • March 30, 2020

8. Parsing a date to ExecuteSQL SUM syntax

   By Greg Hains, February 23, 2020
   • 4 replies
   • 1.9k views
   • 
   • Greg Hains
   • February 24, 2020

9. Multiple AND OR conditions

   By V8S, December 13, 2019
   • 3 replies
   • 2.1k views
   • 
   • Fitch
   • December 17, 2019

10. Using Date Fields in ExecuteSQL

    By tarlschool, June 10, 2014   

    • date executesql
    • 5 replies
    • 3.9k views
    • 
    • Wim Decorte
    • December 8, 2019

11. SQL Sum and Group Question

    By Peter Barfield, November 11, 2019   

    • sql
    • sum
    • 18 replies
    • 2.1k views
    • 
    • Peter Barfield
    • November 12, 2019

12. BE_FileMakerSQL: Select All from Variable Table Name

    By Will_Logic, October 27, 2019
    • 2 replies
    • 342 views
    • 
    • Will_Logic
    • October 28, 2019

13. Execute SQL, Select Count Subquery

    By RNPaul, October 24, 2019
    • 4 replies
    • 2.1k views
    • 
    • RNPaul
    • October 26, 2019

14. How to reference another open database with BE_FileMakerSQL command

    By Will_Logic, October 21, 2019
    • 6 replies
    • 297 views
    • 
    • comment
    • October 21, 2019

15. Sub-summarizing a List

    By Rich, August 28, 2019   

    • FSQL
    • sub-summary report
    • 8 replies
    • 2.1k views
    • 
    • Rich
    • August 29, 2019

16. FM SQL ExecuteSQL syntax troubles for IN clause

    By Justin Close, June 9, 2015   

    • sql
    • executesql
    • (and 1 more)

       Tagged with:

      • sql
      • executesql
      • in
    • 22 replies
    • 7.7k views
    • 
    • Pure Fool
    • June 27, 2019

17. Test for a used value using a global variable

    By Rich, May 9, 2019
    • 5 replies
    • 2k views
    • 
    • Rich
    • May 9, 2019

18. Sum calc tweak needed -- I know I'm close...

    By Rich, April 12, 2019
    • 4 replies
    • 2k views
    • 
    • comment
    • April 16, 2019

19. Cannot get a simple SUM

    By filemakerdeveloper40, January 19, 2019
    • 4 replies
    • 2.1k views
    • 
    • Ocean West
    • January 30, 2019

20. fmp17 ExecuteSQL() ORDER BY FIELD function

    By dwdata, December 28, 2018
    • 3 replies
    • 3.1k views
    • 
    • dwdata
    • January 1, 2019

21. Counting two of the same values

    By Rich, September 25, 2018
    • 5 replies
    • 2.4k views
    • 
    • comment
    • September 28, 2018

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

    By Rich, August 15, 2018
    • 3 replies
    • 2.1k views
    • 
    • Tom Assia
    • August 17, 2018

23. sql help

    By shredded, July 31, 2018
    • 4 replies
    • 2.1k views
    • 
    • Fitch
    • August 2, 2018

24. Query data

    By Tom Assia, July 17, 2018
    • 2 replies
    • 1.5k views
    • 
    • Tom Assia
    • July 17, 2018

25. SQL to FQL rules

    By normanicus, July 6, 2018
    • 2 replies
    • 2k views
    • 
    • normanicus
    • July 8, 2018

26. group by and count

    By jhollingsworth, April 22, 2018
    • 2 replies
    • 1.7k views
    • 
    • Lee Smith
    • April 23, 2018

27. Non-alphanumeric name field syntax

    By Rich, April 5, 2018
    • 1 reply
    • 1.8k views
    • 
    • Rich
    • April 6, 2018

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

    By Tom R., March 28, 2018   

    • executesql
    • 5 replies
    • 2.2k views
    • 
    • Fitch
    • March 30, 2018

29. Problems with SQL sum

    By ehwalker, January 27, 2018   

    • sum
    • sql
    • (and 1 more)

       Tagged with:

      • sum
      • sql
      • join
    • 4 replies
    • 2.2k views
    • 
    • bcooney
    • January 28, 2018

30. SQL SLOW 1 2

    By OneStop, January 10, 2018
    • 35 replies
    • 5.2k views
    • 
    • LaRetta
    • January 18, 2018

31. Simple Join

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

32. Set a flag using SQL through a portal

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

33. 4 Table SQL Search

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

34. 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
    • 1.3k views
    • 
    • bcooney
    • October 27, 2017

35. Sending Variable to WHERE IN in ExecuteSQL Not Working

    By SRayNoriega, October 11, 2017
    • 5 replies
    • 2.2k views
    • 
    • SRayNoriega
    • October 17, 2017