G
Gina
Hi.
I wrote a programm for a garage to collect customer, car and work
information.
Now data needs to be exchanged between standalone pc's at different
locations.
For ease of use for the customer I decided to use text files for the data
exchange.
So I have written export code that writes data to text files (one text file
per table) and the import code adds a new record when the key values are not
found and edits it otherwise.
all works well ....
apart from when a record on pc 1 has been deleted.
so far there is no code at the import to handle this ....
question:
how could I receive the information from a non-existing record in a text
file (which gets imported) that the existing record on pc2 should be deleted
?
is there another way than creating temp tables and then compare the existing
and the temp table ?
Is there a way to still use my text based data ? - I feel lost here !
Thanks in advance for your ideas and help
Gina
I wrote a programm for a garage to collect customer, car and work
information.
Now data needs to be exchanged between standalone pc's at different
locations.
For ease of use for the customer I decided to use text files for the data
exchange.
So I have written export code that writes data to text files (one text file
per table) and the import code adds a new record when the key values are not
found and edits it otherwise.
all works well ....
apart from when a record on pc 1 has been deleted.
so far there is no code at the import to handle this ....
question:
how could I receive the information from a non-existing record in a text
file (which gets imported) that the existing record on pc2 should be deleted
?
is there another way than creating temp tables and then compare the existing
and the temp table ?
Is there a way to still use my text based data ? - I feel lost here !
Thanks in advance for your ideas and help
Gina