Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append from question
Message
From
03/07/2000 19:51:32
Cindy Winegarden
Duke University Medical Center
Durham, North Carolina, United States
 
 
To
03/07/2000 14:58:15
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00387833
Message ID:
00387914
Views:
18
Tony,

One more idea:
CREATE CURSOR FirstCursor(Field1 C(10), Field2 C(10))
APPEND FROM Temp.txt TYPE SDF

COPY TO ARRAY laMyArray

CREATE CURSOR SecondCursor(Date1 D, Date2 D)
APPEND FROM ARRAY laMyArray
The array is pretty flexible with data types.


>I have set century on and set date to american and trying to append a text file with two fields like:
>
>01/01/200002/01/2000
>02/01/200002/02/2000
>
>into a table with 2 date fields
>d_start d (8)
>d_end d (8)
>
>and issue the command: append from temp.txt type sdf.
>
>VFP results with :
>
>rec #1
>d_start = 01/01/0020
>d_end = 01/02/2000
>
>rec #2
>
>d_start = 02/01/0020
>d_end = 02/02/2000
>
>Why is the first field turns into 0020 as year and 2000 on the second record?
>
>Help appreciated.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform