ADODB.Recodset problem

[Jimbob]

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

[Gary.Lowe]

Jimbob

That sounds like an SQL Error.

can you post the actual SQL Statement.

[Jimbob]

it was

thanks very much