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

_________________________

Gerard J.M. Houtenbos
DoubleWood Software