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