SQLexplorer

Version History

SQLexplorer.VersionHistory History

Show minor edits - Show changes to output

January 14, 2015, at 09:37 PM by 142.4.217.187 -
Changed lines 9-10 from:
*'''Configure jQGrid'''
*'''Test Query'''
to:
->'''Configure jQGrid'''
->'''Test Query'''
January 14, 2015, at 09:36 PM by 142.4.217.187 -
Changed lines 9-11 from:
'''Configure jQGrid'''

'''Test Query'''
to:
*'''Configure jQGrid'''
*'''Test Query'''
January 14, 2015, at 09:35 PM by 142.4.217.187 -
Added line 10:
January 14, 2015, at 09:35 PM by 142.4.217.187 -
Changed lines 9-10 from:
->'''Configure jQGrid'''
->'''Test Query'''
to:
'''Configure jQGrid'''
'''Test Query'''
January 14, 2015, at 09:32 PM by 142.4.217.187 -
Changed lines 7-8 from:
To update an '''1.3''' to '''1.32''' simply download the new version of SQLexplorer [here|http://www.seedcode.com/filemaker-sql-explorer/] and copy the contents of these scripts into your build (providing you haven't previously modified them in your build)
to:
To update an '''1.3''' to '''1.32''' simply download the new version of SQLexplorer [[http://www.seedcode.com/filemaker-sql-explorer/|here]] and copy the contents of these scripts into your build (providing you haven't previously modified them in your build)
Changed line 14 from:
For more details on these changes please see our blog post [here|http://www.seedcode.com/blog/]
to:
For more details on these changes please see our blog post [[http://www.seedcode.com/blog/|here]]
January 14, 2015, at 09:30 PM by 142.4.217.187 -
Changed line 7 from:
To update an '''Build 1.3''' to '''1.32''' simply download the new version of SQLexplorer [here|http://www.seedcode.com/filemaker-sql-explorer/] and copy the contents of these scripts into your build (providing you haven't previously modified them in your build)
to:
To update an '''1.3''' to '''1.32''' simply download the new version of SQLexplorer [here|http://www.seedcode.com/filemaker-sql-explorer/] and copy the contents of these scripts into your build (providing you haven't previously modified them in your build)
January 14, 2015, at 09:30 PM by 142.4.217.187 -
Changed lines 5-16 from:
'''Latest Build''' The latest build is '''1.3''' (December 3, 2013)  Small fixes to the way we hide objects so they are compatible with FileMaker 12 and '''13'''.  We also changed the way we handle the CSS objects in the web viewer.  They are now exported directly to the Temp Directory rather than attempting to create an images/ folder and exporting them there.  The images now properly display in '''FileMaker Go''' and in '''Mavericks'''.  The fields in the Queries table have not changed, so importing your queries from '''1.29''' into '''1.3''' will be the easiest way to upgrade.  However, upgrading to '''1.3''' for '''FileMaker 13''' is not required, but you may see some oddities related to Hidden Objects in '''1.29''' as referenced %newwin% [[http://www.seedcode.com/filemaker-13-hiding-objects/ | here]].  The only script that has been updated is '''Export CSS and Images (Boolean)''', so you can %newwin% [[http://www.seedcode.com/?wpdmdl=9 | download]]. '''1.3''' and copy the script contents and paste them into the script in '''1.29'''.  This is only needed if the small CSS images aren't showing in the Web Viewer Portal.
to:
'''Latest Build''' The latest build is '''1.32''' (January 14,2015)  We added some example code for firing a FileMaker script from the "JavaScript" portal and passing a column value as a parameter.  Also added a routine which will hide the first column of the query so you can include a value like your primary key to use as a script parameter, but not have the value display in your "portal."

To update an '''Build 1.3''' to '''1.32''' simply download the new version of SQLexplorer [here|http://www.seedcode.com/filemaker-sql-explorer/] and copy the contents of these scripts into your build (providing you haven't previously modified them in your build)

->'''Configure jQGrid'''
->'''Test Query'''

That's it!

For more details on these changes please see our blog post [here|http://www.seedcode.com/blog/]

'''Build
1.3''' (December 3, 2013)  Small fixes to the way we hide objects so they are compatible with FileMaker 12 and '''13'''.  We also changed the way we handle the CSS objects in the web viewer.  They are now exported directly to the Temp Directory rather than attempting to create an images/ folder and exporting them there.  The images now properly display in '''FileMaker Go''' and in '''Mavericks'''.  The fields in the Queries table have not changed, so importing your queries from '''1.29''' into '''1.3''' will be the easiest way to upgrade.  However, upgrading to '''1.3''' for '''FileMaker 13''' is not required, but you may see some oddities related to Hidden Objects in '''1.29''' as referenced %newwin% [[http://www.seedcode.com/filemaker-13-hiding-objects/ | here]].  The only script that has been updated is '''Export CSS and Images (Boolean)''', so you can %newwin% [[http://www.seedcode.com/?wpdmdl=9 | download]]. '''1.3''' and copy the script contents and paste them into the script in '''1.29'''.  This is only needed if the small CSS images aren't showing in the Web Viewer Portal.
Changed line 5 from:
'''Latest Build''' The latest build is '''1.3''' (December 3, 2013)  Small fixes to the way we hide objects so they are compatible with FileMaker 12 and '''13'''.  We also changed the way we handle the CSS objects in the web viewer.  They are now exported directly to the Temp Directory rather than attempting to create an images/ folder and exporting them there.  The images now properly display in '''FileMaker Go''' and in '''Mavericks'''.  The fields in the Queries table have not changed, so importing your queries from '''1.29''' into '''1.3''' will be the easiest way to upgrade.  However, upgrading to '''1.3''' for '''FileMaker 13''' is not required, but you may see some oddities related to Hidden Objects in '''1.29''' as referenced %newwin% [[http://www.seedcode.com/filemaker-13-hiding-objects/ | here]].  The only script that has been updated is "'Export CSS and Images (Boolean)'", so you can %newwin% [[http://www.seedcode.com/?wpdmdl=9 | download]]. '''1.3''' and copy the script contents and paste them into the script in '''1.29'''.  This is only needed if the small CSS images aren't showing in the Web Viewer Portal.
to:
'''Latest Build''' The latest build is '''1.3''' (December 3, 2013)  Small fixes to the way we hide objects so they are compatible with FileMaker 12 and '''13'''.  We also changed the way we handle the CSS objects in the web viewer.  They are now exported directly to the Temp Directory rather than attempting to create an images/ folder and exporting them there.  The images now properly display in '''FileMaker Go''' and in '''Mavericks'''.  The fields in the Queries table have not changed, so importing your queries from '''1.29''' into '''1.3''' will be the easiest way to upgrade.  However, upgrading to '''1.3''' for '''FileMaker 13''' is not required, but you may see some oddities related to Hidden Objects in '''1.29''' as referenced %newwin% [[http://www.seedcode.com/filemaker-13-hiding-objects/ | here]].  The only script that has been updated is '''Export CSS and Images (Boolean)''', so you can %newwin% [[http://www.seedcode.com/?wpdmdl=9 | download]]. '''1.3''' and copy the script contents and paste them into the script in '''1.29'''.  This is only needed if the small CSS images aren't showing in the Web Viewer Portal.
Changed lines 5-6 from:
'''Latest Build''' The latest build is '''1.29''' (July 19, 2013). First public build with the Web Viewer Portal as previewed %newwin% [[http://www.youtube.com/watch?v=cXwDvhonG5c | here]].  Fixed some bugs with field filtering on the Criteria Tab.  Improved CSV exports on Windows.  Columns using the AS statement to create aliases will have those aliases used as headers in the exports and can also be accessed in the copied query calculations.  Added support for FileMaker "Schema" tables: FileMaker_Tables and FileMaker_Fields.  Please download a new version of the explorer %newwin% [[http://www.seedcode.com/downloads | here]].
to:
'''Latest Build''' The latest build is '''1.3''' (December 3, 2013)  Small fixes to the way we hide objects so they are compatible with FileMaker 12 and '''13'''.  We also changed the way we handle the CSS objects in the web viewer.  They are now exported directly to the Temp Directory rather than attempting to create an images/ folder and exporting them there.  The images now properly display in '''FileMaker Go''' and in '''Mavericks'''.  The fields in the Queries table have not changed, so importing your queries from '''1.29''' into '''1.3''' will be the easiest way to upgrade.  However, upgrading to '''1.3''' for '''FileMaker 13''' is not required, but you may see some oddities related to Hidden Objects in '''1.29''' as referenced %newwin% [[http://www.seedcode.com/filemaker-13-hiding-objects/ | here]].  The only script that has been updated is "'Export CSS and Images (Boolean)'", so you can %newwin% [[http://www.seedcode.com/?wpdmdl=9 | download]]. '''1.3''' and copy the script contents and paste them into the script in '''1.29'''.  This is only needed if the small CSS images aren't showing in the Web Viewer Portal.

''' Build 1.29''' (July 19, 2013). First public build with the Web Viewer Portal as previewed %newwin% [[http://www.youtube.com/watch?v=cXwDvhonG5c | here]].  Fixed some bugs with field filtering on the Criteria Tab.  Improved CSV exports on Windows.  Columns using the AS statement to create aliases will have those aliases used as headers in the exports and can also be accessed in the copied query calculations.  Added support for FileMaker "Schema" tables: FileMaker_Tables and FileMaker_Fields.  Please download a new version of the explorer %newwin% [[http://www.seedcode.com/downloads | here]].
July 20, 2013, at 12:00 AM by 75.71.120.47 -
Changed line 5 from:
'''Latest Build''' The latest build is '''1.29''' (July 19, 2013). First public build with the Web Viewer Portal as previewed [[http://www.youtube.com/watch?v=cXwDvhonG5c | here]].  Fixed some bugs with field filtering on the Criteria Tab.  Improved CSV exports on Windows.  Columns using the AS statement to create aliases will have those aliases used as headers in the exports and can also be accessed in the copied query calculations.  Added support for FileMaker "Schema" tables: FileMaker_Tables and FileMaker_Fields.  Please download a new version of the explorer %newwin% [[http://www.seedcode.com/downloads | here]].
to:
'''Latest Build''' The latest build is '''1.29''' (July 19, 2013). First public build with the Web Viewer Portal as previewed %newwin% [[http://www.youtube.com/watch?v=cXwDvhonG5c | here]].  Fixed some bugs with field filtering on the Criteria Tab.  Improved CSV exports on Windows.  Columns using the AS statement to create aliases will have those aliases used as headers in the exports and can also be accessed in the copied query calculations.  Added support for FileMaker "Schema" tables: FileMaker_Tables and FileMaker_Fields.  Please download a new version of the explorer %newwin% [[http://www.seedcode.com/downloads | here]].
July 19, 2013, at 03:59 PM by 75.71.120.47 -
Changed line 12 from:
'''Build 1.02''' (August 12, 2012). Corrected a bug where we weren't respecting two predicates in the JOINs. Download a new version of the explorer %newwin% [[http://www.seedcode.com/downloads | here]].
to:
'''Build 1.02''' (August 12, 2012). Corrected a bug where we weren't respecting two predicates in the JOINs.
July 18, 2013, at 07:13 PM by 75.71.120.47 -
Changed lines 5-8 from:
'''Latest Build''' The latest build is '''1.07''' (March 7, 2013). We fixed a stay field on the Joins tab and repaired a bug where your query operator would disappear if you edited the query by hand. Please download a new version of the explorer %newwin% [[http://www.seedcode.com/downloads | here]].
to:
'''Latest Build''' The latest build is '''1.29''' (July 19, 2013). First public build with the Web Viewer Portal as previewed [[http://www.youtube.com/watch?v=cXwDvhonG5c | here]].  Fixed some bugs with field filtering on the Criteria Tab.  Improved CSV exports on Windows.  Columns using the AS statement to create aliases will have those aliases used as headers in the exports and can also be accessed in the copied query calculations.  Added support for FileMaker "Schema" tables: FileMaker_Tables and FileMaker_Fields.  Please download a new version of the explorer %newwin% [[http://www.seedcode.com/downloads | here]].


'''Build 1.07''' (March 7, 2013). We fixed a stay field on the Joins tab and repaired a bug where your query operator would disappear if you edited the query by hand.
July 01, 2013, at 02:31 PM by 67.190.87.90 -
Changed lines 5-6 from:
'''Latest Build''' The latest build is '''1.07''' (March 7, 2012). We fixed a stay field on the Joins tab and repaired a bug where your query operator would disappear if you edited the query by hand. Please download a new version of the explorer %newwin% [[http://www.seedcode.com/downloads | here]].
to:
'''Latest Build''' The latest build is '''1.07''' (March 7, 2013). We fixed a stay field on the Joins tab and repaired a bug where your query operator would disappear if you edited the query by hand. Please download a new version of the explorer %newwin% [[http://www.seedcode.com/downloads | here]].
March 07, 2013, at 10:00 PM by 50.132.84.245 -
Changed lines 5-6 from:
'''Latest Build''' The latest build is '''1.06''' (March 1, 2013). This build introduces filtering of fields when selecting them for queries, sorts, or find criteria, and lets you copy an *abstracted* version of your query into your file. These abstracted versions are less verbose that in previous explorers and survive field renaming: they're what we use in all our custom work. Version 1.06 also abstracts queries you just type into the explorer, so even if you can write SQL queries quickly, the explorer saves you the trouble of quoting and abstracting all your field and table names. =)
to:
'''Latest Build''' The latest build is '''1.07''' (March 7, 2012). We fixed a stay field on the Joins tab and repaired a bug where your query operator would disappear if you edited the query by hand. Please download a new version of the explorer %newwin% [[http://www.seedcode.com/downloads | here]].

'''Build
1.06''' (March 1, 2013). This build introduces filtering of fields when selecting them for queries, sorts, or find criteria, and lets you copy an *abstracted* version of your query into your file. These abstracted versions are less verbose that in previous explorers and survive field renaming: they're what we use in all our custom work. Version 1.06 also abstracts queries you just type into the explorer, so even if you can write SQL queries quickly, the explorer saves you the trouble of quoting and abstracting all your field and table names. =)
March 02, 2013, at 12:09 AM by 50.132.84.245 -
Changed lines 5-6 from:
'''Latest Build''' The latest build is '''1.02''' (August 12, 2012). Corrected a bug where we weren't respecting two predicates in the JOINs. Download a new version of the explorer %newwin% [[http://www.seedcode.com/downloads | here]].
to:
'''Latest Build''' The latest build is '''1.06''' (March 1, 2013). This build introduces filtering of fields when selecting them for queries, sorts, or find criteria, and lets you copy an *abstracted* version of your query into your file. These abstracted versions are less verbose that in previous explorers and survive field renaming: they're what we use in all our custom work. Version 1.06 also abstracts queries you just type into the explorer, so even if you can write SQL queries quickly, the explorer saves you the trouble of quoting and abstracting all your field and table names. =)

'''Build
1.02''' (August 12, 2012). Corrected a bug where we weren't respecting two predicates in the JOINs. Download a new version of the explorer %newwin% [[http://www.seedcode.com/downloads | here]].
August 14, 2012, at 03:15 AM by 50.132.84.245 -
Changed lines 5-8 from:
'''Latest Build''' The latest build is '''1.02''' (August 12, 2012). Corrected a bug where we weren't respecting two predicates in the JOINs.

'''Build 1.01''' (May 7, 2012) where we've now quoted table names as well as field names in the query. Download a new version of the explorer [[http://www.seedcode.com/downloads | here]]
.
to:
'''Latest Build''' The latest build is '''1.02''' (August 12, 2012). Corrected a bug where we weren't respecting two predicates in the JOINs. Download a new version of the explorer %newwin% [[http://www.seedcode.com/downloads | here]].

'''Build 1.01''' (May 7, 2012) where we've now quoted table names as well as field names in the query
. 
August 14, 2012, at 03:15 AM by 50.132.84.245 -
Changed lines 5-6 from:
'''Latest Build''' The latest build is '''1.01'' (May 7, 2012) where we've now quoted table names as well as field names in the query. Download a new version of the explorer [[http://www.seedcode.com/downloads | here]].
to:
'''Latest Build''' The latest build is '''1.02''' (August 12, 2012). Corrected a bug where we weren't respecting two predicates in the JOINs.

'''Build 1.01'
'' (May 7, 2012) where we've now quoted table names as well as field names in the query. Download a new version of the explorer [[http://www.seedcode.com/downloads | here]].
May 08, 2012, at 01:04 PM by 50.132.84.245 -
Changed lines 5-7 from:
'''Latest Build''' The latest build is '''1.0''' (May 2, 2012) Our first public release.
to:
'''Latest Build''' The latest build is '''1.01'' (May 7, 2012) where we've now quoted table names as well as field names in the query. Download a new version of the explorer [[http://www.seedcode.com/downloads | here]].

'''Build
1.0''' (May 2, 2012) Our first public release.
May 03, 2012, at 04:30 AM by 50.132.84.245 -
Changed line 5 from:
'''Latest Build''' The latest build is '''1.0'' (May 2, 2012) Our first public release.
to:
'''Latest Build''' The latest build is '''1.0''' (May 2, 2012) Our first public release.
May 03, 2012, at 04:30 AM by 50.132.84.245 -
Added lines 1-5:
!! What is the latest build of SQLexplorer?

''The version number for your copy of the explorer can be found in the lower left of the Queries layout on the 'Introduction' tab.''

'''Latest Build''' The latest build is '''1.0'' (May 2, 2012) Our first public release.
(855) SEEDCODE
[email protected]
Follow us: