Thanks!
I was not doing that. However I am doing it now and the problem stills the
same :(
if this the correct way to free the command? Thanks again Jiri.
-Evandro
public int ExecuteNonQuery(string sql)
{
FbCommand cmd = null;
int rowsAffected = -1;
cmd = new FbCommand(sql, Con);
try
{
rowsAffected = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
if (ex.Message == "Error reading data from the connection.")
{
System.Diagnostics.Process proc = new
System.Diagnostics.Process();
proc.StartInfo.WorkingDirectory = D.AplicacaoDiretorio;
proc.StartInfo.FileName = D.ApplicationName;
proc.StartInfo.Arguments = "";
proc.StartInfo.UseShellExecute = false;
proc.StartInfo.RedirectStandardOutput = false;
proc.StartInfo.RedirectStandardError = false;
proc.Start();
//proc.WaitForExit();
//proc.Close();
Environment.FailFast(ex.Message);
}
}
finally
{
cmd.Dispose();
cmd = null;
}
return rowsAffected;
}
and for the one with transaction support:
public int ExecuteNonQuery(string sql, FbTransaction bdTrans)
{
FbCommand cmd = null;
int rowsAffected = -1;
cmd = new FbCommand(sql, Con, bdTrans);
rowsAffected = cmd.ExecuteNonQuery();
cmd.Dispose();
cmd = null;
return rowsAffected;
}
On Tue, Apr 27, 2010 at 12:54 AM, Jiri Cincura <[email protected]> wrote:
> On Mon, Apr 26, 2010 at 23:28, Evandro's mailing lists (Please, don't
> send personal messages to this address) <[email protected]> wrote:
> > D.Bd.ExecuteNonQuery("
>
> Will these rows internally free the command?
>
> --
> Jiri {x2} Cincura (CTO x2develop.com)
> http://blog.cincura.net/ | http://www.ID3renamer.com
>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Firebird-net-provider mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
------------------------------------------------------------------------------
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
