select crsTempOutput append from ( DBF("crsTempInput "))>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?
>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 > >>