changing an index

[manpaul]

I have an index that is in a cdx, first I would like to check the index expression then if the expression is wrong change with the program

 

[rgbean]

You might want to check out the program with

http://support.microsoft.com/default.aspx?scid=kb;en-us;202520

- "FILE: Use CDX(),TAG(), and SYS(14) Function to Create an Index Utility".

Note: Deprnding on your version of VFP, there are additional ways to get the same and more information on your index expressions. e.g see the ATAGINFO( ) Function if your VFP has it.

Rick

 

[alexisgacia]

Hope this will help you my frend...
*--------------------------
SET EXCLUSIVE ON
SET DELETED Off
SET SAFETY OFF

xfrm_dbf= ""
XTARGET = "dbf_scod"
SET TALK OFF

crea table (XTARGET+".alx") (table_name c(20),table_path c(100))
clos data
use (XTARGET+".alx") alia temp IN 0

dum = ADIR(jhun,xfrm_dbf+'*.dbf') && get all dbf and store into array
for x = 1 to dum
dum3 = xfrm_dbf + allt(jhun[x,1])
use (dum3) in 2
if !empt(alias(2))
sele 2
xcnt=0
do whil .t.
xcnt = xcnt+1
if(key(xcnt) = "your xpression"
*** change your expression
*** like 'inde on blaa tag blaa
exit
endif
if(empt(key(xcnt))
exit
endif
enddo
use
endi
endf

clos data


alexis

 

[Nifrabar]

Hi!
Be aware that by modifying on the fly, as far as I remember, the index-file will grow.... and grow...... and grow....
-Bart