Conference utrop1::lnx_apo

475.0. "script language or ole (but how?)" by MLN010::PETRONIO () Tue May 27 1997 19:15

LNX INSTALLATION on  LNX 3.0.7UNIX SERVER WITH ORACLE, AND WINDOWS AND
WINDOWS95 CLIENTS.

I have to write a procedure to list in a document all the objects
(with some user and system attributes) contained in object "ARCHIVIO". 
Archivio is derived from 
obj cabinet and contains many drawers, which contain many folders, which 
contain many documents. More or less the list should look like this:

ARCHIVIO
        DRAWER1                   attr.1   attr2     attr3... 
		Folder1		  attr.1   attr2     attr3		
			document1 
			document2  
			....
		Folder2
			document1
			document2
			....
		....
	Drawer2
		Folder1
			....
		......
	.....

At the moment the list could contain about 3000 items.

THere is a useful script example in the APO reference manual but I've red in
the notesfile that script language routines do not work well if a result has
more than 500 items. I've red that an alternative could be Ole2 or DDE, but I
have no programming experience with them.
Is it possible to know if the script language is reliable for my situation or
is it possible to have some ole or dde examples I could use ?

Thank you very much for your help 		
Regards,

            Mietta		

    
    Mietta,
    
    
    The limitation of 500 is due to the problem with Query Language which
    only allows 506 objects to be returned.
    
    In your situation it would only be blocking if there are compound
    objects that hold more than 500 Objects.
    You'll have to ry this by hand.
    
    
    If you want to use OLE then you are talking about a Visual Basic
    program that needs to Query LinkWorks and will therefor also run into
    the 500 problem!
    
    A better solution is probably to do it completly with class programming
    You'll probably only have to write a view methods, because most of the
    methods will work recursively.
    
    Han 
    
    
    

LinkWorks V3.2 has a new query interface that does not have a limit
on the number of objects returned. Just for your knowledge.

Martin