Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Use variable in Sqlexe function
Message
 
 
To
21/09/2010 04:38:07
Yim Ming Sun Derek
Spacious Design Consultant
Hong Kong, Hong Kong
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
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:
01482128
Views:
70
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform