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.
Code window opens at start up
Disabled field name check at start up.
No bug fixes ( please send bug reports in the support topic )
Added Settings page
Added Loading page
Fixed bug in code window
Misc bug fixes and UI tweaks
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
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
You can now group by a field without displaying it in the results
Added JOIN Example
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.
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.
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
Fixed bug in ORDER BY
Table Occurrences are now all that is needed to populate the field list.
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
More Unsafe Names
UNION drop down menu and examples showing how to use it.
Thanks for the feedback so far...
The animations introduced in FM13 are great, but they still don’t let us animate the transition from one layout to another. This is something we’re looking for as it’s often used in iOS apps to move from list to detail and back again.
However, using full-layout slide panels, we can animate layout transitions as long as we’re careful to get the timings right. Our unlocked example file demonstrates how to do this in your own solutions and introduces using OnTimer triggers to queue animations that might otherwise be invisible within a single script.
Details and a movie of this in action are one our blog.
FileMaker Templates, Calendars, & Cool Stuff
Concept uses a large text block for data entry, the script will parse for paragraph returns and then uses the Virtual List technique to print the multi page letter.
Also will allow for a scanned image of a signature to be appended and will slide up to the bottom of the body copy.
Also allows for manually inserting a page break by using <break> in body of text.