Subject RE: [IBO] Token unknown - line 6, column 1 RETURNING error on TQuery.Edit
Author IBO Support List
I just noticed I gave the ability to manually turn this off.
Do you see a UseReturningClause property? If so, and it is true, set it to
false and see if that resolves your issue.

Jason

-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of IBO Support List
Sent: Tuesday, March 26, 2013 3:04 PM
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] Token unknown - line 6, column 1 RETURNING error on
TQuery.Edit

Ah, thanks for the clue. For some reason the automatic statement generated
to produce the record lock is including the RETURNING clause with it. This
is a bug because it is supposed to detect whether or not that clause is
supported and only use it when it is. I am surprised my regression testing
app didn't catch it. This tells me that there is some special combination of
properties you are using that I may not be able to guess on my own.

Would you please provide a sample app for me and I'll get this fixed ASAP?

Thanks,
Jason
www.ibobjects.com

-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of mauriziodelmagno
Sent: Tuesday, March 26, 2013 12:00 PM
To: IBObjects@yahoogroups.com
Subject: [IBO] Token unknown - line 6, column 1 RETURNING error on
TQuery.Edit

Hi, I get this error when I call Edit on a TQuery:

>ISC ERROR CODE:335544569
>
>ISC ERROR MESSAGE:
>Dynamic SQL Error
>SQL error code = -104
>Token unknown - line 6, column 1
>RETURNING

In my EditSQL code RETURNING word is not present.
Pessimistic locking is True (if false there are no problems).
I can not understand what could be the problem.
Does anyone know how I can fix this?
Many thanks and sorry for my bad english.
Best regards.

Maurizio



------------------------------------

___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
Yahoo! Groups Links





------------------------------------

___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
Yahoo! Groups Links