OI 3.7

I have two data tables that share one dictionary. That is, the dictionary is aliased. I do this to seperate committed and non commited records in a financial appliaction.

The problem is that I can not add indexes to the data table whose dictionary is aliased. It does not give me this table when I go to the "Add BTREE Indexes" part of the Database Manager.

How do I add indexes to a data table that uses an aliased dictionary?

Thanks,

Michael

You would have to put the index on the original table, as the "alias" does not actually exist as a distinct entity– its just another way of referring to the original object.

View this thread on the Works forum...