Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Gather memvar not working for long field names
Message
De
05/08/2002 13:25:52
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Gather memvar not working for long field names
Divers
Thread ID:
00686236
Message ID:
00686236
Vues:
109
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform