>Hi,
>I want to insert some records from VFP to SQL Server 2005,
>I run the SQLEXEC to insert the record,
>I don't want to hardcode the values, how can I change the values to variables ?
>
>

>
>SQLEXEC(m.lnConn, "INSERT INTO CUSMAS(client_no, client_name, client_addr)  VALUES ('C001','Client A','156 ABC Street, HK')")
>
>

>
>
>Please advise.
>
>Thanks.
>Derek

Use parameters:

lcClientNo   = 'C001'
lcClientName = 'Client A'
lcClientAddr = '156 ABC Street, HK'

SQLEXEC(m.lnConn, "INSERT INTO CUSMAS(client_no, client_name, client_addr)  VALUES (?m.lcClientNo,?m.lcClientName,?m.lcClientAddr)")

And ALWAYS check the result from SQL* functions and use AERROR() to see why some function didn't make it :-)