By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,396 Members | 1,422 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,396 IT Pros & Developers. It's quick & easy.

FoxPro Programmer - CASE conversion

P: n/a
Is there any way to create a query similar to the old CASE statement in
FoxPro?
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"M S Baker" <ms**@nbank.net> wrote in message
news:ll*****************@petpeeve.ziplink.net...
Is there any way to create a query similar to the old CASE statement in
FoxPro?


Alternatives in Access/Jet queries. Check Help file for...

Choose()
IIf()
Switch()

Or write a User-Defined function. The VBA code in that function can
utilize If-Then or Select-Case statements.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 12 '05 #2

P: n/a
I'm not familiar with FoxPro, but I'm assuming that CASE in FoxPro is
similar to CASE in T-SQL? If so, I'm afraid the nearest equivalent in JET
SQL is a series of nested IIF() functions.

--
Brendan Reynolds
"M S Baker" <ms**@nbank.net> wrote in message
news:ll*****************@petpeeve.ziplink.net...
Is there any way to create a query similar to the old CASE statement in
FoxPro?

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.