NT to XP

[EyeTalion]

I changed my OS from NT to XP now my app gives me an error...

"Object Collection: Couldn't find item indicated by text"

any suggestions?


thanks,
eye

[BuggyProgrammer]

yes. show us your code

[IROY55]

No, until you post some of your code.

[EyeTalion]

please, no laughing at my code...I use ADO now! it's bombing out when it calls my SP...


On Error GoTo jobcosterr
Dim mperm As String
totot = 0
totreg = 0
mperm = "N"
If permanent Then mperm = "Y"

Set rdoqor = New rdoQuery
rdoqor.SQL = "{Call LAM.sp_lam_build_work_totals(?,?,?,?,?,?,?)}"
Set rdoqor.ActiveConnection = grdoOracle
With rdoqor
.rdoParameters(0).Type = rdTypeVARCHAR
.rdoParameters(0).Value = gwork
.rdoParameters(1).Type = rdTypeDATE
.rdoParameters(1).Value = mdate
.rdoParameters(2).Type = rdTypeINTEGER
.rdoParameters(2).Value = memployeeid
.rdoParameters(3).Type = rdTypeINTEGER
.rdoParameters(3).Value = payrulehour
.rdoParameters(4).Type = rdTypeVARCHAR
.rdoParameters(4).Value = LogonInfo.Mx_Logon
.rdoParameters(5).Type = rdTypeVARCHAR
.rdoParameters(5).Value = mperm
.rdoParameters(6).Type = rdTypeVARCHAR
.rdoParameters(6).Value = gchosen_employee
End With
rdoqor.Execute

[IROY55]

I am a bit confused: you said you use ADO now but you posted RDO stuff???!!!

[EyeTalion]

on my new apps I use ADO...

[kleinma]

Originally posted by IROY55
I am a bit confused: you said you use ADO now but you posted RDO stuff???!!!

perhaps this is code he wrote a while ago.... and he is saying now he uses ado.. but then he used rdo.. if that is correct then maybe the app should be upgraded to use ado?

[IROY55]

Oh, I understand that of course, what I don't is what exactly the problem he's encountering? What line is a trouble one, etc... They almost never debug their products - just asking something like "What do you thing...?".

[techgnome]

This isn't valid ADO "{Call LAM.sp_lam_build_work_totals(?,?,?,?,?,?,?)}"

The whole code will need to be modified to use ADO properly.

[EyeTalion]

I wished I never mentioned ADO. What I meant was that on different applications I'm using ADO, but on this app I am using RDO. I am getting the error when I call my SP. The app works fine on other OS (98, NT), but is giving me an error when it is ran on XP.


On Error GoTo jobcosterr
Dim mperm As String
totot = 0
totreg = 0
mperm = "N"
If permanent Then mperm = "Y"

Set rdoqor = New rdoQuery
rdoqor.SQL = "{Call LAM.sp_lam_build_work_totals(?,?,?,?,?,?,?)}"
Set rdoqor.ActiveConnection = grdoOracle
With rdoqor
.rdoParameters(0).Type = rdTypeVARCHAR
.rdoParameters(0).Value = gwork
.rdoParameters(1).Type = rdTypeDATE
.rdoParameters(1).Value = mdate
.rdoParameters(2).Type = rdTypeINTEGER
.rdoParameters(2).Value = memployeeid
.rdoParameters(3).Type = rdTypeINTEGER
.rdoParameters(3).Value = payrulehour
.rdoParameters(4).Type = rdTypeVARCHAR
.rdoParameters(4).Value = LogonInfo.Mx_Logon
.rdoParameters(5).Type = rdTypeVARCHAR
.rdoParameters(5).Value = mperm
.rdoParameters(6).Type = rdTypeVARCHAR
.rdoParameters(6).Value = gchosen_employee
End With
rdoqor.Execute

It bombs out on the rdoqor.execute line...

any suggestions?

thanks,
eye