|
midrange.com
Yes I know.
But what happening is that they are changing Query when presented with the
RUNQRY after they mouse click on that Query listed in subfile record. I
was originally wanting to stop them from doing this and was looking for a
way to do 5 option from WRKQRY. Someone suggested "I would be" or "someone
else would be" GOD LIKE if way could be found.
Thanks
Bill Hopkins
"Rubino, Jim" <Jim.Rubino@xxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
10/16/2003 12:40 PM
Please respond to Midrange Systems Technical Discussion
To: "'Midrange Systems Technical Discussion'"
<midrange-l@xxxxxxxxxxxx>
cc:
Subject: RE: Display A Query Definition Question
Bill,
You know you can do WRKOBJ OBJ(*ALL/yourqueryname) OBJTYPE(*QRYDFN)
And then do an 8 to display the objects description, then page down once
to
see what the last change date is but not who changed it.
Jim Rubino
Senior Business Systems Analyst
FIKE CORPORATION
704 South 10th Street
Blue Springs, Mo. 64015
(816) 229-6216 Ext. 213
-----Original Message-----
From: Bill Hopkins [mailto:BHopkins@xxxxxxxxxxxxxxxxxxx]
Sent: Thursday, October 16, 2003 11:05 AM
To: Midrange Systems Technical Discussion
Subject: Re: Display A Query Definition Question
No they trust me.
But I have had them change and run Queries.
Then swear that they did not and claim it did not produce correct results
to everyone.
I run again with the way it was unchanged and "it's a miracle it's
right".
Sometimes users try to hard to protect their a$$.
When they do things like that, it makes me waste a lot of time tracking
down the problems.
In this case "lack of problem".
Thanks
Bill Hopkins
rob@xxxxxxxxx
Sent by: midrange-l-bounces@xxxxxxxxxxxx
10/16/2003 11:49 AM
Please respond to Midrange Systems Technical Discussion
To: Midrange Systems Technical Discussion
<midrange-l@xxxxxxxxxxxx>
cc:
Subject: Re: Display A Query Defination Question
Why? They don't trust you. After all, they want to see the record
selection.
Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin
"Bill Hopkins" <BHopkins@xxxxxxxxxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
10/15/2003 02:13 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
To
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
cc
Subject
Re: Display A Query Defination Question
Thanks I was already using the
RUNQRY QRY(MYLIB/MYQRY) RCDSLT(*YES)
and was trying to stop them from being able to change Query Selection.
Guess I'll have to trust the users :( .
Thanks Again
Bill Hopkins
G Armour <garmour400m@xxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
10/15/2003 02:18 PM
Please respond to Midrange Systems Technical Discussion
To: Midrange Systems Technical Discussion
<midrange-l@xxxxxxxxxxxx>
cc:
Subject: Re: Display A Query Defination Question
Bill, whoever can give a solution to your question will be like a god,
since IBM told me eons ago that the reason you are stuck with the current
WRKQRY (non-)interface was that "it is an end-user tool". With logic like
that...
BTW, your question in its simplest form has been discussed before in the
list: http://archive.midrange.com/midrange-l/200306/msg01405.html
GA
--- Bill Hopkins <BHopkins@xxxxxxxxxxxxxxxxxxx> wrote:
> I have a subfile program that list the queries that use whatever value
> is
> put in ScanFor field. Program Name, Fields or anything you want to look
> for. My question is there a way to display the query defination with a
> command like:
>
> Work with Queries
>
> Type choices, press Enter.
>
> Option . . . . . . 5 1=Create, 2=Change, 3=Copy,
> 4=Delete
> 5=Display, 6=Print definition
> 8=Run in batch, 9=Run
> Query . . . . . . . TESTQRY Name, F4 for list
> Library . . . . . BHOPKINS Name, *LIBL, F4 for list
>
> Would like to go straight passed this to the actual query so they may
> see
> where things were used but not change. And do not want them to key
> values
> on screen above.
>
> Right now it just mouse clicks from subfile record to blank WRKQRY
> command. But looking for just display.
>
> Any ideas?
>
> Thanks
> Bill Hopkins
__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
