On 29 Apr 2002 at 6:41, csswa wrote:

> Do the comparisons make sense when considering that declared
> variables are NULL by default and therefore cannot be used in
> comparisons until they receive a value? e.g. something compared to
> NULL is always NULL; something added to NULL is always NULL; etc.

If I have a proc like this

create procedure procA
as
declare variable a integer;
begin
stm1
.
.
.
stm100

if (a > 5)
then exit;

suspend;
end

In this case one could forget to initialize variable 'a' (atleast I could), and it would take a
long time to find the source of error.

Regards

Sandeep

Software Developer
CFL
sandeep@...
http://www.cfl.co.nz