Subject | Re: [IBO] Token unknown - line 6, column 1 RETURNING error on TQuery.Edit |
---|---|
Author | mauriziodelmagno |
Post date | 2013-03-27T08:16:52Z |
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
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
>