Re: Project ideas....

On Mon, Aug 14, 2017 at 3:17 PM, <broehmer@xxxxxxxxxxxxxxx> wrote:

Booth,
If you do pick this up?,

I had thought about:
1. Adding a query to the subfile to select records.

This is in LSTFFD with or without selections. it uses WRKQRY but
could easily be made to use SQL so you don't need WebQuery.

2. Display DBR's and keys for the file.

LSTFFD does this too.

3. Make it so you can select a subset of the
fields for any of the columns shown: length, type, decimals, text,
keys,
etc.

Good idea. Sorting them by type, size, etc.

LSTFFD does have the ability to search for field names or field
descriptions (by customer request years ago).

It also will display triggers.

There is a browse source option that I implemented years ago using
another utility but that doesn't work and the original command is hard
to find. BRWOBJSRC if anybody has a copy it would be nice to throw in
an open source repository.

4. A nice print routine for it.

LSTFFD has this as well. Prints nicely on 8.5x11 paper. Converts
nicely to PDF.

Just a thought(s)...

Bill






From: Booth Martin <booth@xxxxxxxxxxxx>
To: "RPG programming on the IBM i (AS/400 and iSeries)"
<rpg400-l@xxxxxxxxxxxx>
Date: 08/14/2017 02:59 PM
Subject: Re: Project ideas....
Sent by: "RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxx>



OK. I feel stupid. No doubt no one has asked because they already know.

But how does one access the SYSCOLUMNS catalog view"?


On 8/14/2017 12:35 PM, Birgitta Hauser wrote:

Why not simply access the SYSCOLUMNS catalog view?

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars."

(Les

Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training

them

and keeping them!"
„Train people well enough so they can leave, treat them well enough so

they

don't want to.“ (Richard Branson)

--
Booth Martin
www.martinvt.com
(802)461-5349

Life is like an onion: you peel off layer after layer, then you find
there is nothing in it.
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD


"CONFIDENTIALITY NOTICE: This e-mail transmission (and/or the attachments accompanying it) contain confidential information belonging to the sender. The information is intended only for the use of the intended recipient. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or the taking of any action in reliance on the contents of the information is strictly prohibited. Any unauthorized interception of this transmission is illegal under the law. If you have received this transmission in error, please promptly notify the sender by reply e-mail, and then destroy all copies of the transmission."
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD

Bradley V. Stone
www.bvstools.com
MAILTOOL Benefit #11: Save Emails - Save emails that are sent out at a
global, user or individual email level.