Thanks Hector (and Marty).

I will do that.

Cheers

>If this is your first SQL/MSDE project, try to get a copy of SQL Server Developers Edition (not sure about the name.) This "developers edition" includes all the GUI tools that SQL Server has and I believe you can use it during development with no licensing issues. It will make your development much easier.
>
>You cannot distribute you applicaion with it, though. You will need to distribute MSDE. That's ok since they both share the same binary code.
>
>
>>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