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



Thanks Jamie.

> > >
> > > 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