List REVMEDIA (OpenInsight Specific) [Revelation On-Line Wiki]

Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community

At 26 JUL 2000 07:07:13PM Jane wrote:

OpenInsight Specific

I am trying to attach to REVMEDIA in a specific volume:

Call Detach_Table("REVMEDIA")

Call Set_Status(0, , )

Call Attach_Table(Volume, "REVMEDIA", "", "")

Error=Get_Status(StatusCode)

If Error Then
 ......
 end
But it fails on the ATTACH.

The Volume name is \apps\data\gl but the data has already been attached as: datavol\..\….

I am not in SYSPROG but in the application account.

It is not convenient to be SYSPROG.

Any suggestions?

At 26 JUL 2000 07:31PM Warren wrote:

I'm not very familiar with OI, but I believe you need to supply the DATABASE name parameter(SYSPROG) after the TABLENAME (REVMEDIA) parameter. I don't know how you handle password protection on the DATABASE though.

At 27 JUL 2000 09:12AM Simon W wrote:

Not necessarily, but I would suggest using the same volume label that the rest of the tables in that volume are attached by …

View this thread on the forum...