Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Gather memvar not working for long field names
Message
From
05/08/2002 14:12:44
 
 
To
05/08/2002 14:04:29
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00686236
Message ID:
00686262
Views:
45
Steve,

You're welcome.

>The issue was not with scatter/gather.

Yes, I know, I was simply saying I prefer SCATTER NAME over SCATTER MEMVAR for doing this type of operation.

>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?

Are there a lot of fields? Do the field names change? If they don't change, you can use a REPLACE statement for those fields that are not working with SCATTER/GATHER.

If the fields on the two tables are in the same order, you can use SCATTER TO array...then the field names themselves don't matter.

HTH,
Steve Gibson
Previous
Reply
Map
View

Click here to load this message in the networking platform