Alpha Video Training
Results 1 to 6 of 6

Thread: Error: Not an Open Index

  1. #1
    Member
    Real Name
    john fringer
    Join Date
    Dec 2004
    Posts
    104

    Default Error: Not an Open Index

    Can anyone give me some general guidance on what causes this error? It seems to be related to date fields, but not sure.

    I have a table that is giving me this error for some of the records, but can't figure out what might be causing this. I have tried all the usual stuff (compacting, etc).

    Any help would be greatly appreciated.

    Thanks...John

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

    Default Re: Error: Not an Open Index

    I'll quote Selwyn form a previous thread....

    a5 is telling you that it tried to access a table's index, but that the index was not open.

    it is unlikely that this error message alone will be enough to go on.

    1. what were you doing when this error happened?
    2. can you repeat the sequence and get the error to happen again?
    There can be only one.

  3. #3
    "Certified" Alphaholic Tom Henkel's Avatar
    Real Name
    Tom Henkel
    Join Date
    May 2002
    Location
    New Jersey, USA
    Posts
    1,875

    Default Re: Error: Not an Open Index

    a little more info might help...

    File layout, index definition, etc.

    Maybe tell us a little more about what you are trying to do.

    Thanks,

    Tom

  4. #4
    Member
    Real Name
    john fringer
    Join Date
    Dec 2004
    Posts
    104

    Default Re: Error: Not an Open Index

    Thanks Stan...

    I can repeat the error. Here is a general description of what...

    The table has several field rules that "tied" to an account number. I enter the account number and the field rules populate the fields. This part works correctly. I then enter a start date and end date, which determines if the contract is active, inactive or pending. This appears to be working properly too. When I save the record, I get the error: not an open index. If I delete the start date and end date, it will allow me to save the record.

    Probably too much to figure out on the message board. It has to be a field rule that is causing it, don't you think?

    Thanks again...

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

    Default Re: Error: Not an Open Index

    Quote Originally Posted by John Fringer View Post
    It has to be a field rule that is causing it, don't you think?
    Yes. If you can post a sanitized sample database someone can help you out.
    There can be only one.

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

    Default Re: Error: Not an Open Index

    John, what's the tablename? Any illegal characters in the tablename? in any of the fieldnames? in any of the indexnames? in any of the indextag expressions (definitions)?
    -- tom

Similar Threads

  1. “Error Unable to open compound index occurred while trying to start application.”
    By Dstorer in forum Upgrading to Alpha Five from Alpha Four
    Replies: 9
    Last Post: 12-12-2009, 10:19 PM
  2. "open index" error after tbl.range_add() V9
    By Kwoog in forum Application Server Version 9 - Web/Browser Applications
    Replies: 5
    Last Post: 09-13-2008, 11:54 PM
  3. Error "not an open index" in form calc field
    By Tony Rutherford in forum Alpha Five Version 7
    Replies: 6
    Last Post: 05-29-2006, 01:53 PM
  4. Not an open index error
    By richardurban in forum Alpha Five Version 6
    Replies: 0
    Last Post: 09-20-2005, 03:36 PM
  5. Unable to Open Compound Index Error Message
    By Daryl Mosier in forum Alpha Five Versions 2 and 3
    Replies: 1
    Last Post: 01-09-2001, 03:24 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
  •