FileMaker Query Language or FQL

290 topics in this forum

1. Nested SQL question

   By Mark Geerdes, August 16, 2013
   • 4 replies
   • 4k views
   • 
   • Fitch
   • August 21, 2013

2. SQL in FileMaker - PDF eBook

   By JamieLThompson, August 15, 2013
   • 0 replies
   • 2.5k views
   • 
   • JamieLThompson
   • August 15, 2013

3. ExecuteSQL with added string

   By jimlongo, August 12, 2013
   • 1 reply
   • 1.5k views
   • 
   • eos
   • August 12, 2013

4. ExecuteSQL with variable

   By jimlongo, August 10, 2013
   • 2 replies
   • 16.9k views
   • 
   • jimlongo
   • August 10, 2013

5. Field name inside of field?

   By Charity, August 9, 2013
   • 3 replies
   • 1.3k views
   • 
   • Charity
   • August 9, 2013

6. ExecuteSQL Where Not Equal Error

   By wlitzau, August 1, 2013
   • 8 replies
   • 6.5k views
   • 
   • wlitzau
   • August 8, 2013

7. Create new SQL row from filemaker

   By EBJ, August 7, 2013
   • 1 reply
   • 2k views
   • 
   • Lee Smith
   • August 7, 2013

8. General ExecuteSQL() questions...

   By Matt Klein, February 11, 2013
   • 2 replies
   • 1.9k views
   • 
   • beverly
   • July 26, 2013

9. ExecuteSQL Query

   By berniez, July 19, 2013
   • 6 replies
   • 1.9k views
   • 
   • beverly
   • July 26, 2013

10. Can I Calc. It? Trying to Compute %on Time

    By jhomer, July 18, 2013
    • 6 replies
    • 1.9k views
    • 
    • jhomer
    • July 24, 2013

11. SQL SELECT with variable repetition field as value

    By eoneon123, July 22, 2013
    • 1 reply
    • 3.6k views
    • 
    • Wim Decorte
    • July 22, 2013

12. ExecuteSQL as custom function?

    By David Nelson, July 8, 2013
    • 5 replies
    • 3.9k views
    • 
    • Darren Burgess
    • July 22, 2013

13. Send Event

    By Skeefu, July 19, 2013
    • 2 replies
    • 1.9k views
    • 
    • Wim Decorte
    • July 20, 2013

14. To write Stored Procedures in FileMaker

    By Deepak Kumar, July 19, 2013
    • 1 reply
    • 2.1k views
    • 
    • mr_vodka
    • July 19, 2013

15. Apparent bug with Union clause and subquery

    By alecgregory, May 30, 2013
    • 4 replies
    • 2.4k views
    • 
    • alecgregory
    • July 11, 2013

16. using all/any within WHERE parameter

    By eoneon123, July 6, 2013
    • 3 replies
    • 1.1k views
    • 
    • bruceR
    • July 7, 2013

17. Creating a summary table using sql

    By rkass068, June 10, 2013
    • 2 replies
    • 4k views
    • 
    • rkass068
    • June 11, 2013

18. ExecuteSql Aggregate function bug?

    By Breton Tillinghast, May 27, 2013
    • 1 reply
    • 1.5k views
    • 
    • john renfrew
    • May 28, 2013

19. Display list in Portal using ExecuteSQL

    By Bryan VonDeylen, May 20, 2013
    • 3 replies
    • 4.5k views
    • 
    • mr_vodka
    • May 20, 2013

20. ESQL JOIN not working?

    By Justin Close, May 10, 2013
    • 3 replies
    • 2.3k views
    • 
    • Fitch
    • May 10, 2013

21. Using ESQL to SUM() a time field?

    By Justin Close, May 9, 2013
    • 1 reply
    • 3.6k views
    • 
    • mr_vodka
    • May 10, 2013

22. Interesting quirk for unrelated field reference in field definition

    By David Jondreau, May 1, 2013
    • 1 reply
    • 1.9k views
    • 
    • Josh Ormond
    • May 1, 2013

23. Problem with a numerical SQL function

    By n7mafia, April 25, 2013
    • 14 replies
    • 1.9k views
    • 
    • Wim Decorte
    • April 28, 2013

24. ExecuteSQL(), JOIN, WHERE, SUM, and GROUP BY

    By David Jondreau, April 26, 2013
    • 6 replies
    • 9.1k views
    • 
    • Wim Decorte
    • April 26, 2013

25. Where to use ExecuteSQL

    By Rick Whitelaw, April 17, 2013
    • 13 replies
    • 19.4k views
    • 
    • jbante
    • April 24, 2013

26. FileMaker SQL Sugar

    By Ocean West, April 7, 2013
    • 0 replies
    • 1.7k views
    • 
    • Ocean West
    • April 7, 2013

27. Generate Mailing Labels

    By Ocean West, March 29, 2013
    • 1 reply
    • 1.1k views
    • 
    • LVie
    • March 29, 2013

28. SQL recursion

    By fabriceN, August 1, 2012
    • 5 replies
    • 2.6k views
    • 
    • fabriceN
    • March 27, 2013

29. ID list for deleted records in a syncing solution

    By Eden Morris, March 8, 2013
    • 0 replies
    • 1.8k views
    • 
    • Eden Morris
    • March 8, 2013

30. multiple selects or one select with multiple values

    By Joost Miltenburg, February 20, 2013
    • 0 replies
    • 1.2k views
    • 
    • Joost Miltenburg
    • February 20, 2013

31. ExecuteSQL pk grab

    By Chris Scalzi, February 13, 2013
    • 4 replies
    • 2k views
    • 
    • dansmith65
    • February 15, 2013

32. LEFT OUTER JOIN not working?

    By fmgenius, February 5, 2013
    • 1 reply
    • 2.8k views
    • 
    • beverly
    • February 8, 2013

33. ExecuteSQL failing

    By Justin Close, July 19, 2012
    • 6 replies
    • 5.5k views
    • 
    • Darren Burgess
    • February 8, 2013

34. Dynamic SELECT using Let when WHERE clause might = anything

    By eoneon123, February 4, 2013
    • 2 replies
    • 1.2k views
    • 
    • eoneon123
    • February 4, 2013

35. Getting a list of Anniversaries

    By Ocean West, February 3, 2013
    • 3 replies
    • 1.4k views
    • 
    • dansmith65
    • February 3, 2013