Multiple Primary Keys

From: jk (jk_at_discussions.microsoft.com)
Date: 03/22/05


Date: Mon, 21 Mar 2005 17:19:03 -0800

Hello all,
I successfully created table with multiple primary key with the help of
article posted here.
quoting procedure used there
-=============================
currentTable.Keys.Append("PrimaryKey", KeyTypeEnum.adKeyPrimary,
currentColumn.Name, "", "");

currentTable.Keys["PrimaryKey"].Columns.Append("other_column",other_column_type,other_column_size)
===============================
now when i try to execute select command for id (unique) on this table
i get oledbexception not a valid book mark .
can any body help me with this ??