Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Variable doesnot work in query
Message
From
12/09/2001 15:41:35
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Variable doesnot work in query
Miscellaneous
Thread ID:
00555669
Message ID:
00555669
Views:
45
This command works fine and return 8 records

SELECT Request.iid, Request.dtoday, Request.dtois, Request.creqfrom,;
Request.creqdeptt, Request.creqdesc, Request.dneeded, Request.csubmtedby,;
Request.ccomplby, Request.dcompltd, Request.cstatus;
FROM isapp!request;
where Request.cstatus IN ('Testing', 'UnAssigned', 'In Progress')


where as this should return the same value but returns blank recordset

vp_cStatusField = "' Testing ', "+" ' UnAssigned ', "+" ' In Progress '"
?vp_cStatusField


SELECT Request.iid, Request.dtoday, Request.dtois, Request.creqfrom,;
Request.creqdeptt, Request.creqdesc, Request.dneeded, Request.csubmtedby,;
Request.ccomplby, Request.dcompltd, Request.cstatus;
FROM isapp!request;
where Request.cstatus IN (?vp_cStatusField)




Thanks
Bharat
Next
Reply
Map
View

Click here to load this message in the networking platform