Tomáš Kurek
unread,May 16, 2024, 8:40:52 AMMay 16Sign in to reply to author
Sign in to forward
You do not have permission to delete messages in this group
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to fireb...@googlegroups.com
Ahoj
Zkouším tento kousek kódu a vím jak zprovoznit na firebirdu 2.5 až 4.0 .
execute block
as
begin
if (exists (SELECT id_prp FROM table1 WHERE v3 = 147 and v4 =
2024)) then
UPDATE table1 SET v1 = 4 , v2 = 1 WHERE v3 = 147 and v4 = 2024 ;
else
INSERT INTO table1 (v1,v2,v3,v4) VALUES (147,2024,4,1) ;
end;
Engine Code : 335544569
Engine Message :
Dynamic SQL Error
SQL error code = -104
Unexpected end of command - line 5, column 95
Zkoušel jsem dát pryč středníky na konci řádku a pak zahlásí správně :
Engine Code : 335544569
Engine Message :
Dynamic SQL Error
SQL error code = -104
Token unknown - line 6, column 5
else
Už jsem obalil do begin , end a pořád se nechytá. Dává chybu :
execute block
as
begin
if (exists (SELECT id_prp FROM table1 WHERE v3 = 147 and v4 =
2024)) then
begin
UPDATE table1 SET v1 = 4 , v2 = 1 WHERE v3 = 147 and v4 = 2024 ;
end
else
begin
INSERT INTO table1 (v1,v2,v3,v4) VALUES (147,2024,4,1) ;
end
end;
Engine Code : 335544569
Engine Message :
Dynamic SQL Error
SQL error code = -104
Unexpected end of command - line 6, column 96
Nevíte prosím někdo jak napsat aby fungovalo ? U FireBird mám vždycky
středníky metodu pokus omyl ale tady už fakt nevím.
Díky
--
Tomáš Kurek