[ 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? |