Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select
Message
 
 
To
05/04/2010 16:01:19
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Select
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01458778
Message ID:
01458815
Views:
18
The output above was not really helpful. Do you match records by name? In other words, for each month you have many records. How do you match each month?

>>
>>>Field  Field Name      Type                Width    Dec   Index   Collate Nulls    Next    Step
>>>    1  ID1             Numeric                 3                             No
>>>    2  ID              Numeric                 2                             No
>>>    3  NAM             Character              10                             No
>>>    4  Y2009           Numeric                15      3                      No
>>>    5  Y2010           Numeric                15      3                      No
>>>    6  PER1            Numeric                15      3                      No
>>>    7  TY2009          Numeric                15      3                      No
>>>    8  TY2010          Numeric                15      3                      No
>>>    9  TPER            Numeric                15      3                      No
>>>   10  FLG             Numeric                 2                             No
>>>** Total **                                  108
>>
>>
>>Ok, and also some data (copy to 'temp.txt' delimited with tab)
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform