1 Screenshot

About This File

This SQL code generator will generate ExecuteSQL() code for FileMaker allowing you to use unsafe field names and make changes to database schema after making the code. If you have feedback of any kind such as bugs or feature requests please visit the support topic for this file.

UPDATE 5/23/2012

  • Code window opens at start up
  • Disabled field name check at start up.
  • No bug fixes ( please send bug reports in the support topic )

UPDATE 5/23/2012

  • Added Settings page
  • Added Loading page
  • Fixed bug in code window

UPDATE 5/16/2012

  • Misc bug fixes and UI tweaks

UPDATE 5/15/2012

  • Table and Field ID's are now tracked allowing for auto repairing of table and field names after schema changes
  • Misc bug fixes and UI tweaks

UPDATE 5/13/2012

  • All new UI
  • Support for more functions

UPDATE 5/9/2012 (v1.0?!)

  • Support for FROM and Right JOIN Table Aliases
  • Misc. bug fixes
  • Tweaked the UI

UPDATE 5/5/2012

  • You can now group by a field without displaying it in the results
  • Added JOIN Example

UPDATE 5/4/2012

  • Added a Statement Creation Wizard ( v07 )
  • Improved Dynamic Parameters Support. ( v0601 )
  • Support for Dynamic Parameters.

UPDATE 5/2/2012 ( Back From Vacation! )

  • Starting Value navigation buttons.
  • Output code display options can be set at the bottom of the details layout.

UPDATE 4/29/2012

  • Added warning icons that show up if a field no longer exists so that schema changes can be easily tracked down.
  • Added starting value and maximum results in the results window.

UPDATE 4/25/2012

  • Fixed "AND OR" Bug
  • Insert functions into select field lines
  • Adding a function to a WHERE line will change it into a HAVING line
  • Manual entry will populate when entered on SELECT and WHERE/HAVING lines

UPDATE 4/24/2012

  • Fixed bug in ORDER BY
  • Table Occurrences are now all that is needed to populate the field list.

UPDATE 4/23/2012

  • Added "Get at Date or Time" Check box for SELECT lines and an example of how it works.
  • Statements can be assigned categories
  • Simplified the code when there is no JOIN statement
  • Code now has formatting to make reading the code easier
  • Dropped the use of Quote() and now use escaped quotes
  • You can attach a sub-query when using "WHERE IN" by clicking on the icon to the right of the value field

UPDATE 4/22/2012

  • More Unsafe Names
  • UNION drop down menu and examples showing how to use it.
  • Documentation

Thanks for the feedback so far...


What's New in Version 1.2.3   See changelog

Released

No changelog available for this version.


1 person likes this