You're welcome! Cursors can have long field names, but not free tables.
However, as Sergey points out, you don't have to copy to the temp table first, you can append directly from the cursor using the syntax Append from dbf('crsTempInput')
>Duh!!! Thanks Tore
>
>>Shorten the field names to 10 charaters or less!
>>
>>>Here's a strange. 2 cursors are created with the exact same structure. The first cursor is populated with data and written out to a temp.dbf file. The second cursor is selected and the data from the temp.dbf is appended. The data comes into the second cursor OK except that 2 of the fields that should have data are blank. What gives?
>>>Here's the code:
>>>
>>>create cursor crsTempOutput (fromnode n(5), thrunode n(5), tonode n(5), setval n(2), penalty n(2), ;
>>> onstreet c(40), onstreetdir c(2), tostreet c(40), tostreetdir c(2))
>>>
>>>create cursor crsTempInput (fromnode n(5), thrunode n(5), tonode n(5), setval n(2), penalty n(2), ;
>>> onstreet c(40), onstreetdir c(2), tostreet c(40), tostreetdir c(2))
>>>
>>>append from (lcInputTurnfile) type delimited
>>>
>>>select crsTempInput
>>>
>>>* A process to add some data
>>>
>>>set safety off
>>>copy to tempinput.dbf
>>>set safety on
>>>
>>>select crsTempOutput
>>>append from TempInput.dbf
>>>
>>>
>>>
>>>The 2 fields onstreetdir and tostreetdir come up empty even though there is data in the first cursor.
>>>
>>>The problem is solved if the copy to file is changed to create a delimited *.csv file and the append is modified accordingly. So I have a workaround but I'm trying to understand why the original code produces the problem.
>>>
>>>Thanks