I wish to execute an SQL case statement against a Foxpro Database using VB6.0, using Visual Foxpro ODBC Driver
I use the following SQL command against a sybase DB an it works perfectly.
SELECT P_CRITICAL , (CASE WHEN P_CRITICAL = 'Quality' Then '+' Else '-' END) as P_CRITICAL FROM Sybase
How do I execute an SQL Case statement against a Foxpro Database.
I can use the select * from Foxprodatabase successfully, it's the Case statement (or something that would achieve the same results) is what I'm hoping for. I don't know what version of Foxpro the databses are.
Thanks in advance