BMarks - doesnt seem like theres an obvious solution in IB6. I needed to create a boolean column as part of the query and make it true if a select brings back 'x' data and false otherwise. I did this indirectly by using a union instead of an if statement. I.e. bring back all the true results...
Actually - that was a daft cut n' paste example from the web. The oracle query to be translated into IB6 is:
select c.carname, c.carid,
decode(
carid,
(select carid from customercar where carid = c.carid and custid = 1),
'Y',
'N'
) as preference
from car c
So -...
Thanks unclejimbob...but I was referring to an 'if then else' within a select statement - i.e. a case equivalent but using IB6. It has to be within a select statement, not a stored procedure. This is certainly embarassing stuff to be discussing publicly but the truth is...I can't find a way to...
Hi - stupid/spimple question but whats the equivalent of an oracle decode function in interbase? Is there a case statement? Or perhaps, if then else? I can find absolutely sod all resouces on interbase syntax on the net or the IB help. Can you also point me to any useful synatax links that I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.