Hi.

I have a problem with procedure. Execute of this produce no effect

ET TERM ^ ;

CREATE PROCEDURE CLEAR_TEMP_DATA 
as
begin
  DELETE FROM connected_players;
  DELETE FROM sel_nositeli;
  DELETE FROM sel_nositeli2;
  DELETE FROM sel_vvt;
  DELETE FROM sel_vvt2;
end^

SET TERM ; ^

GRANT SELECT,DELETE ON CONNECTED_PLAYERS TO PROCEDURE CLEAR_TEMP_DATA;

GRANT SELECT,DELETE ON SEL_NOSITELI TO PROCEDURE CLEAR_TEMP_DATA;

...and no errors.


-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Reply via email to