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: 81216 # Views: 27 # Ratings: 0
Version: Visual FoxPro 9 Category: General VFP Topics
Date: Wednesday, November 09, 2005 4:09:52 AM         
   


> 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



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