> I think autoincrement fields and your propusal are fine for local, single
> user databases, like a firebird embedded database.
I'm currently using that one, I should have wrote it to make it clear.
> In a multi user envirement, two users can insert the same key in the data
> set in the memory.
This I don't understand. If you create a record in the memory, it
won't run the insert command itself. So you won't get any uniqueid.
When you update the database itself, then the provider takes every
single record from the inserted rows collection and call the insert
command record-by-record, so you will get the uniqueid at that
particular moment. In this case you can't get any duplicates and
errors.
I've just switched to Firebird, so have a lot to learn, for example I
have to have a look on Firebird about atomic operations, and multiuser
environment, but the .net adapter should work like I wrote above.
Am I wrong?
Imre
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
