Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
 From: Patrick McGreevy
  Where is Patrick McGreevy?
 Clarksville
 Tennessee - United States
 Patrick McGreevy
 To: Mike Gagnon
  Where is Mike Gagnon?
 Pointe Claire
 Canada
 Mike Gagnon
 Tags
Subject: RE: VFP 9.0 Help: Max Number of Array Elements - ?!?!
Thread ID: 81103 Message ID: 81335 # Views: 12 # Ratings: 0
Version: Visual FoxPro 9 Category: General VFP Topics
Date: Thursday, November 10, 2005 2:29:58 PM         
   


> > Mike,
> > Do you know anyone at TEK-TIPS,com?
> > They will not let me logon, and I know it is because of numerous email changes in the last two years. But I go to the problem page and do not get a response. Mike Lewis did not have a contact, but I thought you might.
> > Sorry to post this here, but did not know how else to contact you.
> > Pat
>
> Try it one more time, old account, old password.
>
>
> > > PUBLIC ARRAY myArray[300000]
> > > In VFP 9.0 no errors, in VFP8.0 error. They increased the limit.
> > >
> > >
> > > > Colleagues:
> > > >
> > > > In VFP 8.0 and earlier, the VFP System Capacirties section in the Help stated firmly and unubiquously:
> > > >
> > > > "Maximum # of elements per array 65,000"
> > > >
> > > > Now, in that same section for VFP 9.0 it states something incomprehensive:
> > > >
> > > > "Maximum # of elements per array.
> > > >
> > > > Normal: 2 gigabytes
> > > > Member array: 2 gigabytes
> > > > Array of member objects: 65,000"

> > > >
> > > > I cannot understand that!
> > > >
> > > > If anybody does - please do enlighten me! (I am dead serious! It's not a rhetorical question.)
> > > >
> > > > TIA!
> > > >
> > > > Regards,
> > > >
> > > > Ilya

> >
> > Mike,
> > Do you know anyone at TEK-TIPS,com?
> > They will not let me logon, and I know it is because of numerous email changes in the last two years. But I go to the problem page and do not get a response. Mike Lewis did not have a contact, but I thought you might.
> > Sorry to post this here, but did not know how else to contact you.
> > Pat
> >
> > Ilya,
> > My guess about the 65,000 limit has something to do with the interactibility with Excel. It has a row limit of 65,000+ records when copying to a xls in VFP 8.0. Not sure about limits in other versions, except 5.0, which only copies to xl5 format with a limit of 16,383 records. VFP 8.0 actually copies the table out to a later Excel format which will accept the 65,000+ record structure.
> >
> > Remember, MS tried to incorporate VFP into the MS Developers Suite(1997) and failed. Your problem may be a legacy to that effort.
> >
> > Pat



Thanks Mike! Let me right in!

Tek-Tips is the first forum I ever joined. So it just feels comfortable there.

Again, thanks.

Pat



COMPLETE THREAD
VFP 9.0 Help: Max Number of Array Elements - ?!?! Posted by Ilya Rabyy @ 11/7/2005 7:37:44 PM
RE: VFP 9.0 Help: Max Number of Array Elements - ?!?! Posted by Yuri Rubinov @ 11/7/2005 8:20:08 PM
RE: VFP 9.0 Help: Max Number of Array Elements - ?!?! Posted by Mike Gagnon @ 11/8/2005 12:28:03 AM
RE: VFP 9.0 Help: Max Number of Array Elements - ?!?! Posted by Ilya Rabyy @ 11/8/2005 1:03:14 AM
RE: VFP 9.0 Help: Max Number of Array Elements - ?!?! Posted by Patrick McGreevy @ 11/9/2005 4:09:52 AM
RE: VFP 9.0 Help: Max Number of Array Elements - ?!?! Posted by Mike Gagnon @ 11/9/2005 1:27:02 PM
RE: VFP 9.0 Help: Max Number of Array Elements - ?!?! Posted by Mike Gagnon @ 11/10/2005 12:57:47 AM
RE: VFP 9.0 Help: Max Number of Array Elements - ?!?! Posted by Patrick McGreevy @ 11/10/2005 2:29:58 PM
RE: VFP 9.0 Help: Max Number of Array Elements - ?!?! Posted by Ilya Rabyy @ 11/10/2005 5:59:28 PM