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