On 16.02.2013 14:41, Joost van der Sluis wrote:
In our WinCE client for our application we use it for a miniature
version of our database. As the client does not need all tables and only
a specific subset of the data we generate a database on the host
computer and download that to the device. When the user is done the
database is copied back and the created data is integrated with the
normal database (which is either a Oracle, MSSQL or DB2 one).
What you could do is: use TSQLQuery to perform a query on Oracle or MSSQL. Then
store the dataset to file. Then copy this file to your WinCE client. Then you
can work with it on your client, but don't use ApplyUpdates but do save your
dataset to disk. When you're done, copy the dataset to another computer. Open
the dataset into an TSQLQuery and run ApplyUpdates...
We are using not only one table, but multiple ones with references in
between them. Also not every data needs to be loaded each time and the
exported amount of data can get huge depending on the customers existing
database. Also we don't directly write the created/modified data back
into the main database, but go through a special "import interface"
that's designed for input from mobile devices and our web frontend
(because depending on the type of created/modified data specific other
actions need to be triggered which would not be possible if simply doing
a ApplyUpdates as tables are touched that are not downloaded to the
mobile client).
But this only works if you do not use SQL on your WinCE client. But maybe this
can be solved since ZMSQL adds that functionality to TBufDataset? (I only read
the wiki-article, never actually looked at it)
As I wrote: ZMSQL sounds interesting. But up until now I've also only
read the wiki article.
Regards,
Sven
--
_______________________________________________
Lazarus mailing list
[email protected]
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
