Getting started with Ultimate SQL and Firebird SQL

I’m looking to get started using Ultimate SQL and Firebird together… I’m not having any luck yet – I recorded a small video showing my (lack of) progress.

Let me know your thoughts.

Thank you,
Chris Buechler

Don’t know anything about Ultimate SQL templates, but you appear to be using the ‘Dummy File’ technique to retrieve results of an SQL statement - but you’re missing the TURBOSQL=TRUE file option in the dummy file declaration ie you have

FILE,DRIVER(‘ODBC’),OWNER(…

whereas you should have something like…

FILE,DRIVER(‘ODBC’,’/ TURBOSQL =TRUE’),OWNER(…

Look up TURBOSQL in the Help

1 Like

Thank you Graham – I didn’t know about that cool trick. That is 90% of what I’m trying to achieve with UltimateSQL.

-Chris