C#, dao, optional parameters and Seek method

[info]

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.Emp ty, 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.OpenRecordse t("A",DAO.Recor dsetTypeEnum.db OpenTable,0,
DAO.LockTypeEnu m.dbOptimistic) ;
A.Index="Primar yKey";

for (int i=1; i<100000;i++)
{
A.Seek ("=", i,
System.Guid.Emp ty,System.Guid. Empty,System.Gu id.Empty,System .Guid.Empty,Sys tem.Guid.Empty, System.Guid.Emp ty,System.Guid. Empty,System.Gu id.Empty,System .Guid.Empty,Sys tem.Guid.Empty, System.Guid.Emp ty,System.Guid. Empty);
//...
}

Thank you.
Antonin

[David Anton]

Use System.Type.Mis sing 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
"in**@pstruh.cz " 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.Emp ty, 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.OpenRecordse t("A",DAO.Recor dsetTypeEnum.db OpenTable,0,
DAO.LockTypeEnu m.dbOptimistic) ;
A.Index="Primar yKey";

for (int i=1; i<100000;i++)
{
A.Seek ("=", i,
System.Guid.Emp ty,System.Guid. Empty,System.Gu id.Empty,System .Guid.Empty,Sys tem.Guid.Empty, System.Guid.Emp ty,System.Guid. Empty,System.Gu id.Empty,System .Guid.Empty,Sys tem.Guid.Empty, System.Guid.Emp ty,System.Guid. Empty);
//...
}

Thank you.
Antonin