Yes, that is an excellent work around.
No rush as I believe I have already fixed the problem.
If you prefer, you can just get the next sub-release and test it first.
I should be getting that out this week.

Jason
www.ibobjects.com


-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of mauriziodelmagno
Sent: Wednesday, March 27, 2013 2:17 AM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] Token unknown - line 6, column 1 RETURNING error on
TQuery.Edit

Hi Jason, thanks for your reply.
I have setted the LockSQL property manually and the problem is solved for
me.
In the TIBOQuery I have not found the property UseReturningClause.
For the sample code I will try to prepare as soon as possible, but they are
at a particularly messed up so it will take me a few days, is that a
problem?
Regards.

Maurizio

--- In IBObjects@yahoogroups.com, "IBO Support List" <supportlist@...>
wrote:

>
> 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
>

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

___________________________________________________________________________
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