Hello!

What´s a syntax for stored procedure ?

Because I am use the syntax below and the Interbase show me one error "Token
unknown - END"

CREATE PROCEDURE showuser AS
BEGIN
select * from user
END

thanks

----- Original Message -----
From: Helen Borrie <helebor@...>
To: <IB-Conversions@egroups.com>
Sent: Sexta-feira, 27 de Outubro de 2000 12:36
Subject: Re: [IB-Conversions] A Question about how I can convert syntax
Sybase to Interbase


At 10:51 AM 27-10-00 -0200, you wrote:
>Good Morning !
>
>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

InterBase doesn't support NULLIF yet (but it is early on the Agenda for the
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
___________________________________________________



To unsubscribe from this group, send an email to:
IB-Conversions-unsubscribe@egroups.com