Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data not being written to the table
Message
 
To
14/09/2006 13:54:53
Jeff Mckay
Utah Department of Health
Salt Lake City, Utah, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Novell 5.x
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01153779
Message ID:
01153780
Views:
15
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform