Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
I am ashamed to ask: Variables
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
I am ashamed to ask: Variables
Miscellaneous
Thread ID:
00393489
Message ID:
00393489
Views:
52
I have a variable "cBank"

I do this to assign things in a case statement

cbank = "3850" and so on...

I wanta case where the varibale can be either of the things i assign. i.e. - cBank = "0036" or cBank ="3855" or cBank ="3951" or cBank = "3850" or ;
cBank = "3950" or cBank = "4369" or cBank = "1778"


The variable is on a query as:
SET DEFAULT TO (gc_datapath)
SELECT nsf.* ;
FROM nsf ;
WHERE BETWEEN(nsf.settdate, m.dStartDate, m.dEndDate) ;
and nsf.portfolio = alltrim(cBank) ;
ORDER BY bankname, mid ;
INTO table nsf_return_items.DBF


I get an Invlid count etc. error. when Ido this. How would I assign this variable in this case?

Thanks in advance for your help.

Randall
Thanks in advance for your help! :-)
Randall L. Johnson
Next
Reply
Map
View

Click here to load this message in the networking platform