Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Variable doesnot work in query
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Variable doesnot work in query
Divers
Thread ID:
00555669
Message ID:
00555669
Vues:
44
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform