Board index » delphi » Primary Key Field Attribute

DM

Delphi Developer
Sun, 27 Feb 2005 23:07:04 GMT

Primary Key Field Attribute

In Delphi 6E ADO, how do I examine a field and know if it is a Primary Key
field ? Currently, I know the data type of each field but there is no method
within the FieldDef to specify if the field is a primary key.

TIA

DM

 
Mike Collie

Delphi Developer
Mon, 28 Feb 2005 03:14:38 GMT

Re:Primary Key Field Attribute


Quote
> In Delphi 6E ADO, how do I examine a field and know if it is a Primary Key
> field ?

You could check the field.properties collection after the recordset is
opened (assuming your oledb provider supports this property).

{From memory}
AdoDataset1.Recordset.Fields[x].Properties('keycolumn').value

You can view such properties in adoanywhere browser, I just checked and this
property works for Access using Jet. Trial From
http://www.adoanywhere.com/download/aaBrowser.zip

(You could also use connection objects openschema procedure to extract
database design information. There is a useful openschema gui built into the
same browser)

--
Mike Collier BSc (Hons)
www.adoanywhere.com
ADO Interactive Object Browser Tool
Trial From http://www.adoanywhere.com/download/aaBrowser.zip

Quote
"DM" <DataMana...@Yahoo.Com> wrote in message

news:3d7f5c12@newsgroups.borland.com...
Quote
> In Delphi 6E ADO, how do I examine a field and know if it is a Primary Key
> field ? Currently, I know the data type of each field but there is no
method
> within the FieldDef to specify if the field is a primary key.

> TIA

> DM

Brian Bushay Team

Delphi Developer
Mon, 28 Feb 2005 08:59:07 GMT

Re:Primary Key Field Attribute


Quote
>In Delphi 6E ADO, how do I examine a field and know if it is a Primary Key
>field ? Currently, I know the data type of each field but there is no method
>within the FieldDef to specify if the field is a primary key.

If your Oledb provider supports it you can use openSchema like this to get
keyfields

ADOConnection1.OpenSchema(siPrimaryKeys
,VarArrayOf([Null,Null,'TableNameYouAretryingTogetkeyof']),EmptyParam,ADODataSet1)

--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

DM

Delphi Developer
Mon, 28 Feb 2005 19:59:16 GMT

Re:Primary Key Field Attribute


Thanks Brian. The OpenSchema wporks very well.

DM

"Brian Bushay TeamB" <BBus...@Nmpls.com>

Quote
> ADOConnection1.OpenSchema(siPrimaryKeys

,VarArrayOf([Null,Null,'TableNameYouAretryingTogetkeyof']),EmptyParam,ADODat
aSet1)
Quote

Other Threads

1. Primary key or not primary key.........

2. Is there a problem using Autoincrement fields as a primary key

3. Sorting Paradox Tables With Indexed Primary Key Fields

4. Primary key fields of a Paradox Table

5. Determining Paradox Primary Index's Key Field(s)

6. Primary key and AutoInc field

7. how to get primary key field name use ADO

8. Returning primary key fields

9. Getting Primary Key fields of an ADO dataset...

10. About Primary Key Field...