Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Data not being written to the table
Message
 
À
14/09/2006 13:54:53
Jeff Mckay
Utah Department of Health
Salt Lake City, Utah, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Novell 5.x
Database:
Visual FoxPro
Divers
Thread ID:
01153779
Message ID:
01153780
Vues:
17
>Hi I have an interesting problem that was only reproduced after a lot of testing.
>
>I have a program that prints ourt client checks to a dot matrix printer, then writes the data to a table. This table is not buffered (although other tables are). Normally the function works correctly, it prints the checks and writes the data to the table.
>
>But if several users (in testing atleast 3 users replicated the issue) are all printing checks at the same time, and all printing many check (which does happen in the client setting) occasionally one or two checks will simply disappear from the table. they are not (or appear not to have been writen) to the table. There is the possibility that the record is being over written, as I have added code that double checks for the check right after the printing is done, I have yet to recieve an error that a check was not in the table.
>
>Does anyone have an idea for what I can look for?
>
>as for the code that writes to the table, it is a simple APPEND BLANK command and then a REPLACE xxx WITH xxx COMMAND.
>
>Any help would be appreciated
>
>Database is located on a novel file server running netware 5 and all users write to this one database and one table

Can you post the code where you write to the table?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform