FileMaker Query Language or FQL

290 topics in this forum

1. Need a tweak for the City field

   By 21st Century Man, April 10
   • 2 replies
   • 323 views
   • 
   • 21st Century Man
   • April 10

2. How/Where to insert ORDER BY command

   By Rich S, April 30, 2024
   • 4 replies
   • 1.7k views
   • 
   • Rich S
   • April 30, 2024

3. Need help with ESQL Syntax

   By Rich S, February 20, 2024
   • 8 replies
   • 1.2k views
   • 
   • Søren Dyhr
   • February 23, 2024

4. Any way to write to «FileMaker_Fields»?

   By gczychi, September 1, 2023
   • 1 reply
   • 1.4k views
   • 
   • gczychi
   • September 1, 2023

5. SQL date format

   By Amedeo, February 24, 2023
   • 4 replies
   • 2.2k views
   • 
   • rivet
   • March 14, 2023

6. Dots to indicate an alias or something?

   By David Nelson, July 31, 2013
   • 7 replies
   • 3.6k views
   • 
   • tonyedented
   • April 20, 2022

7. ExecuteSQL Grouping with CASE

   By V8S, September 11, 2021
   • 6 replies
   • 1.8k views
   • 
   • V8S
   • September 11, 2021

8. SQL Date Range

   By madman411, August 26, 2021
   • 10 replies
   • 2.3k views
   • 
   • comment
   • September 1, 2021

9. Need a tweak for portal sorting within a script

   By Rich S, August 17, 2021
   • 2 replies
   • 1.1k views
   • 
   • Rich S
   • August 18, 2021

10. ExecuteSQL advise

    By stan111, June 1, 2021
    • 4 replies
    • 1.3k views
    • 
    • printdrive
    • June 24, 2021

11. SQL help

    By madman411, May 17, 2021
    • 2 replies
    • 969 views
    • 
    • madman411
    • May 17, 2021

12. What is the consensus for doing foreach in FQL?

    By ggt667, March 15, 2021
    • 0 replies
    • 698 views
    • 
    • ggt667
    • March 15, 2021

13. ExecuteSQL to find records in table and related tables

    By Solvax, December 30, 2020
    • 4 replies
    • 1.7k views
    • 
    • Solvax
    • December 30, 2020

14. Executesql to show the sum in one row.

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

15. Query where both table and field names contain spaces

    By kfeete, August 19, 2020
    • 7 replies
    • 2.2k views
    • 
    • kfeete
    • August 21, 2020

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

    By gczychi, July 25, 2020
    • 0 replies
    • 1k views
    • 
    • gczychi
    • July 25, 2020

17. Simple JOIN Problem

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

18. ExecuteSQL GROUP BY and HAVING clauses issue

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

19. 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
    • 3.2k views
    • 
    • comment
    • March 30, 2020

20. Parsing a date to ExecuteSQL SUM syntax

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

21. Multiple AND OR conditions

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

22. Using Date Fields in ExecuteSQL

    By tarlschool, June 10, 2014   

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

23. SQL Sum and Group Question

    By Peter Barfield, November 11, 2019   

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

24. BE_FileMakerSQL: Select All from Variable Table Name

    By Will_Logic, October 27, 2019
    • 2 replies
    • 1.5k views
    • 
    • Will_Logic
    • October 28, 2019

25. Execute SQL, Select Count Subquery

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

26. How to reference another open database with BE_FileMakerSQL command

    By Will_Logic, October 21, 2019
    • 6 replies
    • 1.6k views
    • 
    • comment
    • October 21, 2019

27. Sub-summarizing a List

    By Rich, August 28, 2019   

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

28. 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
    • 12.6k views
    • 
    • Pure Fool
    • June 27, 2019

29. Test for a used value using a global variable

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

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

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

31. Cannot get a simple SUM

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

32. fmp17 ExecuteSQL() ORDER BY FIELD function

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

33. Counting two of the same values

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

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

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

35. sql help

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