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