At 02:24 PM 12-06-00 -0700, Kevin Stanton wrote:

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

Kevin, he is not using IB Objects, he is using InterBase Express
components. IBO does not have the problem described and does not use
UpdateSQL components to effect "live" updates on read-only datasets.

>What query component are you using: TIB_Query or TIBOQuery?
>
>I belive both support RequestLive.
>
>I have never used IBO's cached updates.

IBO has cached updates available for compatibility purposes only - it does
not need them. This question involves IB Express but I doubt this question
is about cached updates per se, it's about two things - transaction
concurrency and contention for identical keys.

At a guess, I would say that Paolo has made some wrong assumptions about
InterBase keys, based on his experiences with Paradox and contention
locks; and perhaps believing that InterBase supports autoincrementing type.

The issues appear to be
1) Migrating from a desktop database to a client/server one
2) Migrating the BDE components to IB Express
3) Understanding how to avoid key conflicts by using triggers to generate
unique keys
I recommend that Paolo
4) Understanding transaction-based processing

These do not get answered in one email that provides little or no
information about what is being done.

Migrating from BDE to IBX is a tricky step. Migrating from Paradox to
InterBase is also a tricky step. Also, remember that both InterBase 6 and
IBX are beta versions and have bugs of their own.

I'd recommend taking one bite of the cherry at a time. Seriously read the
InterBase documentation. Join the InterBase list at
http://www.mers.com Move the app to InterBase but keep the BDE initially
so that you can work out how IB is different to Paradox. Then think about
the BDE-free solution and evaluate whether IBX will be able to do what you
want.

This list is not intended for newbie support - here we try to deal with IB
6.0 installation issues. You'll get the best newbie support at the mers list.

Helen

> > -----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
> >
>
>
>------------------------------------------------------------------------
>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/_/960845062/
>------------------------------------------------------------------------
>
>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

http://www.interbase2000.org
___________________________________________________
"Ask not what your free, open-source database can do for you,
but what you can do for your free, open-source database."
(J.F.K.)