FileMaker Query Language or FQL

289 topics in this forum

1. SQL custom ORDER BY

   By rivet, January 20, 2013
   • 3 replies
   • 2.2k views
   • 
   • dansmith65
   • January 20, 2013

2. Using IN clause with variable list

   By eoneon123, January 8, 2013
   • 1 reply
   • 1.6k views
   • 
   • dansmith65
   • January 8, 2013

3. FM 11 - Problems with correlated subquery in HAVING clause! No results

   By Electric_Soul, January 4, 2013   

   • having subquery
   • 0 replies
   • 1.2k views
   • 
   • Electric_Soul
   • January 4, 2013

4. Select Statement with Repeating fields

   By Todd Dignan, December 17, 2012   

   • repeating fields
   • 2 replies
   • 6k views
   • 
   • Todd Dignan
   • December 18, 2012

5. Importing from Filemaker to Filemaker using SQL query

   By flutegirl, December 10, 2012
   • 5 replies
   • 1.7k views
   • 
   • bcooney
   • December 11, 2012

6. Select top?

   By TVRV8S, November 26, 2012
   • 4 replies
   • 2.2k views
   • 
   • TVRV8S
   • November 29, 2012

7. Selecting repetition value of button via SQL

   By eoneon123, November 24, 2012
   • 6 replies
   • 2.5k views
   • 
   • eoneon123
   • November 27, 2012

8. SQL based Value Lists drawing upon multiple fields/tables?

   By eoneon123, November 22, 2012
   • 3 replies
   • 2k views
   • 
   • eoneon123
   • November 23, 2012

9. SQL SELECT with WHERE clause uses a checkbox field

   By eoneon123, November 16, 2012
   • 6 replies
   • 9.5k views
   • 
   • eoneon123
   • November 17, 2012

10. Problem with COUNT ( DISTINCT ... )

    By Lem Alpha, March 9, 2012
    • 7 replies
    • 4.6k views
    • 
    • Lem Alpha
    • November 9, 2012

11. ExecuteSQL Summaries

    By Tim Anderson, October 21, 2012
    • 6 replies
    • 1.8k views
    • 
    • Tim Anderson
    • November 1, 2012

12. SQL and Multiple WHERE clauses using a global variable

    By eoneon123, October 17, 2012
    • 5 replies
    • 6.7k views
    • 
    • eoneon123
    • October 31, 2012

13. Call stored procedure using ExecuteSQL?

    By m0nkey, October 29, 2012
    • 2 replies
    • 5.4k views
    • 
    • m0nkey
    • October 29, 2012

14. Using GetAs to retrieve container field

    By oleung, July 30, 2012
    • 4 replies
    • 3.4k views
    • 
    • beverly
    • October 13, 2012

15. Custom Functions for FQL

    By Kevin Frank, March 3, 2011
    • 5 replies
    • 5k views
    • 
    • beverly
    • October 12, 2012

16. how to link value lists with executesql parameters?

    By lw1990, September 23, 2012
    • 1 reply
    • 1.7k views
    • 
    • adellos
    • September 30, 2012

17. Using ExecuteSQL Query in Stored Claculations

    By jprice, September 16, 2012
    • 1 reply
    • 1.5k views
    • 
    • David Jondreau
    • September 17, 2012

18. Performance tips for LIKE operator?

    By jbante, June 26, 2012
    • 13 replies
    • 7.4k views
    • 
    • Daniel Wood
    • August 30, 2012

19. Cannot get simple ExecuteSQL Query to run

    By James Gill, August 21, 2012
    • 2 replies
    • 1.4k views
    • 
    • James Gill
    • August 22, 2012

20. Sql debug

    By andries, July 28, 2012
    • 2 replies
    • 2.3k views
    • 
    • john renfrew
    • July 30, 2012

21. FM 12 ExecuteSQL statement not working...seems simple...

    By Justin Close, June 16, 2012
    • 9 replies
    • 4.7k views
    • 
    • Lee Smith
    • July 12, 2012

22. Nested selects

    By David Wikström, June 18, 2012
    • 0 replies
    • 1.3k views
    • 
    • David Wikström
    • June 18, 2012

23. Multiple Where conditions in ExecuteSQL

    By Bill Doerrfeld, June 15, 2012
    • 1 reply
    • 3.4k views
    • 
    • Bill Doerrfeld
    • June 16, 2012

24. ExecuteSQL from different file

    By George J., June 3, 2012
    • 2 replies
    • 2.1k views
    • 
    • mr_vodka
    • June 4, 2012

25. Accessing multiple fields returned by ExecuteSQL ( ) select statement

    By Tom R., May 21, 2012
    • 7 replies
    • 5.4k views
    • 
    • Tom R.
    • May 24, 2012

26. Getting Distinct ID's

    By Ocean West, May 23, 2012
    • 6 replies
    • 1.9k views
    • 
    • Ocean West
    • May 24, 2012

27. Trying to figure out the proper query...

    By Ocean West, May 20, 2012
    • 1 reply
    • 1.1k views
    • 
    • RalphL
    • May 20, 2012

28. Sql Sample Database

    By Walter-MainFrame, April 23, 2012
    • 1 reply
    • 1.8k views
    • 
    • mr_vodka
    • April 24, 2012

29. execute mySQL

    By dayzrespite, April 14, 2012
    • 1 reply
    • 2k views
    • 
    • RalphL
    • April 14, 2012

30. ExecuteSQL ( )

    By mr_vodka, April 4, 2012   

    • 12 sql fmp12
    • 8 replies
    • 6.4k views
    • 
    • Scott Howard
    • April 13, 2012

31. Execute Sql Function with ODBC to MySql

    By rivet, April 9, 2012
    • 2 replies
    • 2.1k views
    • 
    • rivet
    • April 10, 2012

32. Error 101 when using SQL plugin with ESS

    By devuser_tom, April 6, 2012
    • 2 replies
    • 1.4k views
    • 
    • Wim Decorte
    • April 8, 2012

33. Maximum length of a SQL statement in FQL

    By David Wikström, February 14, 2012
    • 7 replies
    • 2.3k views
    • 
    • David Wikström
    • February 25, 2012

34. Need SQL advice

    By William, January 31, 2012
    • 1 reply
    • 1.6k views
    • 
    • dansmith65
    • February 8, 2012

35. Problems with FQL Update

    By brian rich, December 21, 2011
    • 2 replies
    • 3.2k views
    • 
    • RalphL
    • December 21, 2011