I try to do some scripting to automatic clearing the “Using Index Property” of Oracle primary keys. So I dowloaded some JScript examples and take a look at the “Reference Guide” under “Expert Mode”. Until now I did not find out, how to easily walk along the object tree. I even do not now the Object Names and a call to Key.SupportsProperty(“Using Index Properties”) (Key is Entitie.Key) does never return true.
So where to find a documentation or a way to get the technical names of Objects and Properties.
Hallo Vaclv,
thank your for your advice. Here are two things to clearify:
First, i did not mean the index properties, i meant the key properties.
As you know, in oracle primary key and index are nearly the same. So in my case, I just want to clear the storage and logging clause.
The PK_ANSCHRIFT is not listed in the index list, it is listed in the key list!
Second: I knew the “Reference Guide” but find it hard to read. So i.e. the indexes. How to know, that from the index view, tab “Index Properties” the jScript IndexProp="" only cleares the free text (STORAGE CLAUSE i.e.) and not the tablespace or other entries?
A bit more example code on the web side would be great. And there is missing a list of valid values for the PropertyValueByName ParamName parameter.
thx a lot. Main problem was, that the GUI did not name the textfield, that contains the storage clause. So in jScript I thought that I have to walk to something named “UsingIXClause” or “UsingIndexClause” an so forth and than iterate through that to get to the textfield entry. I did not now and could not find in the documentation that it is ordered that way. Maybe I was blind or a bit confused. Thank so far.
You are welcome. I am glad I could help you. In case you need more information, feel free to post your questions here. The documentation cannot cover all possible customization tasks.