Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Gather memvar not working for long field names
Message
From
06/08/2002 01:35:31
 
 
To
05/08/2002 14:09:55
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00686236
Message ID:
00686454
Views:
44
>>Thanks for the tip. The issue was not with scatter/gather. I have a routine that exports data in the form of a free table. I use a SELECT-Sql to create my free table. That is truncating my field names to 10 charachters. SO when I go to scatter/gather, they arent getting populated, the field names dont match up. The exported table needs to remain free.
>>
>>Any solutions, other than renaming all my fields?
>
>The oldest version of Scatter/Gather: scatter to laArray Memo. It will create an array and then the Gather From laArray Memo will fill your fields by position, regardless of names. This position dependence is what made it not so useful, so most probably everyone forgot about it, but I think it's still there and should work.

** INEXPERIENCED DEVELOPER ADVISES **
Free tables cannot have "long" field names. You must either rename them to the proper size applicable to free tables, or construct your SQL statement so as to create a temporary database into which you can place a table that will accept your "long" field names. At this point you can populate the table as needed.

Finally you can export the file within the temporary DBC onto a free table with the field names reset to the proper length.

Makes sense?
=========================
PabloSr, Still Learning!
DevDBFox
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform