Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Records inserted into the table completely lost
Hi!
I am faced with a frustrating and hard to figure out problem...
Here's the problem...
Some clients use two program which access
the same DBF file called PDMLOG.DBF
One client program inserts records into the PDMLOG
and then the server application reads it and transfers it to AS400 if necessarry.
Most of the time it works but sometimes when the records
get inserted into the table in the client program
the server program can't see these new records.
I opened up the table in foxpro and noticed the
following.
In the application there are 50050 records with some data I put in to test...
I do a tableupdate(.t.)
But in foxpro there is only 50000 records.
When I close the program the data is lost.
When I come back in only 50000 records remain.
So I drop the CDX file and reindex it.
It works for a while and then the problem happens again.
Any ideas???
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement