Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Bizarre append
Message
From
19/09/2006 14:30:05
 
 
To
19/09/2006 14:22:38
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
01155192
Message ID:
01155206
Views:
16
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
Previous
Reply
Map
View

Click here to load this message in the networking platform