>>>I would like to hear from those who have had
>>>problems due to filenames used in vfp.
>>>
>>>Thanks and have a great day.
>>>
>>>Becky
>>1) Make sure that your file names are not actually VFP reserved words like KEY,CURSOR,STATUS,INDEX
>>
>>2) In a multi-user environment ALWAYS use unique names for temp files and tables, for example...
>>
>>STORE SYS(2015) TO tempdbf
>>SELECT * FROM mytable INTO TABLE (tempdbf)
>>USE (tempdbf) ALIAS TEMPFILE1
>>.
>>.
>>(your procs)
>>.
>>.
>>USE IN TEMPFILE1
>>ERASE (tempdbf+".dbf")
>>
>>//:^)
>
>Hi Larry,
>Not a problem if you create tables from cursors ...
>SELECT * FROM MyTable INTO CURSOR C_X NOFILTER
>SELECT 0
>USE DBF("C_X") AGAIN ALIAS T_X EXCLUSIVE && cursor is now fully read/write!
>USE IN C_X
>* do what ever with T_X
>USE IN T_X && it's gone completely
Its only "gone completely" if you don't create more that 1 index tag (.CDX). As soon as you create the second tag, the .CDX file does not automatically go away when you USE IN the cursors alias. You have to close the cursor and manually remove the .CDX file. It seems to work OK for no tags or if you create just one.