[ trunka @ 09.08.2007. 10:37 ] @
Imam sp koja pocinje ovako:

create procedure ConvertToKG
(
"rWEIGHT" numeric(18,2),
" cWUM" VARCHAR(20) CHARACTER SET ISO8859_1
)
returns
( "results" boolean)
as

declare variable um$um_Basic numeric(18,2);
declare variable um$um_Conv_Basic numeric(18,2);
declare variable um$um_Conv_Other numeric(18,2);
declare variable um$basic_Um_Id varchar(3);
declare variable um$other_Um_Id varchar(3);
declare variable um$um_System numeric(1,0);

declare variable rFactBasicW numeric(18,2);
declare variable iSystemW integer;

begin

select UM_BASIC, UM_CONV_BASIC, UM_CONV_OTHER, BASIC_UM_ID, OTHER_UM_ID, UM_SYSTEM
from UM where UM_ID = :cWUM
into :um$um_Basic, :um$um_Conv_Basic, :um$um_Conv_Other, :um$basic_Um_Id, :um$other_Um_Id, :um$um_System ;

if ( (um$um_Basic is null) and (um$um_Conv_Basic is null) and (um$um_Conv_Other is null) and (um$basic_Um_Id is null)
and (um$other_Um_Id is null) and (um$um_System is null) ) then
begin
results = false;
exit;
end;

rFactBasicW = um$um_Conv_Basic;

....itd..

i kada je pokrenem dobijem poruku :"Parsing Error invalid statement on line 0: rFactBasicW = um$um_Conv_Basic; "

U cemu je greska?
[ Fedya @ 09.08.2007. 10:46 ] @
To MS-SQL?
[ trunka @ 09.08.2007. 10:53 ] @
InterBase je u pitanju
[ Teks @ 09.08.2007. 20:36 ] @
Da je u pitanju T-SQL trebalo bi da bude

Select rFactBasicW = um$um_Conv_Basic

ili

Set rFactBasicW = um$um_Conv_Basic