Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Jamie Osborn
  Where is Jamie Osborn?
 Melbourne
 Australia
 Jamie Osborn
 To: Jamie Osborn
  Where is Jamie Osborn?
 Melbourne
 Australia
 Jamie Osborn
 Tags
Subject: RE: Maximum number of fields
Thread ID: 22802 Message ID: 22805 # Views: 16 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Saturday, April 26, 2003 4:11:12 AM         
   


> >
> > Hi all.
> >
> > I believe the maximum number of fields in a table is 255 under VFP 6.0.
> >
> > Is this maximum increased in later versions?
> >
> > If so, what is the new maximum number of fields?
> >
> > Thanks.
> >
> > Russell.
>
> Still 255 (254 if you allow NULL values)
>
> Max size of fields is 65,500 bytes (this is bigger than v6 I think)
>
> Cheers,
> Jamie
> jamie.osborn@foxite.com

Whoops - 65,500 bytes per record, not field !

Cheers,
Jamie
jamie.osborn@foxite.com

COMPLETE THREAD

Maximum number of fields Posted by Russell Hill @ 4/26/2003 2:57:24 AM
RE: Maximum number of fields Posted by Jamie Osborn @ 4/26/2003 4:10:16 AM
RE: Maximum number of fields Posted by Jamie Osborn @ 4/26/2003 4:11:12 AM
RE: Maximum number of fields Posted by Russell Hill @ 4/26/2003 12:46:41 PM