What is a huge Table

Dennis DIller dendil at electricalusa.com
Fri Dec 3 18:45:19 PST 2010


what is considered a large prc table
Lines of code _ _ _ _ _
KB SIZE          _ _ _ _ _
I have One file 159 KB in prc.input
                          125 KB in Tok
Each are 2900 lines of code


--------------------------------------------------
From: <filepro-list-request at lists.celestial.com>
Sent: Friday, December 03, 2010 6:49 PM
To: <filepro-list at lists.celestial.com>
Subject: Filepro-list Digest, Vol 83, Issue 3

> Send Filepro-list mailing list submissions to
> filepro-list at lists.celestial.com
>
> To subscribe or unsubscribe via the World Wide Web, visit
> http://mailman.celestial.com/mailman/listinfo/filepro-list
> or, via email, send a message with subject or body 'help' to
> filepro-list-request at lists.celestial.com
>
> You can reach the person managing the list at
> filepro-list-owner at lists.celestial.com
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Filepro-list digest..."
>
>
> Today's Topics:
>
>   1. filepro on the web (Enrique Arredondo)
>   2. Re: HUGE tok tables (Kenneth Brody)
>   3. mid (Richard Kreiss)
>   4. Re: mid (Kenneth Brody)
>   5. Re: mid (Bruce Easton)
>   6. Re: HUGE tok tables - ooops (Scott Nelson)
>   7. RE: mid (Richard Kreiss)
>   8. Re: filepro on the web (Bruce Easton)
>   9. Re: OT: HDMI ports (C Day)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Fri, 3 Dec 2010 15:20:17 -0600 (CST)
> From: Enrique Arredondo <henry at vegena.net>
> Subject: filepro on the web
> To: filepro-list at lists.celestial.com
> Message-ID: <Pine.SC5.4.60.1012031513350.4145 at atksco1>
> Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed
>
> Has anyone tried creating filepro menus over a browser and emulating that
> you are in a filepro menu but in reality it's the same filepro lookalike
> menu but there are just links that will do cgi scripts and then do what a
> normaly menu script will do ?
>
> I'm going to give it a try but I wanted to know if someone already did it
> and I can grab some ideas.
>
> thanks
>
>
>
>
> ------------------------------
>
> Message: 2
> Date: Fri, 03 Dec 2010 16:48:03 -0500
> From: Kenneth Brody <kenbrody at spamcop.net>
> Subject: Re: HUGE tok tables
> To: Scott Nelson <scott at logicdatasystems.com>
> Cc: Filepro-list at lists.celestial.com
> Message-ID: <4CF96593.6000201 at spamcop.net>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> On 12/3/2010 3:10 PM, Scott Nelson wrote:
>> fP 5.0.14 on SCO OpenServer 6
>>
>>
>> I see that most tok tables are smaller than their prc table.  On one
>> file that happens to be a virtual file, any prc that I tok is Many times
>> larger, and there is other odd activity, like extremely slow lookups.
>> The automatic table is empty.
>>
>> What could cause the toks to be so much larger?
>
> Something in the prc that generates lots of code and/or data.  Perhaps an
> array with a lot of elements?  Without any actual examples, we can only 
> guess.
>
> -- 
> Kenneth Brody
>
>
> ------------------------------
>
> Message: 3
> Date: Fri, 3 Dec 2010 16:52:35 -0500
> From: "Richard Kreiss" <rkreiss at gccconsulting.net>
> Subject: mid
> To: <Filepro-list at lists.celestial.com>
> Message-ID: <00e001cb9334$65593a40$300baec0$@gccconsulting.net>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Have a program using the following type of code
>
> If:
> Then: dim who(6);who["6"]="Cancel"
>
> This array is then filled in the form NNNN name
>
> If:
> Then: sl(1,.0)=listbox(who)
> If:
> Then: 3=mid(who[sl],"1","4");ab=mid(who[sl],"6","30")
>
> Why am I getting a syntax error that points to [sl]?
>
>
> Richard Kreiss
> GCC Consulting
> rkreiss at gccconsulting.net
> ?
>
>
>
>
>
>
> ------------------------------
>
> Message: 4
> Date: Fri, 03 Dec 2010 17:11:42 -0500
> From: Kenneth Brody <kenbrody at spamcop.net>
> Subject: Re: mid
> To: rkreiss at gccconsulting.net
> Cc: Filepro-list at lists.celestial.com
> Message-ID: <4CF96B1E.80701 at spamcop.net>
> Content-Type: text/plain; charset=UTF-8; format=flowed
>
> On 12/3/2010 4:52 PM, Richard Kreiss wrote:
>> Have a program using the following type of code
>>
>> If:
>> Then: dim who(6);who["6"]="Cancel"
>>
>> This array is then filled in the form NNNN name
>>
>> If:
>> Then: sl(1,.0)=listbox(who)
>> If:
>> Then: 3=mid(who[sl],"1","4");ab=mid(who[sl],"6","30")
>>
>> Why am I getting a syntax error that points to [sl]?
>
> Perhaps you are running an ancient version of filePro?
>
> This small test generates no error in 5.6 or 5.0, though it does in 4.8:
>
>   1  -------   -   -   -   -   -   -   -   -   -   -   -   -   -
>        ? If:
>        Then: dim who(6)
>   2  -------   -   -   -   -   -   -   -   -   -   -   -   -   -
>        ? If:
>        Then: sl(1,.0) = listbox(who)
>   3  -------   -   -   -   -   -   -   -   -   -   -   -   -   -
>        ? If:
>        Then: xx = mid(who[sl],"1","4"); yy = mid(who[sl],"6","30")
>
> Unless, that is, you have a typo, and have "s1" rather than "sl".
>
> -- 
> Kenneth Brody
>
>
> ------------------------------
>
> Message: 5
> Date: Fri, 03 Dec 2010 17:13:02 -0500
> From: Bruce Easton <bruce at stn.com>
> Subject: Re: mid
> To: Filepro-list at lists.celestial.com
> Message-ID: <4CF96B6E.2010207 at stn.com>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> I don't remember which version, but sometime prior to 5.0, you
> could not reference  certain expressions for the first argument of
> the mid function (including array or lookup references).
>
> Maybe that is the problem.  Try assigning the array reference
> to a dummy field and then use the dummy inside mid.
>
> Bruce
>
>
> Bruce Easton
> STN, Inc.
>
>
>
>
> On 12/3/10 4:52 PM, Richard Kreiss wrote:
>> Have a program using the following type of code
>>
>> If:
>> Then: dim who(6);who["6"]="Cancel"
>>
>> This array is then filled in the form NNNN name
>>
>> If:
>> Then: sl(1,.0)=listbox(who)
>> If:
>> Then: 3=mid(who[sl],"1","4");ab=mid(who[sl],"6","30")
>>
>> Why am I getting a syntax error that points to [sl]?
>>
>>
>> Richard Kreiss
>> GCC Consulting
>> rkreiss at gccconsulting.net
>>
>>
>>
>>
>>
>> _______________________________________________
>> Filepro-list mailing list
>> Filepro-list at lists.celestial.com
>> Subscribe/Unsubscribe/Subscription Changes
>> http://mailman.celestial.com/mailman/listinfo/filepro-list
>>
>>
>
>
>
> ------------------------------
>
> Message: 6
> Date: Fri, 03 Dec 2010 16:20:13 -0600
> From: Scott Nelson <scott at logicdatasystems.com>
> Subject: Re: HUGE tok tables - ooops
> To: Kenneth Brody <kenbrody at spamcop.net>
> Cc: Filepro-list at lists.celestial.com
> Message-ID: <4CF96D1D.8000809 at logicdatasystems.com>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> I totally forgot that the arrays are built out in the tok file.  And I
> had some Huge arrays in there.
>
> I did notice a processing slow down with them large, and I need to test
> the system limits on this.  Perhaps hitting a buffer size with filePro?
>
>
>
> On 12/3/2010 3:48 PM, Kenneth Brody wrote:
>> On 12/3/2010 3:10 PM, Scott Nelson wrote:
>>> fP 5.0.14 on SCO OpenServer 6
>>>
>>>
>>> I see that most tok tables are smaller than their prc table.  On one
>>> file that happens to be a virtual file, any prc that I tok is Many times
>>> larger, and there is other odd activity, like extremely slow lookups.
>>> The automatic table is empty.
>>>
>>> What could cause the toks to be so much larger?
>>
>> Something in the prc that generates lots of code and/or data.  Perhaps
>> an array with a lot of elements?  Without any actual examples, we can
>> only guess.
>>
>
>
>
> ------------------------------
>
> Message: 7
> Date: Fri, 3 Dec 2010 17:28:21 -0500
> From: "Richard Kreiss" <rkreiss at gccconsulting.net>
> Subject: RE: mid
> To: "'Kenneth Brody'" <kenbrody at spamcop.net>
> Cc: Filepro-list at lists.celestial.com
> Message-ID: <00e701cb9339$64ab54c0$2e01fe40$@gccconsulting.net>
> Content-Type: text/plain; charset="utf-8"
>
>
>
>> -----Original Message-----
>> From: Kenneth Brody [mailto:kenbrody at spamcop.net]
>> Sent: Friday, December 03, 2010 5:12 PM
>> To: rkreiss at gccconsulting.net
>> Cc: Filepro-list at lists.celestial.com
>> Subject: Re: mid
>>
>> On 12/3/2010 4:52 PM, Richard Kreiss wrote:
>> > Have a program using the following type of code
>> >
>> > If:
>> > Then: dim who(6);who["6"]="Cancel"
>> >
>> > This array is then filled in the form NNNN name
>> >
>> > If:
>> > Then: sl(1,.0)=listbox(who)
>> > If:
>> > Then: 3=mid(who[sl],"1","4");ab=mid(who[sl],"6","30")
>> >
>> > Why am I getting a syntax error that points to [sl]?
>>
>> Perhaps you are running an ancient version of filePro?
>>
>> This small test generates no error in 5.6 or 5.0, though it does in 4.8:
>>
>>    1  -------   -   -   -   -   -   -   -   -   -   -   -   -   -
>>         ? If:
>>         Then: dim who(6)
>>    2  -------   -   -   -   -   -   -   -   -   -   -   -   -   -
>>         ? If:
>>         Then: sl(1,.0) = listbox(who)
>>    3  -------   -   -   -   -   -   -   -   -   -   -   -   -   -
>>         ? If:
>>         Then: xx = mid(who[sl],"1","4"); yy = mid(who[sl],"6","30")
>>
>> Unless, that is, you have a typo, and have "s1" rather than "sl".
>>
>> --
>> Kenneth Brody
>
> Problem solved, checked the map.  It appears that I added a field who and 
> never adjusted this program.  When I changed the array to whose(6) and 
> adjusted the program to use this array name, no syntax error.
>
> My question is why the syntax error at who[sl] and not who("6"]="cancel" 
> which is prior to the who[sl].  Only at the point where it needed to 
> resolve which element did the error occur.
>
> Richard
>
>
>
>
>
> ------------------------------
>
> Message: 8
> Date: Fri, 03 Dec 2010 18:44:43 -0500
> From: Bruce Easton <bruce at stn.com>
> Subject: Re: filepro on the web
> To: filepro-list at lists.celestial.com
> Message-ID: <4CF980EB.1080706 at stn.com>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Enrique,
>
> I'm sure there are quite a number of people who have written browser
> apps to emulate filepro in various ways.  And I know there are some who
> have done a lot of it.  And there are some who have done a lot of it and
> worked for years on development programs to help them standardize and
> make efficient that type of development**.
>
> What is your goal for this?   Do you already have working cgi scripts
> and just need to emulate the menus?  I ask, because, for any
> browser-based app, depending on your needs, there can be a number of
> different disciplines involved.  I'll try to answer any specific
> questions you may have.
>
> **<adv>
> Also, you might want to take a look at our fPageBuilder page at:
>
> http://www/stn.com/products/dbinet.htm
>
> for ideas.  Included there are live demo apps and PDFs
> which explain and illustrate the development program.
>
> fPageBuilder is not yet for purchase, but will be very soon.  Currently,
> most of my time is spent using fPageBuilder for specific
> client needs on a services basis, or in working towards completion
> the manual.
> </adv>
>
>
> Bruce
>
> Bruce Easton
> STN, Inc.
>
>
>
> On 12/3/10 4:20 PM, Enrique Arredondo wrote:
>> Has anyone tried creating filepro menus over a browser and emulating that
>> you are in a filepro menu but in reality it's the same filepro lookalike
>> menu but there are just links that will do cgi scripts and then do what a
>> normaly menu script will do ?
>>
>> I'm going to give it a try but I wanted to know if someone already did it
>> and I can grab some ideas.
>>
>> thanks
>>
>>
>> _______________________________________________
>> Filepro-list mailing list
>> Filepro-list at lists.celestial.com
>> Subscribe/Unsubscribe/Subscription Changes
>> http://mailman.celestial.com/mailman/listinfo/filepro-list
>>
>>
>
>
>
> ------------------------------
>
> Message: 9
> Date: Fri, 03 Dec 2010 15:44:16 -0500
> From: C Day <gliderman.one at frontier.com>
> Subject: Re: OT: HDMI ports
> To: filepro-list at lists.celestial.com
> Message-ID: <4CF956A0.7070801 at frontier.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> On 12/3/2010 11:43 AM, Richard Kreiss wrote:
>> I ordered a Sony sound bar for my Sony LCD.  This should have been a 
>> simple
>> installation.  One HDMI cable from the home theater system out to the 
>> flat
>> panel HDMI in.
>>
>> He's where the fun began, I could get sound but no video.  Although the 
>> TV
>> saw the home theater system, it still only would receive sound.
>>
>> Yesterday I called B&H Photo who I ordered the system from and got an 
>> RMA.
>> After repacking everything, I realized that these LCD's are nothing more
>> than a computer with a large monitor attached.  So, I unplugged the set 
>> for
>> a minute and then unpacked the sound system again and connected it.  It
>> worked perfectly.
>>
>> I felt really stupid in that we would tell a client, when they say a
>> peripheral isn't working, shutdown the computer and then restart it after 
>> a
>> few minutes.
>>
>> Why the email, just a reminder if you are attaching any Christmas 
>> presents
>> to you TV through an HDMI connection and get no video, unplug the set 
>> first,
>> not just turning it off with the remote, before thinking that the new 
>> device
>> isn't working.  Electronics go into standby mode and are not fully 
>> powered
>> off when they are "turned off".
>>
>>
>> Richard Kreiss
>> GCC Consulting
>> rkreiss at gccconsulting.net
>>
>
> Richard, the instruction book for my Vizio and sound bar tells you
> to unplug and wait for 20-30 seconds before plugging in again.
>
> Charles Day
> -------------- next part --------------
>
> No virus found in this outgoing message.
> Checked by AVG - www.avg.com
> Version: 9.0.872 / Virus Database: 271.1.1/3294 - Release Date: 12/03/10 
> 02:34:00
>
>
> ------------------------------
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
>
> End of Filepro-list Digest, Vol 83, Issue 3
> *******************************************
>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 10.0.1170 / Virus Database: 426/3295 - Release Date: 12/03/10
> 


More information about the Filepro-list mailing list