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 13:25:52
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Gather memvar not working for long field names
Miscellaneous
Thread ID:
00686236
Message ID:
00686236
Views:
105
Is there some sort of restriction on field name length? I am using scatter/gather commands to populate a table. However, certain
fields are not populating. I noticed the ones that arent working are the
ones with long field names.
I am using VFP7 SP1. It seems to be failing for me on any field name
longer than 10 charachters. For instance "ballcarrier, fieldposition,
playdirection" does not get populated, while all the shorter fields do get
populated.

My code follows, The select 'games' after the scan is needed for data rules:

LPARAMETERS cName, cDBF
LOCAL lcGameComment
SELECT (m.cDbf)
GO top
lcGameComment=alltrim(game_com)
SELECT games
INSERT INTO compusports!games (game, comment) VALUES
(ALLTRIM(m.cname),(lcGameComment))

SELECT (m.cDBF)
GO top
SCAN
SCATTER memvar
SELECT games
GO bottom
SELECT 'plays'
APPEND BLANK IN 'plays'
GO bottom
m.gamenum=plays.gamenum
GATHER memvar
ENDSCAN

Thanks, steve
Next
Reply
Map
View

Click here to load this message in the networking platform