Navigacija
Lista poslednjih: 16, 32, 64, 128 poruka.

Interbase- Parsing Error

[es] :: Firebird/Interbase :: Interbase- Parsing Error

[ Pregleda: 2446 | Odgovora: 3 ] > FB > Twit

Postavi temu Odgovori

Autor

Pretraga teme: Traži
Markiranje Štampanje RSS

trunka
novi sad

Član broj: 73096
Poruke: 20
*.intens.co.yu.



Profil

icon Interbase- Parsing Error09.08.2007. u 10:37 - pre 202 meseci
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?
 
Odgovor na temu

Fedya
Fedor Hajdu
Solution Architect
Emaratech
Dubai, UAE

Član broj: 28246
Poruke: 790
*.intens.co.yu.

Jabber: fedya@elitesecurity.org
Sajt: devtechgroup.com


+34 Profil

icon Re: Interbase- Parsing Error09.08.2007. u 10:46 - pre 202 meseci
To MS-SQL?
Every hamster has his day.
 
Odgovor na temu

trunka
novi sad

Član broj: 73096
Poruke: 20
*.intens.co.yu.



Profil

icon Re: Interbase- Parsing Error09.08.2007. u 10:53 - pre 202 meseci
InterBase je u pitanju
 
Odgovor na temu

Teks

Član broj: 153636
Poruke: 31
91.150.124.*



Profil

icon Re: Interbase- Parsing Error09.08.2007. u 20:36 - pre 202 meseci
Da je u pitanju T-SQL trebalo bi da bude

Select rFactBasicW = um$um_Conv_Basic

ili

Set rFactBasicW = um$um_Conv_Basic

 
Odgovor na temu

[es] :: Firebird/Interbase :: Interbase- Parsing Error

[ Pregleda: 2446 | Odgovora: 3 ] > FB > Twit

Postavi temu Odgovori

Navigacija
Lista poslednjih: 16, 32, 64, 128 poruka.