rs.Clone and ADODB

[Ronze55]

Hi all,

can .Clone work with ADODB? i am trying to use clone to avoid some saving/editing issues my application has


strSQL = "select a.style1, a.style2, a.style3" & _
", a.sizecode, a.sizerange1, a.sizerange2, a.sizerange3, a.sizerange4, a.sizerange5 " & _
", a.sizerange6, a.sizerange7, a.sizerange8, a.sizerange9, a.sizerange10 " & _
", DateCreated, DateLastModified " & _
" From tblRLMStyleActivator as a where a.style1 = """ & Me.Style1.Value & """;"

rs.Open strSQL, cn, , adLockPessimistic

Set rsClone = rs.Clone
rs.Close

run-time error '3251' is given.

thanks!
Ronze

 

[MichaelRed]

.Clone is a feature (functio?) of Forms (verm 2.0?), thus not quite readily available to (or through) declared recordsets.






MichaelRed

 

[PHV]

The Clone method is perfectly legal with ADODB recordset supporting bookmarks.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244