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