Where are all the neat features such as F5, Copyrow and other administrative tools that are available on the APPMAIN menu in AREV 3.12?

Dale

Mostly still in Arev !!

No TCL as such but many old Arev commands are now OI procedures that can be run from system editor, system monitor or code.

For example you can use the COPY_ROW ssp which has similar syntax to arev from exec line in editor

RUN COPY_ROW "SrcTable" , "Rec" , "DestTable, "DestRec"

or

RUN RLIST "LIST MYFILE ETC " , "1" the 1 sends to screen not printer.

Most db admin is done from within database manager. We will be releasing some free OI tools on our web site www.prosolve.co.uk in the near future which give access to such common features.

Tony

I appreciate your response especially at this time of day. If I read your website correctly.

I have printed your response for future reference. Now that I know where it is, It would be helpful if you or someone would provide a series of steps such as:

System Editor

Menu Option

Do this

etc.

I am not asking for programming but just enough to understand what needs to be done.

Much Thanks in advance!!!

Dale

There's not really a series of steps to do. OpenInsight doesn't have and F5 type key that instantly loads a command line window. It does have two places that can accept command line input. One is the exec line of the system editor, which I'm sure you can find. The other is the system monitor. You can find that off Tools-Advanced.

Both windows work almost identical. Both accept commands to the engine for execution in the format

RUN PROGRAM 'PARAM1', 'PARAM2'….

All programs must be proceded by RUN. All parameters must be in quotes.

The differences are:

The system editor is case sensitive, so

RUN MYPROG 'ABC'

is different than

RUN MYPROG 'abc'.

The system monitor will convert all parameters to uppercase unless you preceed it with _run instead. So in the system monitor,

RUN MYPROG 'ABC'

is the same as

RUN MYPROG 'abc'

but is different than

_RUN MYPROG 'abc'.

The other difference is in what is allowed to run. The system monitor allows you to run programs in event handler context. That means windows, popups and all other UI stuff. The system editor does not allow this.

Sometimes, you can trick the system, but generally this is a pretty hard and fast rule.

As for what you can run from these lines, generally any function or subroutine can be executed, allow a few internal routines cannot be.

A general listing OI to ARev 2.x equivilants follows:

Attach_Table Attach

Alias_Table Setfile

Detach_Table Attach

Copy_Row RecordCopy

Delete_Row Delete

Activate_Save_Select GetList

Clear_Table ClearFile

Copy_OS_To_Row Record Copy from DOS file

Copy_Row_To_OS Record Copy to DOS file

Create_Table MakeFile

Delete_Table DeleteFile

List_Tables ListFiles

List_Volumes ListVolumes

List_Index ListIndex

Keep in mind this is no means exhaustive, but is a good jumping off point. Read though the programmers reference book either on line or in printed form for parameters to these functions and any others that might be there. Although most of them run the same as ARev, a few are slightly different.

You'll also want to thoroughly read the RLIST function as this function contains the old LIST and SELECT statements in ARev.

[email protected]

Sprezzatura Group

and as a side point… if you download the evaluation copy of SLIST from our web site (which is naturally free) it has a TCL equivalent which allows you just to type the command (say Copy_Row) and it will prompt you with a dialog box to fill in the parameters. It also permits the use of EVAL if you are not using a runtime copy of OI.

[email protected]

Sprezzatura Group

World Leaders in all things RevSoft

View this thread on the forum...