>I get, not every time, but often enough to cause great concern, an error message that is generated when the BEGIN TRANSACTION statement is issued that some view (not always the same one) of mine has an open non-structural index file open. I do not create any non-structural indexes (implies use of OF CDXfilename in the index command which I never use) for my views and these views are not going to be part of the transaction. I need to get around this error message and let these transactions progress. Private Datasessions, pessimistic buffering, view not part of the update but loaded in the DE and not buffered.
>
>Steve

Steve,

I've had this problem a few months ago, and it was related to the same view being indexed 2 times!


I had 2 different bizobjs with several common controls. One that accepts the search parameters and another to display the information.

Some of these common controls are based on a subclass of cifCombobox (a cifComboBox based on a view rather than on a cursor). In order to have this design work properly I need to index the view.
This was done in the init() of the DataEnvironments definitions.

The problem is that the views were indexed 2 times and this produced 2 different indexes on the same field, enough to make the RI code bomb ! The trick is to bracket the indexing as follows :

IF EMTPY(TAG(1))
INDEX ON xx TAG xx
ENDIF