I don't think the problem is w/ IB 6 but possibly Interbase Objects instead.

What query component are you using: TIB_Query or TIBOQuery?

I belive both support RequestLive.

I have never used IBO's cached updates.

For simple update forms that have a short life, I set the Autocommit to True
and the isolation to tiCommitted.

For posting routines, I take total control over the transaction.

HTH,
Kevin

> -----Original Message-----
> From: Paulo Albuquerque [mailto:paulo.albuquerque@...]
> Sent: Monday, June 12, 2000 1:59 PM
> To: IBDI@egroups.com
> Subject: [IBDI] I'm having problems with Interbase 6
>
>
> Can anyone help me ?
>
> I have moved recently to Interbase 6 (I used to use Paradox) and I
> don't know how I have to work on it for best performance and less
> problems.
> I'm using a IBDatabase (Dialect 3) and a IBTransaction with the
> following parameters:
> - read_committed
> - rec_version
> - nowait
> So I connected all my IBQuery to the IBDatabase. Then I noticed that
> this component does not support RequestLive. So I attached a
> IBUpdateSQL to each IBQuery. In that way the users change the data.
> Is it the best way to let the users update their data ?
>
> There is something wrong with that configuration because I get this
> error when more than two users try to access/update the same record...
>
> "lock conflict on no wait transaction attempt to store duplicate
> (visible to active transactions) in unique index "INDEX_NAME" "
>
> Is this error caused by IBTransaction configuration ? Which are the
> best parameters ? Do I have to use STARTTRANSACTION, ROLLBACK,
> COMMIT ? When ? Where ?
>
> Thank you very much in advance,
> Paulo Albuquerque
>
>
> ------------------------------------------------------------------------
> Take your development to new heights. Work with clients like Dell and
> pcOrder. Submit your resume to jobs@.... Visit us at
> http://click.egroups.com/1/4358/4/_/679568/_/960843565/
> ------------------------------------------------------------------------
>
> Community email addresses:
> Post message: IBDI@onelist.com
> Subscribe: IBDI-subscribe@onelist.com
> Unsubscribe: IBDI-unsubscribe@onelist.com
> List owner: IBDI-owner@onelist.com
>
> Shortcut URL to this page:
> http://www.onelist.com/community/IBDI
>