D3 Objects On VB

D3 Objects On VB

Post by Tony Li » Sun, 25 Oct 1998 04:00:00



Hello

There're 3 problems when I'm trying to develop an application on VB5 where
I found that some of the object I fail to code.  Below are the sample
coding I code and please verify whether any error or not.  For your more
information,  I develop with VB5, using d3vbodbc.dll (version of ODBC C8)
on windows 95(for Windows 95 machine) and WinNT (for Windows NT
workstation) and the problem are same.

1. Rule Module
Below are the sample coding I used that faced the problem of the unchanged
of info.

D3(Flash compiled):
001 Subroutine CC(val1)
002 VAL1 = VAL1:" HELLO"
003 RETURN

VB5(using d3vbodbc.dll)
Dim Conn As clsD3Connection
Dim Env As clsD3Environment
Dim Rule As clsD3RuleModule
Dim sRet As Variant
Set Env = New clsD3Environment
Set Conn = Env.brOpenConnection("ODBC", "D3REDU")
Set Rule = Conn.brOpenRuleModule("REDU,CCC, CC")
sRet = "AAAA"
Call Rule.brcall(sRet)
MsgBox sRet

-By right the output should be (AAAAHello) but it show me (AAAA) only and
no updating in the file "TEST" on record '001'.   We do mail to Mr. Mark
Brown and receive his reply but how can we compile in File manager because
this is the Unix Version and we really not understand the term
Basic-Prot-on (Basic Protection On).
--------------------------------------------------

2. Select List
The problem exist when the execution line go to
dim oSelList as clsD3SelectList
set oSelList = Conn.brOpenSelectList("Select MEMBER")

and the error message will be "2147220223".  When I key the command "SELECT
MEMBER" in TCL level, the output prompt in TCL will be "134 items selected
out of 134 items".  Am I using the wrong coding or Unix cannot support the
object above. Can you email some of the sample program using d3vbodbc.dll

--------------------------------------------------

3. Active X can't create object
This problem only exist on Windows95 (ODBC C8) where it goes to the line

Dim Env as Clsd3Environment    
Set Env = new ClsD3Environment 'here

or

Dim ENV as object
Set ENV = createobject(olesrv32.clsd3Environment)

There's no problem for the version of WinNT.
--------------------------------------------------

Can you please send me some sample program that can solve my problem above
and the proper procedure to do so.

Thanks and Have A Nice Day.....

JT Chuah
(Data System Integrators Sdn Bhd)

 
 
 

1. D3 Objects On VB

Hello

There're 3 problems when I'm trying to develop an application on VB5 where
I found that some of the object I fail to code.  Below are the sample
coding I code and please verify whether any error or not.  For your more
information,  I develop with VB5, using d3vbodbc.dll (version of ODBC C8)
on windows 95(for Windows 95 machine) and WinNT (for Windows NT
workstation) and the problem are same.

1. Rule Module
Below are the sample coding I used that faced the problem of the unchanged
of info.

D3(Flash compiled):
001 Subroutine CC(val1)
002 VAL1 = VAL1:" HELLO"
003 RETURN

VB5(using d3vbodbc.dll)
Dim Conn As clsD3Connection
Dim Env As clsD3Environment
Dim Rule As clsD3RuleModule
Dim sRet As Variant
Set Env = New clsD3Environment
Set Conn = Env.brOpenConnection("ODBC", "D3REDU")
Set Rule = Conn.brOpenRuleModule("REDU,CCC, CC")
sRet = "AAAA"
Call Rule.brcall(sRet)
MsgBox sRet

-By right the output should be (AAAAHello) but it show me (AAAA) only and
no updating in the file "TEST" on record '001'.   We do mail to Mr. Mark
Brown and receive his reply but how can we compile in File manager because
this is the Unix Version and we really not understand the term
Basic-Prot-on (Basic Protection On).
--------------------------------------------------

2. Select List
The problem exist when the execution line go to
dim oSelList as clsD3SelectList
set oSelList = Conn.brOpenSelectList("Select MEMBER")

and the error message will be "2147220223".  When I key the command "SELECT
MEMBER" in TCL level, the output prompt in TCL will be "134 items selected
out of 134 items".  Am I using the wrong coding or Unix cannot support the
object above. Can you email some of the sample program using d3vbodbc.dll

--------------------------------------------------

3. Active X can't create object
This problem only exist on Windows95 (ODBC C8) where it goes to the line

Dim Env as Clsd3Environment    
Set Env = new ClsD3Environment 'here

or

Dim ENV as object
Set ENV = createobject(olesrv32.clsd3Environment)

There's no problem for the version of WinNT.
--------------------------------------------------

Can you please send me some sample program that can solve my problem above
and the proper procedure to do so.

Thanks and Have A Nice Day.....

JT Chuah
(Data System Integrators Sdn Bhd)

2. what to use - sql or filters

3. D3 - VB object library Rants!

4. SQLXML Bulk Load

5. d3 vb object library

6. SQL7 Row-level locking considered

7. Help - Problems with D3 VB Object Library

8. EMCion <Enterprise Management Center Ion>

9. D3/NT VB Objects

10. VB, D3/NT, D3 LINUX

11. D3 7.0 to D3 7.1 Incompatibility problem with c functions on D3/Linux

12. Dire&#1089;&#1077;rtly sending E-mail From D3 (D3/NT ior D3/Linux)

13. Error Assigning Task object to Custom Task object while calling DTS APIs in VB.NET