Ok, everyone, it took a couple of days but I converted the AREV NewBlist program for OI. Sofar in my testing it works GREAT! You can use it to print your StoreProcedures and Events (SysReposevents). Everything looks better to me and it really helps to see things in a more structured manner and should help in my conversion effort and new development. In the events, that someone else may find this helpful, please let me know and I can e-mail the code to you. (No critisim please. If you can make it better, then we expect you to provide the improve code to others ).

To run this routine, I exec BLIST (a form) from the system monitor.

BLIST has three controls: FileName, Item, Options. At LostFocus for each control, set UserDefinedProperty via Set_Property. At the Click Event, call this program (New_Blist). More details provided in note section of program.

I am also using OIPI for better formatting and control. For now, the program is setup to always print. You can make other enhancements if you wish. With this program you can print range (line 100 to 150). I really like this.

Thanks to all for their help – Don Miller (newblist), Don Bakke, Cam Purdy, and Oystein Reigem for their expert help and friendly assistance.

You don't realize what a @#&**( job that OI does in printing SP or Events until you see this!!

rayc@symmetryinfo.com onmouseover=window.status=imagine … ;return(true)"

Symmetry Info

Ray Chan ~ Symmetry Info

Ray,

Interested to get the code (and play with it).

regards

Richard Bright

r.bright@ark.co.nz

Ray..

Glad to have helped. Hope someone smarter than me can enhance it. NewBlist in one way or another has been a mainstay of our development since REV F! I'll take a look at your code to see if there's anything I can add to it. By the way, you can also use it to do DICTionary symbolics too.

Cheers ..

Don Miller

C3 Inc.

Ray,

Could you please e-mail me the code to address below?

Thanks,

Ilde.

ildefonso@trdesk.com

Don,

Yes, I saw that New.Blist could do symbolics, but my primary focus at the time was to be able to list my Stored Procedures and Event Scripts. For that, it does its job. I feel better already!!

I haven't had a need to do much dictionary listing in OI sofar, so I don't know how inadequate it may be altho I don't think it compares (from earlier playing) to what we had in AREV. I shall look at it later. If it's really bad (unless you or someone else address the Symbolic issue), I may take a look at it and give it a go.

Cheerio,

rayc@symmetryinfo.com onmouseover=window.status=imagine … ;return(true)"

Symmetry Info

Ray Chan ~ Symmetry Info

Ilde,

It's on its way or it's there!

rayc@symmetryinfo.com onmouseover=window.status=imagine … ;return(true)"

Symmetry Info

Ray Chan ~ Symmetry Info

You might be able to make some hay (and generalize the code as well) by using the @FILES variable to get a list of attached files. There is some similar code in the front-end for System Editor. You might then be able to display a list of @ID's (as fully qualified thingies) to select from.

Dicts might work like this..

IF FIELD(FILENAME,'.',1)=DICT' THEN

• build a list of keys that are symbolics ..

do an RLIST SELECT on the DICT.FILENAME with F1=S"

IF @RECCOUNT ] 0 THEN

   done=0

   KEYLIST='

   Loop

   READNEXT @ID THEN

      KEYLIST=INSERT(KEYLIST,1,-1,0,@ID)

   END ELSE done=1

   UNTIL done

   REPEAT

END ELSE .. some error message

It might also be possible to Chain Print multiple files, although this has gotten me into trouble with the range of lines option since it is global for ALL listings. Pretty nice job for a quickie .. I wish I had time to do all the things I would like to do.

Don M.

Don,

Wow, I just did a listdict in OI. It really is lame. I can't imagine what new developers must think. Could RTI have provided a less helpful tools? Again, it appears that AREV with its ListDict is more of an asset to developers than what's in OI. Oh well, you know this. I'm just getting my feet real wet.

Pretty nice job for a quickie ..

Gee I wish all the other girls felt that way . I doubt that I could have done any better with more time. Whoever wrote the original code did some serious thinking.

I wish I had time to do all the things I would like to do.

Ditto…like get my thing done.

Hey RTI if we could have the source code for ListDict (V45.116), maybe someone could hack it to work with OI. Please, Please, Please.

Thanks,

rayc@symmetryinfo.com onmouseover=window.status=imagine … ;return(true)"

Symmetry Info

Ray Chan ~ Symmetry Info

Please sign me up too, Ray.

I'm hoping this is better than sliced bread. It's tough "chewin' the whole loaf"

David Singer

dms@inteliport.com

David,

I'm hoping this is better than sliced bread.

Well, I guess this depends on who you ask. But from my point of view, the way Stored Procedures and Event Scripts printed was more of a hinderance than help in my effort to convert by programs to run under OI. (Speaking for myself only of course) Therefore being that my program listing are now more structured, easier to read and follow, I can see that things will be less painful (not less hard). For me, it's the best thing since sliced bread (but my memory is short).

Hope it'll help you and New_Blist is on its way.

rayc@symmetryinfo.com onmouseover=window.status=imagine … ;return(true)"

Symmetry Info

Ray Chan ~ Symmetry Info

Ray ..

Just so happens I have an already converted OI program called PSCHEMA which, again is really old (but pretty handy anyway). If you'd like a copy of it, please E-Mail me. I also have a quickie called DICT_ALPHA which sorts dictionaries alphabetically instead of by Field Mark #. Sometimes this comes in handy too ..

By the way, nice job doing comment blocks in New_Blist. I just never got around to doing that either (since I mostly use AREV 2.12 which didn't support that feature anyway). Somewhere I also have a version of NEWBLIST that will expand $INSERT blocks into a listing. My CROSS_REF utility does this too since you can get VNAV errors that way by being fumble-fingered.

Cheers,

Don Miller

Don,

You are one prolific guy. I can't keep up with all the changes you're making. I'm sure that many other developers could benefit some of the neat tools you have. Anything to save time!

PSCHEMA and DICT_ALPHA: I assume they work on the dictionary. Yes, if you don't mind, please forward them to me when you get a chance .

Thanks so much again. Please slow down. You're making my head spin ;). I best get back to my AREV conversion. The New_Blist really helps.

rayc@symmetryinfo.com

rayc@symmetryinfo.com onmouseover=window.status=imagine … ;return(true)"

Symmetry Info

Ray Chan ~ Symmetry Info

Ray,

Like you said, the listdict is sooo primitive, so one of the first things I did way back was to create a tool to display / print the table dict plus indexing info + symbolic.

Its rather crappy code - done I think when I was trying to get on top of OI2.x, but will dig it out and send

Regards

Richard Bright

Ray, if its not too late I would love to use your BLIST. It sounds great.

Thank you.

Dave Rioux

driou19@idt.net

Dave,

It's on its way! Enjoy,

rayc@symmetryinfo.com onmouseover=window.status=imagine … ;return(true)"

Symmetry Info

Ray Chan ~ Symmetry Info

Richard,

Got your e-mail. I shall unzip it and take a look later this weekend.

Thanks so much,

rayc@symmetryinfo.com onmouseover=window.status=imagine … ;return(true)"

Symmetry Info

Ray Chan ~ Symmetry Info

Dave,

I e-mailed the code, but it was returned to me.

Email me direct. This way I can reply to the correct e-mail address.

Thanks,

rayc@symmetryinfo.com onmouseover=window.status=imagine … ;return(true)"

Symmetry Info

Ray Chan ~ Symmetry Info

View this thread on the Works forum...