problem with user defined functions with select into statements
From: Caroline Keay <c.keay_at_cranfield.ac.uk>
Date: 1996/05/02
Message-ID: <4m9ti3$hol_at_yama.mcc.ac.uk>#1/1
Date: 1996/05/02
Message-ID: <4m9ti3$hol_at_yama.mcc.ac.uk>#1/1
create function tablelookup(var1 char ,var2 char)
return char is
select field3 into var3 from atable where field1 = var1 and
field2 = var2;
var3 char,
begin
return (var3);
end;
I then use this function in an SQL select statement (or a browser define column)
select field1, field2, tablelookup(field1,field2) from anothertable;
Caroline Received on Thu May 02 1996 - 00:00:00 CEST