Jimbob
Jul 14th, 2000, 03:52 AM
check this one out...
I'm opening a recordset using a data class when i call the sub to open the recodset, i pass the sql and the type of set, eg: -
DS1.SetRs "SELECT....", DynamicSet (enumerated type)
this then calls the sub which closes tyhe set if it's already open, and then opens it based on my criteria, like this: -
Rs.Open SQL, Cnn, SetType, adLockOptimistic
where SQL is the sql statement, Cnn is the active connection, SetType is the enumerated type passed to the sub and lockoptimistic is the type of locking i'm using.
the procedure i'm caling this from uses it once with no problems. it then calls it again and gets the error
'No value given for one or more required parameters'
the only thing is, i'm supplying all the arguments that are needed.
if it's important, i'm using the Microsoft.Jet.OLEDB.4.0 provider
I'm opening a recordset using a data class when i call the sub to open the recodset, i pass the sql and the type of set, eg: -
DS1.SetRs "SELECT....", DynamicSet (enumerated type)
this then calls the sub which closes tyhe set if it's already open, and then opens it based on my criteria, like this: -
Rs.Open SQL, Cnn, SetType, adLockOptimistic
where SQL is the sql statement, Cnn is the active connection, SetType is the enumerated type passed to the sub and lockoptimistic is the type of locking i'm using.
the procedure i'm caling this from uses it once with no problems. it then calls it again and gets the error
'No value given for one or more required parameters'
the only thing is, i'm supplying all the arguments that are needed.
if it's important, i'm using the Microsoft.Jet.OLEDB.4.0 provider