I need to use DAO in one of my applications. It was too hard to pass
through by optional parameters for several methods, but now I'm totally
lost at DAO seek method (the main method for key s).
The method has a next declaration:

Sub Seek(Comparison As String, Key1, [Key2], [Key3], [Key4], [Key5],
[Key6], [Key7], [Key8], [Key9], [Key10], [Key11], [Key12], [Key13])
Member of DAO.Recordset

12 optional parameters. I tried anything for the Key2-Key13, without
success - Null, System.Guid.Empty, System.TypeCode.DBNull, ... But
without success. The Seek method always returns:

"Additional information: Could not build key."

What can I do with the method?

My code looks like:

DAO.Database db = CreateDatabase("test.mdb");

DAO.Recordset A =
db.OpenRecordset("A",DAO.RecordsetTypeEnum.dbOpenTable,0,
DAO.LockTypeEnum.dbOptimistic);
A.Index="PrimaryKey";

for (int i=1; i<100000;i++)
{
A.Seek ("=", i,
System.Guid.Empty,System.Guid.Empty,System.Guid.Empty,System.Guid.Empty,System.Guid.Empty,System.Guid.Empty,System.Guid.Empty,System.Guid.Empty,System.Guid.Empty,System.Guid.Empty,System.Guid.Empty,System.Guid.Empty);
//...
}

Thank you.
Antonin

Use System.Type.Missing for the arguments you want to skip.
--
David Anton
www.tangiblesoftwaresolutions.com
Instant C#: VB to C# converter
Instant VB: C# to VB converter
Instant C++: C# to C++ converter
Instant C++: VB to C++ converter


"(E-Mail Removed)" wrote:

> I need to use DAO in one of my applications. It was too hard to pass
> through by optional parameters for several methods, but now I'm totally
> lost at DAO seek method (the main method for key s).
> The method has a next declaration:
>
> Sub Seek(Comparison As String, Key1, [Key2], [Key3], [Key4], [Key5],
> [Key6], [Key7], [Key8], [Key9], [Key10], [Key11], [Key12], [Key13])
> Member of DAO.Recordset
>
> 12 optional parameters. I tried anything for the Key2-Key13, without
> success - Null, System.Guid.Empty, System.TypeCode.DBNull, ... But
> without success. The Seek method always returns:
>
> "Additional information: Could not build key."
>
> What can I do with the method?
>
> My code looks like:
>
> DAO.Database db = CreateDatabase("test.mdb");
>
> DAO.Recordset A =
> db.OpenRecordset("A",DAO.RecordsetTypeEnum.dbOpenTable,0,
> DAO.LockTypeEnum.dbOptimistic);
> A.Index="PrimaryKey";
>
> for (int i=1; i<100000;i++)
> {
> A.Seek ("=", i,
> System.Guid.Empty,System.Guid.Empty,System.Guid.Empty,System.Guid.Empty,System.Guid.Empty,System.Guid.Empty,System.Guid.Empty,System.Guid.Empty,System.Guid.Empty,System.Guid.Empty,System.Guid.Empty,System.Guid.Empty);
> //...
> }
>
> Thank you.
> Antonin
>
>