Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

FileMaker Query Language or FQL

Discussions about Execute SQL function, and SQL syntax for your your database logic.

289 topics in this forum

  1. How/Where to insert ORDER BY command

    By Rich S,
    • 4 replies
    • 770 views

  2. Need help with ESQL Syntax

    By Rich S,
    • 8 replies
    • 773 views

  3. Any way to write to «FileMaker_Fields»?

    By gczychi,
    • 1 reply
    • 1.3k views

  4. SQL date format

    By Amedeo,
    • 4 replies
    • 1.7k views

  5. Dots to indicate an alias or something?

    By David Nelson,
    • 7 replies
    • 3.3k views

  6. ExecuteSQL Grouping with CASE

    By V8S,
    • 6 replies
    • 1.4k views

  7. SQL Date Range

    By madman411,
    • 10 replies
    • 1.9k views

  8. Need a tweak for portal sorting within a script

    By Rich S,
    • 2 replies
    • 999 views

  9. ExecuteSQL advise

    By stan111,
    • 4 replies
    • 1k views

  10. SQL help

    By madman411,
    • 2 replies
    • 795 views

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

    By ggt667,
    • 0 replies
    • 591 views

  12. ExecuteSQL to find records in table and related tables

    By Solvax,
    • 4 replies
    • 1.4k views

  13. Executesql to show the sum in one row.

    By Raj Toofanny,
    • 5 replies
    • 1.5k views

  14. Query where both table and field names contain spaces

    By kfeete,
    • 7 replies
    • 1.7k views

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

    By gczychi,
    • 0 replies
    • 750 views

  16. Simple JOIN Problem

    By gczychi,
    • 2 replies
    • 864 views

  17. ExecuteSQL GROUP BY and HAVING clauses issue

    By alonjr,
    • 12 replies
    • 3.5k views

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

    By Jay86,
    • 5 replies
    • 2.9k views

  19. Parsing a date to ExecuteSQL SUM syntax

    By Greg Hains,
    • 4 replies
    • 2.8k views

  20. Multiple AND OR conditions

    By V8S,
    • 3 replies
    • 2.8k views

  21. Using Date Fields in ExecuteSQL

    By tarlschool,   
    • 5 replies
    • 5.6k views

  22. SQL Sum and Group Question

    By Peter Barfield,   
    • 18 replies
    • 5.2k views

  23. BE_FileMakerSQL: Select All from Variable Table Name

    By Will_Logic,
    • 2 replies
    • 1.3k views

  24. Execute SQL, Select Count Subquery

    By RNPaul,
    • 4 replies
    • 3.8k views

  25. How to reference another open database with BE_FileMakerSQL command

    By Will_Logic,
    • 6 replies
    • 1.4k views

  26. Sub-summarizing a List

    By Rich,   
    • 8 replies
    • 3.3k views

  27. FM SQL ExecuteSQL syntax troubles for IN clause

    By Justin Close,   
    • 22 replies
    • 11.9k views

  28. Test for a used value using a global variable

    By Rich,
    • 5 replies
    • 2.6k views

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

    By Rich,
    • 4 replies
    • 3.1k views

  30. Cannot get a simple SUM

    By filemakerdeveloper40,
    • 4 replies
    • 3.1k views

  31. ExecuteSQL() ORDER BY FIELD function

    By dwdata,
    • 3 replies
    • 5.1k views

  32. Counting two of the same values

    By Rich,
    • 5 replies
    • 3k views

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

    By Rich,
    • 3 replies
    • 2.9k views

  34. sql help

    By shredded,
    • 4 replies
    • 2.9k views

  35. Query data

    By Tom Assia,
    • 2 replies
    • 2.7k views

  • Recently Browsing   0 members

    • No registered users viewing this page.

  • Who's Online   1 Member, 0 Anonymous, 63 Guests (See full list)

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.

  I accept