General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>I changed the syntax so I am not using m.agloc. Rather I am using magloc. It still fails. The sqlprepare() statement returns the value of 1, so it is fine. but the Sqlexec() statement returns -1. I can not figure out why. I checked to be sure and magloc is not blank or null. It has a value.
>
>So, if anyone has any suggestions as to how I can add these VFP records to an existing SQL Server table , PLEASE suggest.
>
>Marie
You can use aerror() after the sqlexec return -1, then look at the seconed element of the array and you will know why it failed.
Also, if this is a one time thing, to move your data you can use DTS.
Another thing you can do is create a view of the SQL table, then open the view, append the records to the view, tableudate(1) the view.
BOb
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