FileMaker Query Language or FQL

290 topics in this forum

1. Small SQL Query Help

   By Justin P., March 13, 2015   

   • sql
   • 3 replies
   • 2.2k views
   • 
   • Justin P.
   • March 16, 2015

2. pc ExecuteSQL - does it not follow portal filtering processes?

   By Stu412, March 9, 2015   

   • sql
   • portal
   • (and 1 more)

      Tagged with:

     • sql
     • portal
     • executesql
   • 4 replies
   • 3.5k views
   • 
   • Kris M
   • March 9, 2015

3. How can I create a SQL query that grabs all field names in all tables?

   By HALBURN, January 31, 2015
   • 4 replies
   • 3.7k views
   • 
   • HALBURN
   • March 7, 2015

4. ExecuteSQL : Problem with delete

   By Gomme, January 8, 2015
   • 2 replies
   • 2.6k views
   • 
   • beverly
   • March 6, 2015

5. Trouble adding ORDER BY to SQL statement

   By DeathRobot, February 10, 2015
   • 6 replies
   • 2.1k views
   • 
   • beverly
   • March 6, 2015

6. WHERE IN clause with multiple alpha numeric values

   By Jalz, February 24, 2015
   • 2 replies
   • 1.7k views
   • 
   • bcooney
   • February 24, 2015

7. Execute SQL count tweak needed

   By Rich S, February 7, 2015
   • 5 replies
   • 3.5k views
   • 
   • Rich S
   • February 9, 2015

8. ExecuteSQL baby steps

   By Craig Wall, February 3, 2015
   • 4 replies
   • 1.3k views
   • 
   • Craig Wall
   • February 4, 2015

9. SQL UPDATE, SQL INSERT or SQL Delete

   By capsprojectos, January 12, 2015   

   • sql
   • 0 replies
   • 2.7k views
   • 
   • capsprojectos
   • January 12, 2015

10. Need help with a specific ExecuteSQL statement

    By truelifeajf, January 10, 2015
    • 4 replies
    • 1.7k views
    • 
    • truelifeajf
    • January 10, 2015

11. mac Which Code Compliments FM

    By Karlos Fandango, January 6, 2015   

    • php
    • mysql
    • 7 replies
    • 1.8k views
    • 
    • Karlos Fandango
    • January 7, 2015

12. Need a Unique List of Contact Phone

    By Ocean West, January 1, 2015
    • 3 replies
    • 1.4k views
    • 
    • Lee Smith
    • January 1, 2015

13. Dynamically Replacing ExecuteSQL Arguments

    By James Gill, November 21, 2014
    • 0 replies
    • 2.8k views
    • 
    • James Gill
    • November 21, 2014

14. ExecuteSQL and Portals

    By MSPJ, July 18, 2014   

    • portals
    • sql
    • (and 1 more)

       Tagged with:

      • portals
      • sql
      • executesql
    • 5 replies
    • 4.4k views
    • 
    • Aliraza142
    • November 17, 2014

15. How to Aggregate Data with Variable Dates

    By jprice, October 25, 2014
    • 3 replies
    • 1.6k views
    • 
    • Lee Smith
    • November 8, 2014

16. SQL instead of unstored calc to display items of value list?

    By innodat, October 24, 2014   

    • sql
    • unstored calculation
    • (and 1 more)

       Tagged with:

      • sql
      • unstored calculation
      • value list
    • 14 replies
    • 5.4k views
    • 
    • innodat
    • October 26, 2014

17. Displaying SQL result in table form (mimicking a portal)

    By rkass068, October 14, 2014
    • 7 replies
    • 3.7k views
    • 
    • Kris M
    • October 15, 2014

18. having problems with <> working

    By DLB, October 8, 2014
    • 5 replies
    • 1.4k views
    • 
    • Kris M
    • October 10, 2014

19. SQL Select will not update ?

    By "... you mean these fans?", October 3, 2014
    • 4 replies
    • 1.2k views
    • 
    • "... you mean these fans?"
    • October 3, 2014

20. doing maths with execute SQL in Filemaker

    By camacorp, September 29, 2014
    • 1 reply
    • 1.4k views
    • 
    • timdietrich
    • October 1, 2014

21. Help with inner joins to the same table 6 times

    By Jalz, September 29, 2014
    • 8 replies
    • 1.4k views
    • 
    • Jalz
    • September 29, 2014

22. SQL date incorrect

    By Charity, September 27, 2014
    • 7 replies
    • 1.6k views
    • 
    • Rick Whitelaw
    • September 29, 2014

23. Schema functions see external sources as local

    By LaRetta, September 3, 2014
    • 1 reply
    • 1.1k views
    • 
    • LaRetta
    • September 3, 2014

24. SQL Portal Sorting

    By DeathRobot, June 7, 2014
    • 9 replies
    • 3k views
    • 
    • robac
    • August 26, 2014

25. Sql Syntax Help

    By charlest, August 7, 2014
    • 5 replies
    • 2.1k views
    • 
    • beverly
    • August 9, 2014

26. Choose between two date ranges based on a check box

    By "... you mean these fans?", August 1, 2014
    • 25 replies
    • 4.3k views
    • 
    • eos
    • August 8, 2014

27. How to do a calculation on an aggregate function in an ExecuteSQL statement

    By madmac33, July 11, 2014   

    • sql
    • select
    • 6 replies
    • 4.6k views
    • 
    • otmar
    • July 21, 2014

28. Any advice on improving performance of a multi join ExecuteSQL command?

    By crayfish, July 16, 2014
    • 7 replies
    • 2.3k views
    • 
    • LaRetta
    • July 16, 2014

29. SQL Where not working with Aggregate function?

    By MSPJ, July 15, 2014   

    • sql
    • fql
    • (and 1 more)

       Tagged with:

      • sql
      • fql
      • aggregate
    • 6 replies
    • 2.6k views
    • 
    • Wim Decorte
    • July 16, 2014

30. Help with ExecuteSQL Script Step, Date Range

    By William Block, July 5, 2014
    • 3 replies
    • 2.5k views
    • 
    • jlamprecht
    • July 8, 2014

31. SQL IF

    By "... you mean these fans?", July 2, 2014
    • 4 replies
    • 1.7k views
    • 
    • Fitch
    • July 4, 2014

32. Problem with IN sub clause

    By P J, June 19, 2014
    • 2 replies
    • 1.9k views
    • 
    • P J
    • June 20, 2014

33. Is ExecuteSQL the best option for this design need?

    By argwallace, June 14, 2014
    • 6 replies
    • 1.6k views
    • 
    • David Jondreau
    • June 18, 2014

34. ExecuteSQL() list

    By doughemi, June 7, 2014   

    • executesql
    • 1 reply
    • 1.6k views
    • 
    • john renfrew
    • June 7, 2014

35. ExecuteSQL issue

    By JOrdanMcC, June 5, 2014   

    • executesql
    • filemaker13
    • 2 replies
    • 1.9k views
    • 
    • bruceR
    • June 5, 2014