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 <disk...@cincura.net> wrote:

> On Mon, Apr 26, 2010 at 23:28, Evandro's mailing lists (Please, don't
> send personal messages to this address) <lista...@gmail.com> 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
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
------------------------------------------------------------------------------
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
  • ... Evandro's mailing lists (Please, don't send personal messages to this address)
    • ... Jiri Cincura
      • ... Evandro's mailing lists (Please, don't send personal messages to this address)
        • ... Jiri Cincura

Reply via email to