I am currently using D5 and paradox7 tables
I need to do the query below (I know that this works on sql server) however when I use a query component in Delphi (to paradox tables)I receive an error (the when is the problem)
Any help or suggestions greatly appreciated
SELECT Name, Description, Risk,Ranking, Likelihood, Consequence
case when (likelihood<=10) and (consequence<=20) then 'very low risk - Acceptable'
when (likelihood>=20)and (likelihood<=40) and (consequence<=10) then 'low risk - Acceptable'
end as Prob
ORDER BY Prob