>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
A question mark prefix passes by value.