Hi!
SQLPrepare/SQLEXEC pair is good rto query data. To update data this approach have no bemefits over the single call of SQLExec. I guess preparing is the main reason why it fails. Try to do nto use SQLPrepare.
Also, put a command 'SET STEP ON' temporarily before that SQLEXEC command. Run program and when it stops at that point, see what is a value of the AgLoc variable. Maybe it is really empty.
Finally, do you have any triggers in the database? Maybe possible cause is that trigger overrides that value some way?
>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
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.