FileMaker Query Language or FQL

288 topics in this forum

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

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

2. ExecuteSQL : Problem with delete

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

3. Trouble adding ORDER BY to SQL statement

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

4. WHERE IN clause with multiple alpha numeric values

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

5. Execute SQL count tweak needed

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

6. ExecuteSQL baby steps

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

7. SQL UPDATE, SQL INSERT or SQL Delete

   By capsprojectos, January 12, 2015   

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

8. Need help with a specific ExecuteSQL statement

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

9. mac Which Code Compliments FM

   By Karlos Fandango, January 6, 2015   

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

10. Need a Unique List of Contact Phone

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

11. Dynamically Replacing ExecuteSQL Arguments

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

12. ExecuteSQL and Portals

    By MSPJ, July 18, 2014   

    • portals
    • sql
    • (and 1 more)

       Tagged with:

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

13. How to Aggregate Data with Variable Dates

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

14. 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
    • 5k views
    • 
    • innodat
    • October 26, 2014

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

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

16. having problems with <> working

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

17. SQL Select will not update ?

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

18. doing maths with execute SQL in Filemaker

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

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

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

20. SQL date incorrect

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

21. Schema functions see external sources as local

    By LaRetta, September 3, 2014
    • 1 reply
    • 963 views
    • 
    • LaRetta
    • September 3, 2014

22. SQL Portal Sorting

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

23. Sql Syntax Help

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

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

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

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

    By madmac33, July 11, 2014   

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

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

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

27. 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.4k views
    • 
    • Wim Decorte
    • July 16, 2014

28. Help with ExecuteSQL Script Step, Date Range

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

29. SQL IF

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

30. Problem with IN sub clause

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

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

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

32. ExecuteSQL() list

    By doughemi, June 7, 2014   

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

33. ExecuteSQL issue

    By JOrdanMcC, June 5, 2014   

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

34. ExecuteSQL() and the separation model

    By normanicus, April 16, 2012
    • 19 replies
    • 6.7k views
    • 
    • Matthew F
    • June 3, 2014

35. Using 'IN' to query a list

    By James Gill, May 9, 2014
    • 5 replies
    • 1.8k views
    • 
    • James Gill
    • May 12, 2014