I did not delete the *]I files but will do so and try again.
Thanks Mike.
Original Message:
Sent: 07-07-2023 10:44
From: Mike Street
Subject: LIST-INDEX not working as expected in jBASE 5.8
Jim,
There seems to be an incompatibility between jBASE 5.7.x indexes and jBASE 5.8.x indexes.
We would recommend that you delete the INVOICE]I file, rebuild the indexes and try again.
We assume that you already have a script for rebuilding indexes, but if you do not, there are utilities for both indexes and triggers;
PN5_60668 (rocketsoftware.com)
If this works, you would need to do the same for all other files with indexes
Mike
------------------------------
Mike Street
Technical Support Engineer
Rocket Internal - All Brands
Original Message:
Sent: 07-06-2023 11:28
From: J Edwards
Subject: LIST-INDEX not working as expected in jBASE 5.8
We are in testing a new server where we've installed jBASE 5.8. We migrated everything from the old server running jBASE 5.7 and are concerned about indexes.
Although we rebuilt all the indexes the LIST-INDEX command does not display the indexes on jBASE 5.8
Using the INVOICE file as an example, on jBASE 5.7, "LIST-INDEX INVOICE" displays the following:
INDEX definitions for file INVOICE at 11:22:28 06 JUL 2023 PAGE 1
INDEX NAME LOCALE NAME SORT KEYS. LOOKUP.... INDEX DEFINITION...................
@18 C AR D2/ BY-AR OCONV(19,\D2/\)
@28 C AR D2/ BY-AR OCONV(32,\D2/\)
@29 C AR D2/ BY-AR OCONV(33,\D2/\)
@3 C AL BY 2
@50 C AL BY 50
A154 C AL BY 154
A19 C AR BY-AR 19
A210 C AR BY-AR 210
A32 C AR BY-AR 32
A33 C AR BY-AR 33
W-BY C AL BY 22
11 Records Listed
On jBASE 5.8, "LIST-INDEX INVOICE" displays nothing.
I rebuilt the indexes using the following command: rebuild-index -a INVOICE and it displayed the following and ran for quite some time.
Building index records in file '/jbase/accounts/MISIQ/jbase_root/INVOICE' ...
When I do a select on that file in 5.7 it returns as expected correctly. The select on 5.7 does not return anything.
Any ideas on what I might have done wrong?
Thanks.
------------------------------
J Edwards
IT Manager
Plimpton & Hills
------------------------------