We have reset all users FileMaker related profile fields. Please take the opportunity to update your information,  this will provide background to members whom read your posts. Click here.

Jump to content


  • Content count

  • Joined

  • Last visited

  • Days Won


beverly last won the day on June 22 2016

beverly had the most liked content!

Community Reputation

22 Excellent

About beverly

  • Rank

Profile Information

  • Title
    Web and Database Developer
  • Gender
    Not Telling
  • Location
    in the ether

Recent Profile Visitors

5,582 profile views
  1. Does FQL actually work?

    Use the files (builder or explorer) to help you write the queries. beverly
  2. Large MSSQL data set error

    Set up a View in the MySQL and narrow your set first? Is that what you mean by What about this does not work? beverly
  3. Does FQL actually work?

    The fm_sql_reference (versions 13, 14, 15, & 16!) is only partially helpful. It applies more for using FM as an ODBC source. The "missing" reference is a compliation of many developers pounding (testing) the heck out of the ExecuteSQL function. What works, what doesn't. Get the PDF and the example files. Read the comments from others on the blog. Kevin (and others) have a ton more blogs on ExecuteSQL! And there are a few "helper" files that will guide you in writing the queries correctly (here are the current/correct links): SQL Builder (this forum) http://fmforums.com/forum/files/file/25-sql-builder/ SQL Explorer (seedcode) https://www.seedcode.com/filemaker-sql-explorer/ And if you need a Japanese version of the "missing" reference? http://notonlyfilemaker.com/2014/01/missing-executesql/ beverly
  4. the problem may well come from limitations in the ExecuteSQL function. Nested functions with the aggregates ( SUM, COUNT, etc.) don't always work as expected. You may well do the SUM as a caclulation in Clients (use ExecuteSQL) to get the time in the last 30 days. Or use a Let() statement to get the sum of the time (no join needed) in the last 30 days and push to a variable that can be then divided by the Seats. Use this field to FIND the Client with the "most". I probably would NOT use a calculation (unstored), but a looping script to Set Field.

    IMPORT does NOT require to know how many records are being imported (not for tab, not for csv, not for XML). Thanks for the alternatives, guys. OP still needs to learn the XPATH and XSLT to understand what we've advised. beverly

    1. the elements in the xml source do NOT match the elements "called" in the XSLT what is current/id/@value ? when the source has data/post/id learn about the basics of XSLT and XPATH: https://www.w3schools.com/xml/xpath_intro.asp https://www.w3schools.com/xml/xsl_intro.asp <COL><DATA><xsl:value-of select="./id"/></COL></DATA> 2. to "loop" the xsl:for-each is used around the ROW elements in your XSLT and the select needs to be a valid XPATH, such as data/post so that you will get one row/record imported with everly post element in your XML source <xsl:for-each select="data/post"> <ROW> <COL><DATA><xsl:value-of select="./id"/></DATA></COL> ..... </ROW> </xsl:for-each> beverly
  7. Is anyone making a living off FM?

    due to FM being one way to connect otherwise unconnected systems, many of us are versed in other systems as well. I speak web, I speak SQL. Of my job, 50% is FileMaker projects (web and non-web). But surprise, SURPRISE! many of the 'non-FileMaker' jobs/work may get some FM just because it's easy to use. Perhaps planning the next big web project is done with FM. Or 'the book" - a whole bunch was stored in FM for sorting searching, etc. Short answer: yes
  8. This is a X-post on FM Community: https://community.filemaker.com/message/658922 Please see all replies there before duplicating here. While there may be people here that have answers different, it's important to let everyone know you have cross-posted to more than one forum. Thanks!
  9. SVG Icon Manager

    So this IS an old thread, but still valuable! Is there a way to IMPORT the SVG files (a folder) that we can find "out there", so we can study them and verify that they are FMP-icon-ready? Thanks!
  10. Completely lost with ExecuteSQL

    You cannot have spaces in names try \"Cost Price\"
  11. + wim and the third option by webko. ESS is a "two-way sync" if you will with FM and the MySQL. you can push or pull data between the two. If the data is in a FileMaker table (TO), then Set Field with it into the MySQL table (TO). ESS makes the data in the external SQL source behave much like any other "native" table in FileMaker. if you can move data from one native table to another in FileMaker, you can do the same with ESS (provided you have the proper permissions, of course!) NO SQL commands (via xDBC) or XML/PHP needed. in addition, should you wish, you can use Import and Execute SQL script steps to exchange data between FM tables and SQL tables (not ESS, but SQL queries) beverly
  12. Execute SQL Insert Into

    yep on webko and wim! as I said, a query is TEXT. however you can calculate (or script gather) the text to make the query work for single or multiple records is ok. I have used both methods (even before there was "ESS")! beverly
  13. Server 15.0v2 Updater

    Same link as above for updater FMS 15.0.3. Release notes: http://help.filemaker.com/app/answers/detail/a_id/16211/ beverly
  14. you can use EvaluationError() around your ExecuteSQL() to see if a number value is returned. another method to test (if you have FMPAdvanced (for using the DataViewer): https://www.teamdf.com/blogs/unlocking-hidden-error-messages-in-the-executesql-function/ beverly
  15. Execute SQL Insert Into

    the query is a text result and as Wim says will need to calculate out correctly for the SQL db (and the driver) to understand it!