>Rick
>
>That gives me the file does not exist message too.
>Thanks for the effort
Bill,
That is because the cursor only exists in memory. the filename has been given to the cursor, but it is just not there (yet)
You might be able to force it to be written to disk by adding an index to it
INDEX ON ... TAG ...
Walter,
>>>The code below has been running since 2003 on WinServer3003
>>>
>>>When testing it on win server 2008 the ALTER TABLE command fails with the message that
>>>"File C\windows\temp\1\xxxxxx.dbf does not exist"
>>>I can select that cursor but I can't execute the ALTER TABLE command
>>>
>>>Any ideas?
>>>
>>>
>>>
>>>SELECT a_slips
>>> = AFIELDS(la_rptcur)
>>> CREATE CURSOR rptfile FROM ARRAY la_rptcur
>>> ALTER TABLE rptfile ADD COLUMN rte_base N(5, 2)
>>>
>>
>>
>>I don't know the cause, but try this workaround to see if it fixes it:
>>
ALTER TABLE (FULLPATH(DBF('rptfile'))) ADD COLUMN rte_base N(5, 2)