Dim ZLib Set ZLib = CreateObject("ScriptUtils.ZLib") ZLib.SomeMethod SomeParameters ZLib.SomeProperty = SomeValue
You can also use CreateObject method method of Server object (ASP) to put the ZLib object to page scope or CreateObject method of WScript object in WSH.
You can also put the object to Application or Session scope using <object ...> tag in global.asa
<object runat="server" scope="application" id="ZLib" progid="ScriptUtils.ZLib"> </object>
Please use ActivexObject object in JScript/JavaScript to create ZLib object:
var ZLib; ZLib = new ActiveXObject("ScriptUtils.ZLib"); ZLib.SomeMethod(SomeParameters) ZLib.SomeProperty = SomeValue ...
VBA 5/6: You can reference the library using menu Project -> References
-> select 'Script Utilities library' in the listbox (or Project ->
References -> Browse -> select ScptUtl.DLL file).
MSAccess, Word, Excel: Tools -> Macro -> Visual Basic Editor, then Tools
-> References
Then you can write:
Dim ZLib As New ScriptUtilities.ZLib ZLib.SomeMethod SomeParameters ZLib.SomeProperty = SomeValue ...or
Dim ZLib As ScriptUtilities.ZLib ... Set ZLib = New ScriptUtilities.ZLib ZLib.SomeMethod SomeParameters ZLib.SomeProperty = SomeValue ...You can use CreateObject function also, of course:
Dim ZLib As ScriptUtilities.ZLib ... Set ZLib = CreateObject("ScriptUtils.ZLib") ZLib.SomeMethod SomeParameters ZLib.SomeProperty = SomeValue ...
You can reference the library using menu Project -> Add reference -> COM tab -> select 'Script Utilities library' in the listbox -> click Select. Then you can write (C#, J#):
//create a new ZLib objector (VBA)
ScriptUtilities.ZLib ZLib = new ScriptUtilities.ZLibClass();
ZLib.set_String("Some text value");
String SQL;
SQL = "Insert Into Table (BinaryColumn) values (0x" + ZLib.get_HexString() + ")"; ...
Dim ZLib As New ScriptUtilities.ZLib ZLib.SomeMethod(SomeParameters) ZLib.SomeProperty = SomeValue
DECLARE @ZLib INT, @OLEResult INT EXECUTE @OLEResult = sp_OACreate 'ScriptUtils.ZLib', @ZLib OUT IF @OLEResult <> 0 PRINT 'Error create component ZLib' --Set a property of ZLib. EXECUTE @OLEResult = sp_OASetProperty @ZLib, 'PropertyName', @SomeSQLValue IF @OLEResult <> 0 PRINT 'PropertyName set problem' --Get a value of a property of ZLib. EXECUTE @OLEResult = sp_OAGetProperty @ZLib, 'PropertyName', @SomeSQLValue OUTPUT IF @OLEResult <> 0 PRINT 'PropertyName get problem' --Call some method of ZLib. EXEC @OLEResult = sp_OAMethod @ZLib, 'MethodName', @ReturnValue OUTPUT, @parameter1, @parameter2
© 1996 - 2011 Antonin Foller, Motobit Software | About, Contacts | e-mail: info@pstruh.cz