i have a table called BROCHURE. field 20 is a date field. I did a tcl list and found 3796 old brochures. I want to insert arev date 11324 (01-01-99) in this field called dt.dead. to do thi manually will take days… any quick and easy way, routine or insight would be appreciated.

Easiest way I can think of to do this is to do a GLOBAL.

In 3.12, from a TCL type GLOBAL.

Follow the directions. It's really simple. Once you have the GLOBAL template built, press to save it (just once). Then press - to run a select or a getlist.

Once you have the filter, press to access the menu, and follow the options from left to right.

Matt Sorrell

msorrell@movgal.com

Matt,

I think Global is a custom utility. That command does not exist in standard ARev.

akaplan@sprezzatura.com

Sprezzatura Group

You might want to try the batch update routines(CW BATCH from TCL), but a simple select, read in the record, update the field and write back out shouldn't take more than 10 minutes to write.

akaplan@sprezzatura.com

Sprezzatura Group

Aaron,

It is a standard utility in HR-1 and related products.

Ah.

That would explain it. My boss used to be a Ceridian consultant before he started working here. I checked, it's just a VOC that invokes the @SYSWINDOWS@ BATCH window.

Learn something every day.

Matt Sorrell

msorrell@movgal.com

HR-1 has a bunch of great utilities like GLOBAL that I wish were incorporated into ARev.

GLOBAL is neat because you can specify formulas in the template to massage the data without having to write subroutines or symbolics.

Another great is the UPDATE utility, makes it easy for developers to deliver mods and apps.

View this thread on the forum...