Alpha Video Training
Results 1 to 4 of 4

Thread: Button on Form Exceeds Maximum Open Tables

  1. #1
    Denny Johnson
    Guest

    Default Button on Form Exceeds Maximum Open Tables

    I am really a novice, poking around in xBasic without a manual...probably dangerous. Anyway, can you help? Thanx, Denny -- P.S. A .TXT script file is attached - NOT zipped. (My new email is patterntree@msn.com) The basic facts are these:
    1) Running Alpha5v4.03 build 230
    2) Using a Button on a form for table "glaspatt.dbf"
    3) Looking up contents of "glaspatt" field "searchcode" in child table "glaschacnodups.dbf" (linked one-to-many) on its field "searchcode" to match up with the correct "membername" (a misnomer, since "membername" is really only a definition of "searchcode"), and display via HTML the correct definition

    There are about 3,900 records in "glaspatt.dbf" - each with up to forty (40) 5-letter codes) in a single field "searchkeys" - and 4,000 definitions in "glaschacnodups.dbf" to match against each of the letter codes.

    The code produces about 315 complete webpages before returning this error:
    "ScriptOnPush Line...
    tchac=table.open(tablenamechac)
    maximum open tables exceeded"
    --------------------------
    4) Sample webpage contains the following in table format:

    9 Characteristic(s) Indexed for
    Clear Stork Pattern [Universal # 1293-01-A-01]
    AB012 Crane
    AB013 Stork
    AC007 Ovals: Vertical
    AN003 Plant: Pussy Willow
    BA002 Fan Impressed - 02 Straight Rays
    BB012 Arch: Top Rounded - Eyebrow Curve East To West
    BM009 Medallion: Oval - Horizontal
    EA001 Early American Pattern Glass [EAPG]
    Counter 315
    Counterchac 3378
    Completed the 9 Indexed Characteristics for "Clear Stork "Pattern [Universal # 1293-01-A-01]

  2. #2
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,311

    Default RE: Button on Form Exceeds Maximum Open Tables

    Denny,

    Your script opens the table 'tablenamechac' on each iteration through the loop assigns the same pointer (tchac) to the latest opened instance. I don't see that it closes each instance of that table when it's finished with it. Alpha may be opening 314 instances of the table before it runs out of memory or file handles...

    Try inserting a

    tchac.close()

    at the bottom of the inner loop, before the script loops back to open another instance of the table.

    The Xbasic Reference Manual should be in your Books subfolder in the Alpha Five program directory.

    -- tom

  3. #3
    Denny Johnson
    Guest

    Default RE: Button on Form Exceeds Maximum Open Tables

    Hi Tom, Thanks for responding...

    Using tchac.close() returns
    "invalid table handle"
    Using tchac.close(tablenamechac) returns
    "Internal - invalid argument number

    Any other ideas? Meanwhile, off to see if the xBasic manual is on my hard drive!

    Thanks, Denny

  4. #4
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default RE: Button on Form Exceeds Maximum Open Tables

    Trust Tom.

    The error you indicate seems to be saying that the tchac.close() statement is being executed before the tchac=table.open(tablenamechac).

    Double chech where you inserted the close.

    tchac=table.open(tablenamechac) defines tchac as a pointer variable (handle) to the tablenamechac table. If tchac is invalid, it hasn't been assigned. The .close() method does not require/does not allow the table name (tablenamechac) as a parameter.

Similar Threads

  1. maximum open tables exceeded
    By Tom Hlavin in forum Alpha Five Version 4
    Replies: 7
    Last Post: 03-04-2009, 10:38 AM
  2. maximum open tables exceeded?
    By Krister in forum Web Application Server v6
    Replies: 1
    Last Post: 04-12-2005, 07:22 AM
  3. maximum open tables exceeded
    By Harold Bussell in forum Alpha Five Version 5
    Replies: 1
    Last Post: 04-12-2004, 02:45 PM
  4. Button on Form Exceeds Maximum Open Tables
    By Denny Johnson in forum Alpha Five Version 4
    Replies: 0
    Last Post: 01-20-2003, 08:11 PM
  5. Why does A5V5 think tables or form are open?
    By Fred Daniel in forum Alpha Five Version 5
    Replies: 7
    Last Post: 01-15-2003, 04:29 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •