Rick
That gives me the file does not exist message too.
Thanks for the effort
>>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.