Board index » delphi » Updating same sets of databases

Updating same sets of databases

I have build an applications where the following data is stored in
(simplified).
ORDER
ordernumber (autoincrement)
ARTICLES OF ORDER
ordernumber (short)
articlenumber (short)
ARTICLES
articlenumber (autoincrement)

This works great, but....
I'm looking for a reliable solutions for the following:
The application has to work on two computers (desktop and portable) with the
same databases. And has to be updated every week/day to have the same data
in de two sets of databases.
If orders or articles are added in only one of the sets there's no problem
but it must be possible to add records on the two computers, in all the
databases, and records with a link. The problem is that there will be
different articles with the same articlenumber.
Is there a solutions tot this problem.
-------------------------------------------------------------------
A.L. van Tilburg
   Lavengang 8
   5131 GE  ALPHEN (N.B.)
   The Netherlands
   Tel.: (31) 013-5082540
   E-mail: pays...@worldonline.nl
-------------------------------------------------------------------

 

Re:Updating same sets of databases


Quote
Paysage wrote in message <65gjsc$...@forums.borland.com>...
>If orders or articles are added in only one of the sets there's no problem
>but it must be possible to add records on the two computers, in all the
>databases, and records with a link. The problem is that there will be
>different articles with the same articlenumber.
>Is there a solutions tot this problem.

Assign a unique number to each computer, and then modify your tables so that
the key consists of two fields: old key + computerID

Other Threads