i found the solution , i remove the suspend and the output parameter into my
procedure and after that all is commited.
""le roy arnaud"" <[EMAIL PROTECTED]> a écrit dans le message de news:
[EMAIL PROTECTED]
> 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
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
-------------------------------------------------------------------------
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
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
