How to get Primary Key from Recordset in VB 2005 Express

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi,

I am trying to fetch Primary keys for different tables in Oracle and
Sybase. After doing some search, I found the following code, but I am
not sure how to get the primary key from recSet

recSet = objConn.OpenSchema(adSchemaPrimaryKeys,
Array("database","schema","tablename"))

recSet!COLUMN_NAME does not work in 2005 Express edition and
recSet.Fields has all the columns in the table. Not sure how to
identify primary for the same.

Please advise.

Thanks

Shiv

.

Relevant Pages

  • How to get Primary Key from Recordset in VB 2005 Express
    ... I am trying to fetch Primary keys for different tables in Oracle and ... Sybase. ... not sure how to get the primary key from recSet ...
    (microsoft.public.vb.database.ado)
  • Re: Primary Key and Indexes, are they necessary?
    ... However there is no primary keys on any tables. ... While adding primary keys can enhance performance in Oracle DB, ... And regarding your problems with reports. ... individually and watch out again for common problems. ...
    (comp.databases.oracle.misc)
  • Re: MSSQL - Invalid attribute/option identifier
    ... database import and some how it did created all the table and placed the ... data but all my primary keys, unique indexes, foregin keys, and relation ... problem while I am just trying to test if my code works with MSSQL. ... sProj is an Recordset created by MFC object (Originally from ORACLE ...
    (microsoft.public.vc.mfc)
  • odbc joint primary keys - allowing duplicate data?
    ... oracle won't let me add a duplicate record...as I would expect. ... The design view in Access shows 2 primary keys. ... Is this an ODBC issue and Access? ... can't have duplicate records being accepted.... ...
    (microsoft.public.data.odbc)
  • Indexing an Oracle Table
    ... I have an Oracle table that I am trying to query off of, ... There are no indexes or primary keys in this table, ... retrieve the information faster, meaning, how do I have the Oracle ...
    (microsoft.public.access.queries)