MOTOBIT.COM - ASP upload, IIS utility ValueType usage

Article | Member of RegEdit.ValueType | Changes | Purchase | Download

1. Identities

Library name: ActiveX Registry editor 1.0
Library code: RegEdit
Library CLSID: 4DD7C9F5-3142-11D3-9DAC-204C4F4F5020
ProgID: RegEdit.ValueType
Library file name: RegEdit.OCX

2. Scripting engines without types (VB Script, JavaScript, JScript, WSH, ASP)

You can create the object using CreateObject function:

Dim ValueType
Set ValueType = CreateObject("RegEdit.ValueType")
ValueType.SomeMethod SomeParameters
ValueType.SomeProperty = SomeValue

You can also use CreateObject method method of Server object (ASP) to put the ValueType 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="ValueType"
 progid="RegEdit.ValueType">
</object>

Please use ActivexObject object in JScript/JavaScript to create ValueType object:

var ValueType;
ValueType = new ActiveXObject("RegEdit.ValueType");
ValueType.SomeMethod(SomeParameters)
ValueType.SomeProperty = SomeValue
...

3. VBA (VBA 5, VBA 6, Visual Studio, Word, Excel, MS Access, ...)

VBA 5/6: You can reference the library using menu Project -> References -> select 'ActiveX Registry editor 1.0' in the listbox (or Project -> References -> Browse -> select RegEdit.OCX file).
MSAccess, Word, Excel: Tools -> Macro -> Visual Basic Editor, then Tools -> References
Then you can write:

Dim ValueType As New RegEdit.ValueType
ValueType.SomeMethod SomeParameters
ValueType.SomeProperty = SomeValue
    ...

Dim ValueType As RegEdit.ValueType
...
Set ValueType = New RegEdit.ValueType
ValueType.SomeMethod SomeParameters
ValueType.SomeProperty = SomeValue
...

You can use CreateObject function also, of course:

Dim ValueType As RegEdit.ValueType
...
Set ValueType = CreateObject("RegEdit.ValueType")
ValueType.SomeMethod SomeParameters
ValueType.SomeProperty = SomeValue
...

4. Visual Studio .NET (ASP.Net, VB.Net, C#, J#)

You can reference the library using menu Project -> Add reference -> COM tab -> select 'ActiveX Registry editor 1.0' in the listbox -> click Select. Then you can write (C#, J#):

 //create  a new ValueType object
 RegEdit.ValueType ValueType = new RegEdit.ValueTypeClass(); 
 ValueType.set_String("Some text value"); 
 





 String SQL; 
 SQL = "Insert Into Table (BinaryColumn) values (0x" + ValueType.get_HexString() + ")"; ...

or (VBA)

Dim ValueType As New RegEdit.ValueType 
ValueType.SomeMethod(SomeParameters)
ValueType.SomeProperty = SomeValue

5. T-SQL, MS SQL stored procedures and functions

DECLARE @ValueType INT, @OLEResult INT 
EXECUTE @OLEResult = sp_OACreate 'RegEdit.ValueType', @ValueType OUT
IF @OLEResult <> 0 PRINT 'Error create component ValueType'

--Set a property of ValueType.
EXECUTE @OLEResult = sp_OASetProperty @ValueType, 'PropertyName', @SomeSQLValue
IF @OLEResult <> 0 PRINT 'PropertyName set problem'

--Get a value of a property of ValueType.
EXECUTE @OLEResult = sp_OAGetProperty @ValueType, 'PropertyName', @SomeSQLValue OUTPUT
IF @OLEResult <> 0 PRINT 'PropertyName get problem'

--Call some method of ValueType.
EXEC @OLEResult = sp_OAMethod @ValueType, 'MethodName', 
 @ReturnValue OUTPUT, @parameter1, @parameter2

5. Other programming environments

Please see documentation of your programing environment, work with COM objects (OLE objects, ActiveX objects). ValueType is a standard COM object, it can work with other environments, such are Delphi or PowerBuilder.