Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server problem
Message
 
To
09/02/2007 13:49:01
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01194131
Message ID:
01194250
Views:
8
To be fully in agreement with SQL SErver sybtax I would cahnge your code as below (added siungle quotes around the string literal):
lcSQL = "select * " + ;
	"from TRPSurvey" + "..exported " + ;
	"where ltrim(rtrim(PermID)) = '" + lcPermID + "'"

IF sqlexec(m.lnHandle,lcSQL,"crsImport") < 0
   AERROR(laError)
   MessageBox(laError[1,2])
ENDIF
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform