Paradox - Retrieving Fields That Make Up Index? 2

[Robertio]

Any suggestions on how to retrieve a list of the fields that make up the primary index on a paradox table?

All I need is the field names, but can't think of any way to do this.


Don't you just hate maintaining old systems, the subsequent version is in Oracle which makes life a whole lot easier.

Any ideas greatfully appreciated.

Cheers
Robertio
Alias: Robbie Calder
Software Developer
urc@walkermartyn.co.uk

 

[footpad]

Roberto,

Table1.IndexDefs[ 0 ].Fields

gives you a semi-colon separated list of fields in a Paradox table's primary key.

Hope this helps...

-- Lance

 

[Robertio]

Thanks Lance, just what I was after Robertio
Alias: Robbie Calder
Software Developer
urc@walkermartyn.co.uk