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