If you scatter some memo fields, you need to use the MEMO clause.



>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