List_Volume (OpenInsight 16-Bit Specific)
At 19 MAR 2002 05:40:30PM Godfrey Farrugia wrote:
The documentation for List_Volume says that one can get the TABLE_NAME and TABLE_FOREIGN_NAME together but I couldn't manage although I can get them one by one.
Executing the RUN LIST_VOLUME at command level shows the result in a window but how can I obtain the same results from within a procedure? The subroutine seems to be executing correctly but where do the results go?
At 19 MAR 2002 06:03PM Richard Guise wrote:
I recollect we hit this some time ago. I recollect that LIST_VOLUME is only of use from system command line. I think the experts suggested using some horrendous contortion using the RECEIVER property. It turned out much simpler to do a DIY job for use within programs.
If you want me to look out our routine and email it to you, please email me on [email protected]. Otherwise someone else might tell you of some hidden undocumented routine dep within OI which does just what you want (ever heard that before???).
At 19 MAR 2002 10:19PM Richard Hunt wrote:
Well, it just so happens that I was trying something very similar just this weekend. I was trying to get LIST_USERS to do the same thing you are trying to get LIST_VOLUME to do.
I understand that both LIST_USERS and LIST_VOLUME are very similar.
Check this out and you will get the idea on how to do it. Search this list using "LIST_USERS". Then check for the item "LIST USERS (JOHN DUGUETTE 08/19/97). If you replace the LIST_USERS with LIST_VOLUME, I think you will get the results you are looking for.
Gotta thank John Duguette for his contribution on 08/19/97. Otherwise I would have never figured out how to get it to work.
At 19 MAR 2002 10:41PM Donald Bakke wrote:
Richard,
Then check for the item "LIST USERS (JOHN DUGUETTE 08/19/97).
That would be "Duquette" with a "q" not a "g". You are right, however, in that he contributed quite a few nice things to the board.
At 20 MAR 2002 12:14PM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:
Godfrey,
List_Volume uses the List_Volume_Sub() routine which you can use too. I beleive it has the same arguments as List_Volume:
eg.declare function list_Volume_SubtableInfo=list_Volume_Sub( volName, "", "" ,"" )etc…
World leaders in all things RevSoft
At 20 MAR 2002 01:21PM Richard Guise wrote:
Yes, Sprezz are correct. When I looked up our program for GFE checking written a while ago it indeed uses LIST_VOLUME_SUB with the same params including field names from the dict to get what one wants.
There are quite a few routines like that lurking in SYSOBJ which are at the least useful (if not essential) for serious developers.
Hopefully the new on-line help will include most, if not all of these. Hint, Hint!
At 20 MAR 2002 01:42PM John Henry wrote:
Godfrey,
Check the INSERT record 'VOL_TABLE_EQUATES' in SYSPROG. These apply to @TABLES and @VOLUMES. @TABLES is a matrix so a list of tablenames looks like:
Tablenames=@TABLES(0)
At 21 MAR 2002 01:42PM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:
Actually, most of this "externalization", LIST_VOLUME_SUB, MAKE_USER_SUB, COPYROW_SUB and so forth was done for ARev 3.1.
A good number of them were uploaded to the KB by an interpid support representative before he left RTI at the end of 1996. They start around this area of the KB
I wonder what ever happened to him……I guess we'll never know.
World Leaders in all things RevSoft
At 21 MAR 2002 06:20PM Godfrey Farrugia wrote:
Thank you all for your useful assistance which enabled me to achieve what I was after. This online discussion is a blessing.
At 21 MAR 2002 06:30PM Don Miller - C3 Inc. wrote:
Godfrey ..
Bless you my son ..
Don