I have used AREV for more than 11 years. I'm currently converting an application from AREV 3.12 to OI 3.7. I think the tools available to convert and create OI applications are great. After working with Visual Cafe DDE for several months I also feel the support by Revelation and the contributors to this forum is unmatched by any company selling database development packages.

Perhaps the ease and speed of developing in AREV has spoiled me, especially when it comes to testing your application. It was very easy to use the TCL or Command window to create a browse list of records from a table and then view them to see if your programs were making the expected changes. I also like to insert test info into several records to if my programs will perform properly.

Since the Command window and its editing capabilities are not in OI, or so I've been told, how are OI developers testing their programs? What is being used to select,view and edit records?

There must be some feature built into OI that I haven't found or that I'm not using correctly. I'm hoping an experienced OI developer could share some of their database testing technics with me.

Thanks for your help.

Amr

Simply, the system monitor and the exec line of the system editor are the TCL equivilents. You can execute most commands from both and all commands from the system monitor.

Since the nature of the programs are different, the syntax is different between ARev and OI. You RUN programs, you don't execute cataloged verbs with VOC entries.

So, to delete a record you would type

RUN DELETE_ROW 'FILE','RECORD'

and so forth.

Here's document with a listing of some commands and how they should be run in OpenInsight. It's not exhaustive, but it gives you an idea of what to look for in the help file to find the commands your looking for. About 90% of the commands translated over, probably more.

akaplan@sprezzatura.com

Sprezzatura Group

The list will be most helpful.

How does a 'select' or 'edit' command translate, for example:

   "Select Invoice with Amount GT '10000' by CustomerNumber"

OR

   "Edit Invoice 234 235 236 237"

Thanks again for your help.

Amr

We'll do edit first because it's easier. To edit, you just go into the System Editor, then open the record you wish.

Selects are a little more complicated. Your select will be run from the exec line of the System Editor. The command would be

RUN RLIST "SELECT INVOICE WITH AMOUNT GT '10000' by CUSTOMERNUMBER", 5, "", "", ""

(You actually don't need the final 3 nulls, but you do when running form code, so I like to add them just so I'm in the habit.)

This will create an active list in cursor 0 like one from from the TCL line.

To do a list report, you would do something like

RUN RLIST "SELECT INVOICE WITH AMOUNT GT '10000' by CUSTOMERNUMBER CUSTOMERNUMBER AMOUNT CREATEDATE", 1, "", "", ""

This will send the report to the screen in the results window. If you want it to the printer, the second parameter should be 0.

Look at the RLIST routine entry in the help file. You should also look at the RLIST_EQUATES record for the meanings of the second parameter.

akaplan@sprezzatura.com

Sprezzatura Group

Thanks a lot for the examples; RLIST works almost the same as it did under Arev. I may suggest a little change in the command line to actually see the results. Simply change 'SELECT' for 'LIST':

RUN RLIST "LIST INVOICE WITH AMOUNT GT '10000' by CUSTOMERNUMBER CUSTOMERNUMBER AMOUNT CREATEDATE", 1, "", "", ""

Is there a way to use RLIST within a deployed runtime application? May I put it in a push button or any other control? Is it OK with the licence schemes?

One thing I tested and did not work is trying to have the command ask for user input, as in:

RUN RLIST "SELECT INVOICE WITH AMOUNT GT '?ENTER AMOUNT?' by CUSTOMERNUMBER CUSTOMERNUMBER AMOUNT CREATEDATE", 1, "", "", ""

Is there a way to do it?

View this thread on the Works forum...