Re: Strange PB !?

Hi,

> ------------------------------------------------------------------------
>
> When myTable is empty this algorithm never works, when attemping to
> print value to 'last_key_code' in such situation (myTable is empty)
> nothing is printed, and 'insert into' procedure return error !!! i add
> an 'if' statment to make it work but doesn't solve the pb :
>
> ----
> if last_key_code=null then last_key_code:=0; end if
> ----
>

You can't compare Null values with something. Instead of try this

if last_key_code IS null then ...
end if;

Erika

> I think that we can automate such operations by creating a 'sequence' ?
> how ?
>
> Anyone can help please?
> Thanks.
>
> Wassim,
> e-mail: net2000_at_francemel.com
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Tue Jun 22 1999 - 04:11:42 CDT