hi,
i have a probleme with a script that execute a procedure like this :
CREATE PROCEDURE BO_DEL_TABLE
RETURNS (
IDSUP INTEGER
)
AS
BEGIN
FOR SELECT IDMYTABLE FROM MYTABLE INTO :IDSUP
DO
BEGIN
DELETE FROM MYTABLE WHERE MYTABLE = :IDSUP;
suspend;
END
END
this is my script :
EXECUTE PROCEDURE BO_DEL_TABLE();
when i use this script with fbscript and fbbatchexecution the work is not
commited (the mytable's line are not deleted).
if i execute this script with ibexpert all works fine (but i add at the end
of script COMMIT WORK;)
have you an idea ?
thanks in advance.
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
