how to find indexes for a dbf

[lwfg]

How do you find all the index orders (in a cdx file) for a dbf?

 

[Mike Lewis]

Use the ATAGINFO() function.

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro tips, advice, training, consultancy
Custom software for your business

 

[lwfg]

Tried ?ataginfo() and got error message "Program ataginfo.prg does not exist."

Using VFP 6.

 

[r0gerc]

Have you tried KEY() or SYS(14) ?

 

[Olaf Doschke]

vfp6 should have Key(), also Tagcount() and Tag().

use table
For lnCount = 1 to tagcount()
  ? Tag(lnCount)
  ? Key(lnCount)
Endfor

Bye, Olaf

 

[Mike Lewis]

Lwfg,

TAGINFO() won't work with 6.0. It was introduced in VFP 7.0.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro tips, advice, training, consultancy
Custom software for your business