I always use generators and triggers, of course.
But, here is better example. Test enviroment includes Firebird server and
some PocketPC. Application running on PocketPC allows me to connect to
server (let us suppose that!) in the morning. Using Fill I get all required
data on my PocketPC and I close the connection to database. With my PocketPC
I am working whole day somewhere in the woods, collecting new data about
something. I put these new data into localy stored tables and I want to
Update it using DataAdapter back to server in the evening.
Let's say there are two tables - first has an unique identifier and second
uses these ID as foreign key. All data are entered without connection to
server on field, and data should be updated to server in the evening (there
is no way to be connected to server during day).
Does DataAdapter localy make unique identifiers (on server defined with
triggers/generators)? If not, how can I make relation between two tables
described previously? It is important that when posting data to server all
these values are recalculated and changed using cascade updates..
Let us suppose, there are few users using their PocketPCs on the same way.
All of them make local copies of some tables in the morning, then they make
some field work collecting data, and finally they want to update data and
post it to server in the evening. In that case, all of them could have same
localy defined unique identifiers, and these should be changed when updating
data to server.
Is that possible using Firebird .NET provider? I am asking it because that's
one of examples I heard on Microsoft ADO.NET training session. That is a
kind of usage of their disconnected database access mode.So I was wondering
if it works like that with Firebird.
|
