I've developed an app on 2000pro using ADO to connect to a 7.0 SQLServer.
I have a bidirectional link between a form and an object -- so when
myobj = new MyObj
MyObj's initializer does:
Private frm as MyForm
...
Class_Initialize()
myform = new MyForm
myform.myobj = Me
Me.frm = myform
Ok, now when a Win98 box uses something on MyForm that calls MyObj, it dies under a run-time error. Here's an example of what's going on:
MyForm:
cmdButton_Click()
Me.myobj.runCmd Me.txtBox1, Me.txtBox2
MyObj:
runCMD(vntOne as Variant, vntTwo as Variant)
' objDataAccess is just the ado wrapper
objDataAccess.execute "usp_SomeSP " & vntOne & ", " & vntTwo
This example shows the two possibilities I've been able to come up with during debugging: (a). it's the bidirectional linking itself that's breaking down; or (b). its something with the way I'm accepting the data as a variant and then sending it to the sqlserver.
The weird part is that it works fine in my development box under Win2000pro.
Has anyone ever experienced this, or know what it could be?
__________________________________
"This is our Stretchy-Relativistic-Ruler -- it allows us to read a moving measurement from a fixed point accurately during space contraction... How fast can you run down the hall?" -- Overheard Physics Professor at the University of Oregon
I have a bidirectional link between a form and an object -- so when
myobj = new MyObj
MyObj's initializer does:
Private frm as MyForm
...
Class_Initialize()
myform = new MyForm
myform.myobj = Me
Me.frm = myform
Ok, now when a Win98 box uses something on MyForm that calls MyObj, it dies under a run-time error. Here's an example of what's going on:
MyForm:
cmdButton_Click()
Me.myobj.runCmd Me.txtBox1, Me.txtBox2
MyObj:
runCMD(vntOne as Variant, vntTwo as Variant)
' objDataAccess is just the ado wrapper
objDataAccess.execute "usp_SomeSP " & vntOne & ", " & vntTwo
This example shows the two possibilities I've been able to come up with during debugging: (a). it's the bidirectional linking itself that's breaking down; or (b). its something with the way I'm accepting the data as a variant and then sending it to the sqlserver.
The weird part is that it works fine in my development box under Win2000pro.
Has anyone ever experienced this, or know what it could be?
__________________________________
"This is our Stretchy-Relativistic-Ruler -- it allows us to read a moving measurement from a fixed point accurately during space contraction... How fast can you run down the hall?" -- Overheard Physics Professor at the University of Oregon
