Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Passing variable to Local View
Hi,
I have a local view with syntax,
SELECT Suspense.policyno, Suspense.claim, Suspense.drftamt,;
Suspense.dduedate, Suspense.claimname, Suspense.dol, Suspense.ssn,;
Suspense.adjustor, Suspense.clmoffice, Suspense.ntlogin,;
Suspense.controlnum, Suspense.susp_code, Suspense.den_code,;
Suspense.accepted, Suspense.denied;
FROM suspense;
WHERE Suspense.clmoffice IN (?clmlist)
where clmlist is variable.
It seems that when I pass "001","007","008" as the clmlist variable, the local view only returns records that have clmoffice="001" (or whatever I pass in before the first comma).
I also tried creating the view dynamically at run-time, but can't get the local view to refresh the data in a grid.
Would be VERY GRATEFUL for any tips...
THANKS!
Suzi Taylor
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement