Dim ZLibCompressLevels Set ZLibCompressLevels = CreateObject("ScriptUtils.ZLibCompressLevels") ZLibCompressLevels.SomeMethod SomeParameters ZLibCompressLevels.SomeProperty = SomeValue
You can also use CreateObject method method of Server object (ASP) to put the ZLibCompressLevels 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="ZLibCompressLevels" progid="ScriptUtils.ZLibCompressLevels"> </object>
Please use ActivexObject object in JScript/JavaScript to create ZLibCompressLevels object:
var ZLibCompressLevels; ZLibCompressLevels = new ActiveXObject("ScriptUtils.ZLibCompressLevels"); ZLibCompressLevels.SomeMethod(SomeParameters) ZLibCompressLevels.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 ZLibCompressLevels As New ScriptUtilities.ZLibCompressLevels ZLibCompressLevels.SomeMethod SomeParameters ZLibCompressLevels.SomeProperty = SomeValue ...or
Dim ZLibCompressLevels As ScriptUtilities.ZLibCompressLevels ... Set ZLibCompressLevels = New ScriptUtilities.ZLibCompressLevels ZLibCompressLevels.SomeMethod SomeParameters ZLibCompressLevels.SomeProperty = SomeValue ...You can use CreateObject function also, of course:
Dim ZLibCompressLevels As ScriptUtilities.ZLibCompressLevels ... Set ZLibCompressLevels = CreateObject("ScriptUtils.ZLibCompressLevels") ZLibCompressLevels.SomeMethod SomeParameters ZLibCompressLevels.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 ZLibCompressLevels objector (VBA)
ScriptUtilities.ZLibCompressLevels ZLibCompressLevels = new ScriptUtilities.ZLibCompressLevelsClass();
ZLibCompressLevels.set_String("Some text value");
String SQL;
SQL = "Insert Into Table (BinaryColumn) values (0x" + ZLibCompressLevels.get_HexString() + ")"; ...
Dim ZLibCompressLevels As New ScriptUtilities.ZLibCompressLevels ZLibCompressLevels.SomeMethod(SomeParameters) ZLibCompressLevels.SomeProperty = SomeValue
DECLARE @ZLibCompressLevels INT, @OLEResult INT EXECUTE @OLEResult = sp_OACreate 'ScriptUtils.ZLibCompressLevels', @ZLibCompressLevels OUT IF @OLEResult <> 0 PRINT 'Error create component ZLibCompressLevels' --Set a property of ZLibCompressLevels. EXECUTE @OLEResult = sp_OASetProperty @ZLibCompressLevels, 'PropertyName', @SomeSQLValue IF @OLEResult <> 0 PRINT 'PropertyName set problem' --Get a value of a property of ZLibCompressLevels. EXECUTE @OLEResult = sp_OAGetProperty @ZLibCompressLevels, 'PropertyName', @SomeSQLValue OUTPUT IF @OLEResult <> 0 PRINT 'PropertyName get problem' --Call some method of ZLibCompressLevels. EXEC @OLEResult = sp_OAMethod @ZLibCompressLevels, 'MethodName', @ReturnValue OUTPUT, @parameter1, @parameter2
© 1996 - 2011 Antonin Foller, Motobit Software | About, Contacts | e-mail: info@pstruh.cz