Re: [UV] Problem reactivating select list

2004-04-27 Thread John Hester
Thanks to everyone for all the suggestions. Turns out the solution was relatively simple. I just needed to use PERFORM ED instead of EXECUTE ED to make ED run in the wrapper program's workspace. This is in PICK flavor. Seems like I once knew the difference between EXECUTE and PERFORM in PIC

RE: [UV] Problem reactivating select list

2004-04-27 Thread Stevenson, Charles
Triggers would be nice, but the'd have to work on type19 files. Modifying ED is simple, but you might want to wrap other verbs, so generalized wrapper pgm is good. Protect the vanilla versions of ED, DELETE, UPDATE.RECORD, REVISE as 'remote-controlled' R-items that will only execute if executed b

RE: [UV] Problem reactivating select list[Scanned]

2004-04-27 Thread Georgia L. Pritchett
essage- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Behalf Of Hona, David S > Sent: Monday, April 26, 2004 11:04 PM > To: 'U2 Users Discussion List' > Subject: RE: [UV] Problem reactivating select list[Scanned] > > > Triggers have more overhead as

RE: [UV] Problem reactivating select list

2004-04-27 Thread Brian Leach
John, Why write a wrapper? ED is a scrudgy BASIC program - (uv Account BP ED.B). You could just modify that. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Hester Sent: 26 April 2004 22:22 To: U2 Users Discussion List Subject: [UV] Problem

RE: [UV] Problem reactivating select list

2004-04-27 Thread Hona, David S
It appears that ED is aware of an active select list 0, even when it is not using it. Interesting behavior - is this a bug or feature? Well, in INFORMATION flavour accounts - at least! In INFORMATION flavour, when you 'X' out, this appears to kill the active select list 0. Hence, upon the next in

RE: [UV] Problem reactivating select list

2004-04-27 Thread Logan, David (SST - Adelaide)
+61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, 27 April 2004 11:29 AM To: [EMAIL PROTECTED] Subject: RE: [UV] Problem reactivating select list

RE: [UV] Problem reactivating select list

2004-04-26 Thread Hona, David S
esday, April 27, 2004 3:40 PM To: U2 Users Discussion List Subject: RE: [UV] Problem reactivating select list Have you thought of using trigger subroutines to keep the audit trail? Much easier, and the before- and after-records and keys are available for you right there in the arguments. :D -

RE: [UV] Problem reactivating select list

2004-04-26 Thread Ray Wurlod
Have you thought of using trigger subroutines to keep the audit trail? Much easier, and the before- and after-records and keys are available for you right there in the arguments. :D -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users

RE: [UV] Problem reactivating select list

2004-04-26 Thread Ross Ferris
April 2004 9:12 AM >To: U2 Users Discussion List >Subject: Re: [UV] Problem reactivating select list > >[EMAIL PROTECTED] wrote: > >> >> John what is wrong with this approach >> loop >>readnext id else done = true >> until done do >>list<

Re: [UV] Problem reactivating select list

2004-04-26 Thread Clifton Oliver
You're not wrong. Triggers on files came in at rev 10. -- Regards, Clif On Apr 26, 2004, at 18:21, John Hester wrote: Correct me if I'm wrong, but on UV 9.6 I think I'd have to convert every UV file to a SQL table to be able to use a trigger. -- u2-users mailing list [EMAIL PROTECTED] http://

Re: [UV] Problem reactivating select list

2004-04-26 Thread Clif Oliver
You might try this. I am not on a system right now, so I can't test this until later. -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER & ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ saveList

RE: [UV] Problem reactivating select list

2004-04-26 Thread Adrian . Womack
Other things to consider: 1. What happens if someone uses XEQ within ED to edit another record. 2. What about people using UPDATE.RECORD 3. And what about REVISE (ENTRO/MODIFY) There are many different ways to get around audit trails if people want to. AdrianW -Original Message- From: J

RE: [UV] Problem reactivating select list

2004-04-26 Thread Adrian . Womack
We don't have this type of problem using PI/Open flavour - something to do with EXECUTE being run in a different process space under other flavours. Have a look at the PASSLIST keyword that can be used with EXECUTE. Something like: READLIST ID.LIST ELSE STOP EXECUTE "ED filename " PASSLIST ID

RE: [UV] Problem reactivating select list

2004-04-26 Thread Mark Eastwood
Humm...got me there...don't know when they added the ability to create Triggers on Non-SQL tables? > Correct me if I'm wrong, but on UV 9.6 I think I'd have to > convert every > UV file to a SQL table to be able to use a trigger. > ­__ This

Re: [UV] Problem reactivating select list

2004-04-26 Thread John Hester
Mark Eastwood wrote: Have you looked at "Triggers" ? I wrote a wrapper for the ED command last week to keep an audit trail of any changes made to files outside our applications. I'm just writing a before and after version of an edited record to a temp file and comparing afterwards. Corr

Re: [UV] Problem reactivating select list

2004-04-26 Thread John Hester
[EMAIL PROTECTED] wrote: John what is wrong with this approach loop readnext id else done = true until done do list<-1> = id repeat select list to mylist loop readnext id else done = true until done do execute "ed ":file:" ":id repeat then before, after, between the two loops you can d

Re: [UV] Problem reactivating select list

2004-04-26 Thread FFT2001
In a message dated 4/26/2004 5:22:07 PM Eastern Daylight Time, [EMAIL PROTECTED] writes: > I wrote a wrapper for the ED command last week to keep an audit trail of > any changes made to files outside our applications. I'm just writing a > before and after version of an edited record to a temp

RE: [UV] Problem reactivating select list

2004-04-26 Thread Mark Eastwood
Have you looked at "Triggers" ? > > I wrote a wrapper for the ED command last week to keep an > audit trail of > any changes made to files outside our applications. I'm just > writing a > before and after version of an edited record to a temp file and > comparing afterwards. > ­_