Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server problem
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01194131
Message ID:
01194201
Views:
8
If lcPermID is a VFP variable. You can do it 2 ways:

Option 1:
lcSQL = "select * " + ;
	"from TRPSurvey" + "..exported " + ;
	"where cPermID = '" + alltrim(lcPermID) + "'"
Option 2:
lcSQL = "select * " + ;
	"from TRPSurvey" + "..exported " + ;
	"where cPermID = ?lcPermID"
Provided that lcPermID is already trimmed with spaces.
Previous
Reply
Map
View

Click here to load this message in the networking platform