Thanks, Walter and Rick.
I decided to alter the array before creating the cursor and just avoid the issue
Thanks for the ideas.
>>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)
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.