Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Bizarre append
Message
From
19/09/2006 14:25:55
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
01155192
Message ID:
01155204
Views:
18
Thanks Sergey. I knew it had to be something obvious I was overlooking. Your additional insight is helpful. I had tried to append from the cursor and couldn't get it to work.

btw - Did you have any further thoughts on our previous exchange re the scroll wheel working in the combobox?

- Don

>When you copy to a free table, the field names longer than 10 characters are truncated. You can append from a cursor directly.
>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?
>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform