Hello: > example script: > **************************** > delete from invoice where recid=1; > delete from invdetails where invrecid=1; > execute procedure sp_resetrecid; > insert into invoice (recid, invoice) values (1, '1001'); > insert into invdetails (invrecid, somefield) values (1, > 'stuff'); > > **************************** > > when passing this script, an exception will be generated > when the script completes the "execute procedure > sp_resetrecid;" statement. > > this script will run correctly from isql.exe, so i know it's > a valid script. > > i've gotten it to work by changing the execute method of > fbbatchexecution.cs. i moved the statement: > > case SqlStatementType.ExecuteProcedure: > > to line number 289 and remarked out the original case statement. > > case SqlStatementType.ExecuteProcedure: > > // raise the event > > this.OnCommandExecuting(this.sqlCommand); > rowsAffected = this.ExecuteCommand(this.sqlCommand, autoCommit); > > this.requiresNewConnection = false; > // raise the event > this.OnCommandExecuted(sqlStatement, null, rowsAffected); > break; > > the script works like isql now. is there a reason why this > statement should not be changed using the method i've outlined? > Not than i'm aware of ... i will try to do the commit in CVS as soon as possible, in both 1.7 and 2.0 sources.
------------------------------------------------------------------------- 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 [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
