General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Vladimir,
Thanks, I'll try that.
Jerry
>>I have a VFP web app that allows our customers to place items into a shopping cart and then place and finalize their order.
>>
>>The shopping cart data is kept in a VFP .dbf. But when the user finalizes their order, I write their order from the VFP table into a SQL Server table.
>>
>>We receive several hundered orders a day using this method. However, lately we have had a problem where an order was finalized and written to SQL Server successfully, but a few detail lines were dupped in the SQL Server table. Basically, the order in the DBF was 100 lines, but when the order was written to SQL Server, about 10 lines near the bottom of the dataset were dupped making the detail line count 110.
>>
>>This only happened to us twice out of several thousand orders, and I cannot reproduce this. But what sort of error checking can I perform while writting to SQL Server to trap for this problem?
>>
>>Thanks,
>>
>>Jerry
>
>Jerry,
>The SQLEXEC() function has new 4th parameter aCountInfo specificly to get back the # of affected records.
>
>Check the records in VFP .dbf and aCountInfo.
>HTH
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only