General information
Title:
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
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