Unidac: Record not found or changed by another user...

Joao Cadilhe · Post by **Joao Cadilhe** » Tue 22 Apr 2008 22:17

I'm testing Unidac against Firebird in a multitier application:
Unidac + datasetprovider (application server) + ClientDataset (client Application) .

With all tables i'm receiving in clientdataset (OnReconcileError event):
"Record not found or changer by another user" when i try to insert or update record.

Provider flags are correct and i'm using DatasetProvider.UpdateMode = upWhereKeyOnly .

I have no problems with AdoQuery (dbGo) or FibPlus in same tests.

Do you have any idea?

thanks in advance.

Joao Cadilhe.

Joao Cadilhe · Post by **Joao Cadilhe** » Wed 23 Apr 2008 15:25

It's working only with DataseProvider.ResolveToDataset = True and using separated (dedicated) Transaction and UpdateTransaction in Uniquery.

If i try to use common Transaction and UpdateTransaction with all Uniquery components in Datamodule i see server active transactions number increasing after any update, insert or delete operation (it's bad for firebird).

I think you have some issues with IProvider support in UniDac. I want to order Unidac but Iprovider working ok is very important to me.

Can you help me?

Joao Cadilhe.

Challenger · Post by **Challenger** » Thu 24 Apr 2008 11:34

We have fixed this bug. This fix will be included in the next build of UniDAC.

Joao Cadilhe · Post by **Joao Cadilhe** » Thu 24 Apr 2008 18:01

Do you have a date for this release?

Challenger · Post by **Challenger** » Fri 25 Apr 2008 13:30

In about tree weeks. If this doesn't suit you, please contact us by e-mail.