Hi,

I have moved the OI application to another drive and now get the message "Open media failed on the following volume(s) C:|REVSOFT\OINSIGHT ……"

I can still run the application. How do I get rid of the msg ?

Peter

Peter,

You moved your OI from C:\REVSOFT\OINSIGHT\ to a different drive on the same PC? And deleted C:\REVSOFT\OINSIGHT\ afterwards?

Shouldn't be a problem if the locations (volumes) you had were in folders beneath the OI folder. But it seems your app still knows about tables in that old location (volume).

Try to reattach your tables in Database Manager (File | Remove and File | Add). Check first the Database Manager outline to find which tables to remove.

- Oystein -

Oystein,

]] You moved your OI from C:\REVSOFT\OINSIGHT\ to a different drive on the same PC? And deleted C:\REVSOFT\OINSIGHT\ afterwards?

Yes

]] Shouldn't be a problem if the locations (volumes) you had were in folders beneath the OI folder.

Yes, all is intack, subfolders all standard.

]] Try to reattach your tables in Database Manager (File | Remove and File | Add). Check first the Database Manager outline to find which tables to remove.

There are a 'zillion' tables, so I had a look at 'detach_table and attach_table' subroutines. I notice you can attach a complete volume, like

*Attach entire DATAVOL volume.

Attach_Table("DATAVOL", "", "", "")

If Get_Status(StatusCode) Then GoSub Error_Processing

but can't detach a complete vol, need to parse a tablelist. If I get all the tables in a list, I would not have to reference the .DICT for each table, surely ??

I notice when I tested a (File | Remove) in Database Manager it gave me an impact analysis. Will I loose any reference (forms/tables,events/properties) by detaching (ALL), then attaching (ALL) ?? I wouldn't think so, ….. surely; in AREV I think we used a simple DETACH/ATTACH VOL commands, …. easy.

Peter

Peter,

There are a 'zillion' tables, so I had a look at 'detach_table and attach_table' subroutines.

Fair enough.

I notice you can attach a complete volume, like *Attach entire DATAVOL volume. Attach_Table("DATAVOL", "", "", "") If Get_Status(StatusCode) Then GoSub Error_Processing

Nice. I don't think I ever noticed.

but can't detach a complete vol, need to parse a tablelist.

OK, but where to get the list from? If there's an inconsistency in your system you might have to be careful. I believe the tables you need to detach are listed in the .dbt file. That's why I told you to check the Database Manager outline. I think DM lists the tables it finds in the dbt file. (I might be wrong.) You can try to parse the dbt file if you're up to it. There is documentation around - on this site I think. Do a "Site Search" (bottom item of vertical menu bar to the left).

Haven't you got a list of tables somewhere externally to your OI - in system documentation for the app, perhaps?

Usually SYSTABLES will have a row for each table. You can of course check that and see if you think it's up to date. If SYSTABLES is ok, you can select and readnext through that. Each table's row has info on what it's location is.

If I get all the tables in a list, I would not have to reference the .DICT for each table, surely ??

(De)attach the data table and the DICT and index will follow.

I notice when I tested a (File | Remove) in Database Manager it gave me an impact analysis. Will I loose any reference (forms/tables,events/properties) by detaching (ALL), then attaching (ALL) ?? I wouldn't think so, ….. surely; in AREV I think we used a simple DETACH/ATTACH VOL commands, …. easy.

It's safe to do. It's certainly not like your forms afterwards will not know which tables they're bound to.

On the other hand you can't trust what the impact analysis says. When I remove a table in my own OI, impact analysis mentions just a few of the forms affected.

- Oystein -

Hi Oystein,

Many thanks to you for your detailed replies, much appreciated. I often wondered when OI uses the .DBT files, so now I know. I wonder if the 'expand view' (dble-click) on a volume in DM uses REVMEDIA or 'appname'.DBT ?

Peter

Peter / Oystein,

Another un-docced feature in Detach_Volume that you can use from System Editor, only parameter is the path eg DATAVOL.

Simon

Rebus Software

Simon,

Thanks.

Funny there's a Detach_Volume and no Attach_Volume. Ordnung muss sein - nicht!

- Oystein -

Pedro,

I wonder if the 'expand view' (dble-click) on a volume in DM uses REVMEDIA or 'appname'.DBT ?

As I said before I think it's the dbt file. REVMEDIA can contain detached tables. When you detach a table it's still in REVMEDIA.

But that should be easy to check:

- Save a copy of .dbt

- Start OpenInsight

- Detach a table X

- Delete a table Y

- Log off OpenInsight

- "Restore" .dbt from the saved copy

- Start OpenInsight

- See if Database Manager still lists tables X and Y.

- Oystein -

That that that I said should be easy to check was the dbt stuff, not REVMEDIA. (Which also is easy to check, of course.)

- O -

There's always the DETACH_VOLUME system routine….

The Sprezzatura Group

World Leaders in all things RevSoft

To Oystein, Simon and the guys @ Sprezzatura,

Many thanks for your help. It would be great to have *all* those undocumented OI features, ….. well, documented !!!

Peter

View this thread on the forum...