Re: [Firebird-net-provider] Problem with FbScript and execute procedure

2007-08-23 Thread le roy arnaud
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 : > > CREAT

[Firebird-net-provider] Problem with FbScript and execute procedure

2007-08-23 Thread le roy arnaud
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 s