I would like to write a program to 'mass' delete windows/forms from an OI App.

I know I can manually do it thru the app. mgr but have 100 or more to delete.

my 'not so logical' pseudo code would be

select SYSREPOSWINS with app=myapp

choose windows/forms to delete

   delete

   select SYSREPOSWINEXES from above

      delete

   select SYSREPOSEVENTS from above

      delete

   select SYSREPOSEVENTEXES from above

      delete

My first question is what other table items should be deleted.

SYSREPOS? SYSREPOSIX? SYSREPOSVIEWS? Etc.

Also, should any indexes be rebuilt after the deletions?

Any "programming" tips/suggestions are appreciated.

Bruce,

I think if you use the TDESTROY Repository method on the SYSREPOSWINEXES rows, that's it. See the Repository - Methods, TDESTROY Method help article.

I admit that to me it seems the article says that a TDESTROY on a SYSREPOSWINEXES row takes out everything that has to do with the form except the SYSREPOSWINS row. But it does kill the SYSREPOSWINS row too. Probably just me having English as a second language.

- Oystein -

Oystein,

I am not sure I follow you where to go for the TDESTROY article you mention. And for general knowledge would still like to know the SYS database layout better.

I addition, these 100+ windows/forms to delete, need to be done at 10 other sites.

BC

Ok, I poked around and see TDESTROY as a repository function. I will try that but again am still interested in the tables affected by a form.

BC

Checkout http://www.sprezzatura.com/senl/volume_3_issue_2.htm#repos et seq

The Sprezzatura Group

World Leaders in all things RevSoft

Thank you for that!! I may have more questions after digesting…

After reading your article it would appear that to get a CLEAN delete of a window/form and all entities within an OI app. I would need to

check…

SYSREPOS

SYSREPOSLOCKS

SYSREPOSLOG

SYSREPOSEVENTEXECS

SYSREPOSEVENTS

SYSREPOSWINEXECS

SYSREPOSWINS

for values matching the selected formname and delete. Would you concur? Have I missed any?

In addition, the article states that SYSREPOS cannot be read via RTP57 but it can be read via the syseditor in OI and a sysproc.

Is there danger to this?

BC

Ermmm no - we were concurring with Oystein about TDestroy. The et seq referred to the following article at http://www.sprezzatura.com/senl/volume_3_issue_3.htm#repos where tdestroy is documented but we thought you're enjoy the series .

It is true that the SYSREPOS table cannot be read via RTP57 but it has, as the article states, it's own BFS which means that system tools can access it with impunity.

The Sprezzatura Group

World Leaders in all things RevSoft

Oy was referring to the online help. In the system editor type repository into a screen and press F1. From the list that appears on the right, choose Repository again and you'll have a list of them all.

The Sprezzatura Group

World Leaders in all things RevSoft

View this thread on the forum...