Information générale
Titre:
SQL Batch Update Problems and TableUpdate
Hello everyone, we are currently having trouble with a batch update using Visual Foxpro 5.0 and SQL 6.5.
We are basically doing the following:
=cursorsetprop("buffering",5,"customer)
--- add a lot of records to the view / using a loop
=tableupdate(2,.t.,"customer",cerrarray)
This will add all of the changes to the view to the sql database utilizing the connection information associated with the view.
Unfortunately the table update is returning FALSE, and the cerrarray is not returning any information on the error, IE: why it failed.
ANY HELP with this would be greatly appreciated, if you need more information please holler.
PS: the following method does work
=cursorsetprop("buffering",2,"customer")
--add a single record in the loop
=tableupdate()
--continue adding more records, updating rows as we go!
THANKS - KEITH
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