Login
Templates, Tools and Utilities
for Clarion Developers
Templates, Tools and Utilities
|
||
|
|
|
Add a comment to an Icetips ArticlePlease add your comments to this article.
Please note that you must provide both a name and a valid email address in order
for us to publish your comment. Comments are moderated and are not visible until they have been approved. Spam is never approved!
Back to article list Search Articles Add Comment Printer friendly Direct link Par2: SQL alternative to CHOOSE 2007-12-09 -- Jim Gambon > I know that I can use Choose to return different fields from a TPS file on a
> condition.
>
> Is there a similar functionality that will work inside a Prop:SQL(Select ...
> operation?
Check out the use of "CASE" in a Select statement. It usually works something
like this (I may not have the syntax exactly correct):
SELECT
CASE "fieldToTest"
WHEN 'A' THEN 'Blah'
WHEN 'B' THEN 'BlahBlah'
WHEN 'C' THEN 'WhoZits'
ELSE 'Nada'
END AS "ColName"
FROM "tablename"
Today is November 21, 2024, 6:55 am This article has been viewed 35222 times.
|
|