Archive for February, 2009

New DoSQL 1.2 allows for more universal SQL calculations

Thursday, February 5th, 2009

We just released version 1.2 of our DoSQL plug-in.

This new version provides a new function:

mFMb_DoSQL_QuoteField( fieldname )

The function converts "FileMaker-style" syntax like my Table::my Field to SQL syntax like "my Table.my Field" (with quotes). The nice thing about this is that it allows you to double-click a field to insert it in a calculation.

DoSQLCalc.png

Combined with FileMaker Pro 10’s new ‘GetFieldname’ function, this allows you to make the SQL statements much more universal.

Download this example for more details on how this can be used (make sure you have version 1.2 of the DoSQL plug-in installed)

Although the use of spaces in field names is not recommended, this solution will continue to function properly if you do use spaces.

Download DoSQL 1.2