When I don't assign any value to a variable, the default value for
integer are null ? and for varchar? where can I see the default value
for the types?

--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> wrote:

> Hi,
>
> > Hi, I have this select in my stored procedure
> >
> > select ID_CURSO, ID_PARCEIRO from MATRICULA
> > where ID_CONTRATO = :ID_CONTRATO
> > into :CURSO_ANTERIOR, :ID_PARCEIRO
> >
> > How can I check if the select has been returned a value?
> >
> > the variables CURSO_ANTERIOR and ID_PARCEIRO are integers and

doesn't

> > have any assignment of values before this select.
> >
> > If my select doesn't return any value, what will be assigned to

my

> > variables?
>
> The previously assigned value.
>
> It if was NULL, it stays NULL. If it was X, it stays X.
>
> With regards,
>
> Martijn Tonies
> Database Workbench - the developer tool for InterBase & Firebird
> Upscene Productions
> http://www.upscene.com