Steve,
Is plays.dbf a free table? Free tables have a max field length of 10. Also, look at SCATTER NAME command (in code below). You end up with one object with one property for each field (except for memo fields). It works great for copying indiviual records.
>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 NAME oPlay
> SELECT games
> GO bottom
> SELECT 'plays'
> APPEND BLANK IN 'plays'
> GO bottom
> m.gamenum=plays.gamenum
> GATHER NAME oPlay
>ENDSCAN
>
>Thanks, steve
Steve Gibson