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