programatically filling a date field in a table from a list (AREV Specific)
At 25 MAR 1999 03:38:42PM Bruce Godwin wrote:
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.
At 25 MAR 1999 04:23PM Matt Sorrell wrote:
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
At 25 MAR 1999 06:42PM [email protected] - [url=http://www.sprezzatura.com]Sprezzatura Group[/url] wrote:
Matt,
I think Global is a custom utility. That command does not exist in standard ARev.
At 25 MAR 1999 06:43PM [email protected] - [url=http://www.sprezzatura.com]Sprezzatura Group[/url] wrote:
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.
At 25 MAR 1999 06:51PM Victor Engel wrote:
Aaron,
It is a standard utility in HR-1 and related products.
At 26 MAR 1999 10:05AM Matt Sorrell wrote:
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
At 26 MAR 1999 08:48PM Warren wrote:
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.