The SQL monitor may reveal some helpful hints.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: <rsaeger.edv@...>
To: <IBObjects@yahoogroups.com>
Sent: Friday, June 22, 2001 7:02 AM
Subject: [IBO] E_Record_Not_Located_For_Update error


> Hi,
>
> I have to edit a singleton table (a table with always 1 row only).
> This table has no primary key, the KeyLinks property of the TIB_Query
> is table.RDB$DB_KEY.
>
> And I want to be sure, that only one WS can change the table.
>
> So I use a transaction with isolation level tiConcurrency,
> I catch the deadlock in the OnError event of the query, tell the user
> "sorry, somebody changed the table" and than I want to show the new
> values with TIB_query.Refresh.
>
> But I always get the E_Record_Not_Located_For_Update error. I've tried
> it with primary key (for one row table!), with TIB_Query.Close/Open,
> with TIB_Transaction.Refresh(False), but no succes.
>
> What am I doing wrong? (IBO 3.6 Dg)
>
> Thanks
> Richard
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>