FileMaker Query Language or FQL

271 topics in this forum

1. Multiple AND OR conditions

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

2. Using Date Fields in ExecuteSQL

   By tarlschool, June 10, 2014   

   • date executesql
   • 5 replies
   • 1,830 views
   • 
   • Wim Decorte
   • December 8, 2019

3. SQL Sum and Group Question

   By Peter Barfield, November 11, 2019   

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

4. BE_FileMakerSQL: Select All from Variable Table Name

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

5. Execute SQL, Select Count Subquery

   By RNPaul, October 24, 2019
   • 4 replies
   • 156 views
   • 
   • RNPaul
   • October 26, 2019

6. How to reference another open database with BE_FileMakerSQL command

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

7. Sub-summarizing a List

   By Rich, August 28, 2019   

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

8. 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
   • 4,855 views
   • 
   • Pure Fool
   • June 27, 2019

9. Test for a used value using a global variable

   By Rich, May 9, 2019
   • 5 replies
   • 314 views
   • 
   • Rich
   • May 9, 2019

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

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

11. Cannot get a simple SUM

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

12. fmp17 ExecuteSQL() ORDER BY FIELD function

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

13. Counting two of the same values

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

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

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

15. sql help

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

16. Query data

    By Tom Assia, July 17, 2018
    • 2 replies
    • 395 views
    • 
    • Tom Assia
    • July 17, 2018

17. SQL to FQL rules

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

18. group by and count

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

19. Non-alphanumeric name field syntax

    By Rich, April 5, 2018
    • 1 reply
    • 590 views
    • 
    • Rich
    • April 6, 2018

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

    By Tom R., March 28, 2018   

    • executesql
    • 5 replies
    • 771 views
    • 
    • Fitch
    • March 30, 2018

21. Problems with SQL sum

    By Eli Walker, January 27, 2018   

    • sum
    • sql
    • (and 1 more)

       Tagged with:

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

22. SQL SLOW 1 2

    By OneStop, January 10, 2018
    • 35 replies
    • 3,109 views
    • 
    • LaRetta
    • January 18, 2018

23. Simple Join

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

24. Set a flag using SQL through a portal

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

25. 4 Table SQL Search

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