Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Use variable in Sqlexe function
Message
From
21/09/2010 04:38:07
Yim Ming Sun Derek
Spacious Design Consultant
Hong Kong, Hong Kong
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Use variable in Sqlexe function
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01482112
Message ID:
01482112
Views:
126
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
Next
Reply
Map
View

Click here to load this message in the networking platform