OpenInsight 2.6 - Access to Table Indexes

We have a window  (BOOKWIN) where we enter data on books in our library.  One of the fields - a multivalued field - in the BOOKFILE associated with the BOOKWIN is RCODE where we note the region/country related to a particular book.  We have set up an INDEX on the RCODE field in the BOOKWIN to simplify preparation of catalogs on specific areas of interest to a client.  The RCODE index and indexes on two other fields are maintained in the INDEX table "!BOOKFILE".  The RCODE for Nepal is "N", Japan is "J" etc.  We need to extract a KEYLIST of all BOOKFILE IDs with an RCODE containing "N" for example.  How do we gain access to the "!BOOKFILE".  The primary field in the "!BOOKFILE" table related to RCODE is  "RCODE_XREF".   

We have tried IXLOOKUP and EXTRACT_SI_KEYS without success.  We are obviously doing something wrong.   We Compile without a problem, but fail to get a KeyList  which we can then work with in sorting, formating and printing out our catalog. We are obviously missing some key point	s.

Would appreciate any guidance that anyone can provide! We are finally converting all of our Rev-G files over to OI. We have rewritten most of our RBASIC subroutines (30 or so) and most work beautifully except for this one. Guess we still have an RevG mind_fix

Jim Roberts

Tel: 727-573-5097

FAX: 727-572-5359

OrientalBookShelf@msn.com

Jim,

Have you tried the BTREE.EXTRACT subroutine? Perhaps the problem you are having deals with an improper search_criteria? I think that this thread may help you out.

-Stephen

Jim,

Ultimately I would recommend Stephen's suggestion of using Btree.Extract, but as a temporary workaround and quick method for testing your index integrity you could also use the RList subroutine to create a simple SELECT statement.

dbakke@srpcs.com

SRP Computer Solutions

Many thanks for your help. After a bit of experimenting the BTREE.EXTRACT solved my problem.

View this thread on the forum...