Hi Gerard,

Gerard J.M.Houtenbos wrote:

> The following message appears everytime I try to insert a record
> using a TIBOquery with a live resultset.
> The system generates the UpdateSQL text and that is causing the
> error.
>
> ISC ERROR CODE:335544569
>
> ISC ERROR MESSAGE:
> Dynamic SQL Error
> SQL error code = -104
>
> Token unknown - line 2, char 11
> The token is an apostrophe: '
>
> The TIBStatement it generates is:
>
> 'INSERT INTO MALO_AFD'#$D#$A'( MALO_AFD.AFD'#$D#$A',
> MALO_AFD.P_KEY)'#$D#$A'VALUES '#$D#$A'( :MALO_AFD.AFD'#$D#$A',
> :MALO_AFD.P_KEY)'#$D#$A
>
> Any idea?
>
> tia

are you perhaps using an older IBO version (<4.2Gb) against a Firebird 1.0
(build 796) server?? it seems so...

- read http://www.fingerbird.de/build821.htm to understand what's wrong
- either use Firebird 1.0 build 821 instead of 796 (downloads above)
- or use a newer IBO version (>4.2Gb)
- or, in case you have the IBO sources, change the routine that puts together
the INSERT statement (Jason posted a fix here some time ago, you should find it
in the archives)

regards & hth,
fingerman

--
-------------------------------------------------------------------------
when parsers parse, and compilers compile, then why don't objects object?

fingerbirdy - fingerman's door to Firebird
http://www.fingerbird.de