Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Number of Variables
Message
From
19/01/1999 15:03:49
 
 
To
19/01/1999 15:01:03
Raymond Humphrys
Michigan Department of Community Health
Bath, Michigan, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00177724
Message ID:
00177741
Views:
47
>>>>>>>With VFP6 is the Max number of variables 255? If it is, and you had four related tables each with 200 variables, how would bring them together to export into a single (big) ASCII table?
>>>>>>>
>>>>>>>thanks
>>>>>>
>>>>>>Firstly, maximum # of variables=65,000 (it's from VFP5 help and I guess VFP6 has at least not less). Also, variable is not the same as table field value, and obviously when you export data (COPY TO...) you don't create variables at all.
>>>>>
>>>>>I haven't tried yet, but you can have 65,000 variables in a single table?
>>>>
>>>>Raymond, are you speaking about variables or about fields?
>>>
>>>Variables
>>
>>It's something wrong here. Tables don't contains variables. They host fields and records.
>Ooops, fields

Ok. Number of fileds are really limited by 255. You may use John's advice (low-level functions) to create ASCII file here.
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform