Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jonshandle

    "if then else" in Interbase

    Unclejimjob - thanks very much but I've sorted it using the solution in the older thread.....
  2. jonshandle

    "if then else" in Interbase

    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...
  3. jonshandle

    "if then else" in Interbase

    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 -...
  4. jonshandle

    "if then else" in Interbase

    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...
  5. jonshandle

    "if then else" in Interbase

    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...

Part and Inventory Search

Back
Top