Hi all,

My first FoxPro job in 2.5+ years and my first ever involving SQL Server (MSDE at this point).

I have a single-table .DBC that I successfully used the Upsizing Wizard to create a MSDE database/table and 'load' data to it. I confirmed this with a simple SQLEXEC(nHandle,"Select * from Mapmerch"), browsing the result.

Now I have a program that is to add or update info in that MSDE database/table.

I get a connection handle just fine but any attempt to run SQLEXEC on that handle always fails.

The command is simply nResult=SQLEXEC(nHandle,cSQLIns1) and I have a rather lengthy SQL-Insert statement in cSQLIns1. But I have also tried with the following in cSQLIns1:
" cSQLIns1='INSERT INTO Mapmerch (MERCHANTNO, BUSNAME) VALUES ("9898989","NELSON TEST BY HAND")' " and
" cSQLIns1='INSERT Mapmerch (MERCHANTNO, BUSNAME) VALUES ("9898989","NELSON TEST BY HAND")' ".

My experience is sadly lacking and I'm sure that something more needs to be done, but I don't know what.

Your help will be appreciated.

Thanks