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