[Fygar]

Ok, ladies and gents, Here's the deal. I am trying to use a bookmark in a recordset and it gives me the following:

Quote

ADODB.Recordset error '800a0cb3'

Current Recordset does not support bookmarks. This may be a limitation of the provider or of the selected cursortype.

/grain/script/source.asp, line 94

And here is the code I am using to open it:

Quote

Connection() 'Fills connection crap.
RsStr = "SELECT * FROM "
RsStr = RsStr & "GP9TktSpColSrt Tscs "
RsStr = RsStr & "ORDER BY ColOrder ASC"
Rs.CursorType = adOpenStatic
'Rs.CursorLocation = adUseClient
Rs.Open RsStr, Conn,,, adCmdText

And it wigs out when it reches the bookmark write... So, I don't know what to do really.. I have tried many different locks and cursor types and such, but none worked... Could there be a database side to this that I am over looking? Thanks.

[edit] My spelling is as good as my code....

(Edited by Fygar at 11:19 am on May 31, 2002)