At 09:47 PM 23/02/2007, Paul Hope wrote:

>Jason,
>
>I cant seem to produce a sample - this is very strange.
>
>If I go to my app form, place a new TIB_Query on it, connect it to the main
>IB_Connection, paste in the SQL and click prepare I get the access
>violation.
>
>If I create a new app with new IB_Connection, default transaction and query,
>connect to the same database, paste in the SQL click prepare - its OK !
>
>On closer examination of the IB_connections the existing one has SQLDialect
>3 (the databases are Dialect 1). The test app has SQLDialect 1, if I
>change it to 3 it changes back to 1 when I connect or prepare the query.
>
>Having changed the dialect in the main app to 1 it all works fine.
>
>The remaining mystery is how the main app managed to remain on SQLDialect 3.
>
>In terms of the original question of improving the returned error message
>for bad syntax it looks like this is a bad example!

http://www.ibobjects.com/docs/IBO_47_Migration.pdf

Helen