Board index » delphi » Determining Paradox Primary Index's Key Field(s)

Steve Wash

Delphi Developer
Sat, 08 May 1999 03:00:00 GMT

Determining Paradox Primary Index's Key Field(s)

How do you determine a Paradox table's primary index's key field(s) at
runtime? Fields[0] can't be trusted, because users reorder that array if
they reorder fields in a grid.

Thanks,

Steve Wash
Zane & Associates. Inc

 
Paul Motye

Delphi Developer
Sun, 09 May 1999 03:00:00 GMT

Re:Determining Paradox Primary Index's Key Field(s)


look at TIndexDefs and search for an index with an IndexOption of
[ixPrimary]

HTH,

--
Paul Motyer
pa...@linuxserver.pccity.com.au
SoftStuff, Croydon, Vic,  Australia, 3136.

Steve Wash <sw...@{*word*104}enet.net> wrote in article
<32919B14.1...@{*word*104}enet.net>...

Quote
> How do you determine a Paradox table's primary index's key field(s) at
> runtime? Fields[0] can't be trusted, because users reorder that array if
> they reorder fields in a grid.

> Thanks,

> Steve Wash
> Zane & Associates. Inc

Other Threads

1. Sorting Paradox Tables With Indexed Primary Key Fields

2. Primary key fields of a Paradox Table

3. Primary indexed Auto-increment fields in Paradox ?

4. Primary key or not primary key.........

5. Determining the Primary Key

6. Howto determine if a field is a key Field

7. Determining Primary fields in a Dataset

8. Getting the primary key index name.

9. Primary Key, Unique Index and Grid component

10. Primary Key Indexes on SQL Anywhere?