Strange Problem RDS/Indexes

For those who may have seen this before I appologise! unfortunately my internet s/w got itself corrupted so have lost track of any conversation. This is a request for help from those very familiar with RDS and indexing. The problem concernes failure of a system developed using RDS which, with duplicate data, performs fine on a development system, but not on a run_time. The problem which follows, crops up in the early transactions shortly after the tables have been indexed. Here follows the description; System-1: HP Vectra RS/25 386 SCO Unix 3.2.2 Informix SE v4.10 Development Informix RDS v4.00 Development System-2: HP Vectra RS/25 386 SCO Unix 3.2.2 Informix SE v4.10 Development Informix RDS v4.00 Runtime Facility only Problem Outline: A duplicate database exists on both systems. A database table (order_det) exists with the first two columns as follows: order_no : char(10) line_no : char(2) Indexes were created on these columns as follows: create index order_det_ix1 on order_det (order_no) create index order_det_ix2 on order_det (line_no) After creating these indexes for the table, System-1 allows rows to be selected and updates correctly. However, when attempting to access rows from the table on System-2, a status 'NOTFOUND' is often returned - although not every time - even when the row can be selected using Informix ISQL v4.00 Also, when attempting to update a specific row identified by order_no and line_no, either the row is not updated at all, or a different row for the same order is updated. Again, this does not occur 100% of the time. Both systems are running the same RDS program. The only difference is that System-1 uses Informix RDS Development and System-2 uses RDS Runtime Facility only. The same problem occurs if the two indexes are replaced by a single index created as follows: create unique index order_det_ix1 on order_det (order_no, line_no) Without any index on the table, both systems function correctly. Any thoughts would be much appreciated. Thanks in anticipation. Miles -- ******************************************************************************** Computec Systems Support Ltd Miles Pearson Voice - (0482)803961 x4000 miles@weighton.demon.co.uk ********************************************************************************