New IBProvider version has the option of cancelling commands execution and supports the new type of Firebird 2.5 queries containing SQL_NULL

Commands cancellation support in Firebird 2.5 and Interbase 6.5

CREATE OR ALTER PROCEDURE SP_EXEC_DUMMY_COUNTER (n integer)
 AS
 BEGIN
  WHILE(N>0)DO
   BEGIN
	N=N-1;
  END
 END

[Test(Description = "Sample - Command.Cancel")]
public void CancelCommand()
 {
     using (OleDbConnection con = ConnectionProvider.CreateConnection())
     {
        con.Open();
        OleDbTransaction trans = con.BeginTransaction();

        cmd.CommandText = "exec SP_EXEC_DUMMY_COUNTER(5000000)";
        
        // call cmd.ExecuteScalar using BackgroundWorker class
        BackgroundWorker bw = new BackgroundWorker();
        bw.DoWork += delegate(object sender, DoWorkEventArgs e)
        {
            OleDbCommand cmd1 = e.Argument as OleDbCommand;
            Console.WriteLine("begin call");
            cmd1.ExecuteScalar();
            Console.WriteLine("end call");                   
        };
            
        bw.RunWorkerAsync(cmd);

        //Cancel command after 500 miliseconds
        System.Threading.Thread.Sleep(500);
        cmd.Cancel(); 
        
        // waiting while cancel perform
        while (bw.IsBusy) { System.Threading.Thread.Sleep(500); }
        trans.Commit();
    }
}

Support of new data type SQL_NULL in Firebird 2.5

select count(*) from PROJECT where :par_null is NULL

dim cn, cmd, rs

set cn = wscript.createobject("adodb.connection")
call cn.open("Provider=LCPI.IBProvider.3;Password=masterkey;" & _
             "Persist Security Info=True;User ID=sysdba; " & _
             "Location=localhost:EMPLOYEE.FDB; dbclient_library=fbclient.dll")

cn.BeginTrans

WScript.Echo "IB Base=" & cn.Properties("IB Base").Value
WScript.Echo "IB Client Version=" & cn.Properties("IB Client Version").Value
WScript.Echo "Provider Version =" & cn.Properties("Provider Version").Value

set cmd = WScript.Createobject("adodb.command")
cmd.activeconnection = cn
cmd.CommandText = "select count(*) from PROJECT where :par_null is NULL"
cmd("par_null").Value = null

set rs=cmd.Execute

WScript.Echo cstr(rs(0))

cn.CommitTrans
cn.Close

[Test(Description = "Sample -  'is NULL' operator")]
public void ExecIsNullCommand()
{
  using (OleDbConnection con = ConnectionProvider.CreateConnection())
  {                
  con.Open();
  OleDbTransaction trans = con.BeginTransaction();

  OleDbCommand cmd = 
new OleDbCommand("select (*) from PROJECT where ? is NULL", con, trans);
  cmd.Parameters.AddWithValue("", null);

  // if cmd parameter is null then command will return count result                
  Assert.IsTrue((int)cmd.ExecuteScalar() > 0);
  trans.Commit();
  }
}

Access to BLOB fields from ADOExpress (dbGo) bug was fixed

New implementation of result sets cache

• Asynchronous writing (in a separate stream) into own swap file has been implemented.
• Writing into a temporary file has been optimized.

Finally