When attach_table() is passed a volume name with no TableList, it attaches all the tables in the volume but does not add them to the SYSVOLUMES record (as it does when passed a TableList). This problem causes detach_volume() not to work.

This happens at least until OI 3.7

Thanks for your attention,

Karl Pozmann

The Database Group

[email protected]

Karl,

    I tried the following from system exec line and all worked fine. Is there anything that I am doing different from you?(ver OI3.7 Win98)

run attach_table 'e:\revsoft\arev312\nlm'

run list_volumes

REPOSITORY

MEMORY_RESIDENT

DATAVOL

E:\REVSOFT\AREV312\NLM

REVBOOT

UK

SYSCOLUMNS

Request successfully executed. 7 row(s) processed.

run detach_volume 'e:\revsoft\arev312\nlm'

                               Thanx

1. Dave

Karl,

Sometimes when one thinks a new row is missing from a table it's just because the OI tools don't automatically refresh table and record lists. E.g when one looks at tables and records in the System Editor one sometimes has to press the Refresh button in the Open record dialog. Or close and re-open Sys Ed.

But that couldn't explain why Detach_Volume doesn't work. Perhaps there's something wrong with the parameter. Here's one of mine: "RTP57*REGIMUS\BRUKDATA". (I think last time Detach_Volume failed for me it was because I forgot the "RTP57*" thing.)

(I hope you're not offended. I'm just suggesting blunders I'm likely to do myself.)

- Oystein -

Hi Karl,

Does this happen intermittently? I have never seen this occur, although I have seen SYSVOLUMES and SYSTABLES get out of sync without a good explanation of why. (In 3.61, the database loading mechanism was modified to synchronize the volumes and tables automatically.)

I have tested the specific scenario you provided, and did not see a desynchronization as you indicated, so I would like to determine what other factors are involved. Any further details?

Cameron Purdy

Revelation Software

View this thread on the Works forum...