>>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