VB6 RDO ODBC stored procedures
VB6 RDO ODBC stored procedures
(OP)
I am using an RDO interface with an ODBC connection to Universe and am trying to execute stored procedures. I can get the program to work fine and execute the stored procedure when I don't pass any parameters, but as soon as I start to try to pass parameters, I get the following problem.
I have 2 option buttons in each of two frames and depending on the settings each frame sets a variable which has been defined as a string set to null earlier in the program. I then use the standard syntax of
rdoQuery_name(parameter number) = variable
to define the parameter value
This fails consistently with the error message:
40041 Object collection: couldn't find object indicated by text.
Can anybody tell me what this error message is actually indicating as the rdoQuery definition statement earlier in the program runs okay, the parameters are defined in the standard way and the variable is present.
I have 2 option buttons in each of two frames and depending on the settings each frame sets a variable which has been defined as a string set to null earlier in the program. I then use the standard syntax of
rdoQuery_name(parameter number) = variable
to define the parameter value
This fails consistently with the error message:
40041 Object collection: couldn't find object indicated by text.
Can anybody tell me what this error message is actually indicating as the rdoQuery definition statement earlier in the program runs okay, the parameters are defined in the standard way and the variable is present.