In some cases it is possible to perform updates to a query like this. Using
the FOR UPDATE clause in the SQL instructs the server to keep the cursor on
the current record sent to the client and thereby handle an UPDATE TABLE ...
WHERE CURRENT OF <cursor name>.

That is an older version of IBO so I don't recall off the top of my head
exactly what the status of things were for that version. It should work
fine. However, you are not giving us any indication of what the problem is.
Was there an error message or what?

Jason Wharton

> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On
> Behalf Of Helen Borrie
> Sent: Thursday, May 25, 2006 9:28 AM
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] ib_query dataset error
>
>
> At 12:20 AM 26/05/2006, you wrote:
> >Hello
> >
> >I use Ibo 3.6x with Firebird 1.5
> >
> >There is a problem using ib_query component. Data is fetched from two
> >tables and updation is done in one table (FOR UPDATE )
> >
> >The query is as follows
> >
> >SELECT I.* FROM ITEMMASTER I , GROUPMASTER G
> >WHERE I.GROUPCODE=G.GROUPCODE AND G.OUTLETCODE=?OUTLET FOR UPDATE
> >
> >Any assistance would be much appreciated
>
> FOR UPDATE doesn't make a joined set updatable. Take that out.
>
> What's the problem you have?
> How have you set up the keylinks and the update?
>
> Helen
>
> >Thanks
> >Subhi Edappathodi