| Subject | Re: [IB-Conversions] A Question about how I can convert syntax Sybase to Interbase |
|---|---|
| Author | Helen Borrie |
| Post date | 2000-10-27T14:36:36Z |
At 10:51 AM 27-10-00 -0200, you wrote:
first Firebird release).
You can handle it in a stored procedure pretty easily. InterBase lets you
massage your data in a SP and then SELECT from the SP as if it were a table
(sort of like a "programmable view"). IMO, it's one of IB's greatest
assets for a programmer.
But - yes - everyone wants NULLIF and a CASE structure.
Cheers,
Helen
All for Open and Open for All
InterBase Developer Initiative ยท http://www.interbase2000.org
___________________________________________________
>Good Morning !InterBase doesn't support NULLIF yet (but it is early on the Agenda for the
>
>How I can convert a syntax Sybase to Interbase ?
>
>For ex: NULLIF(variable,0)
>
>This syntax verify if a variable is null, if true, then variable receive 0
>
>thanks,
>
>Marcos Fabiano Mendes de Siqueira
first Firebird release).
You can handle it in a stored procedure pretty easily. InterBase lets you
massage your data in a SP and then SELECT from the SP as if it were a table
(sort of like a "programmable view"). IMO, it's one of IB's greatest
assets for a programmer.
But - yes - everyone wants NULLIF and a CASE structure.
Cheers,
Helen
All for Open and Open for All
InterBase Developer Initiative ยท http://www.interbase2000.org
___________________________________________________