Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
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
Précédent
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