Current recordset does not support updating locktype
Lock Type = ad Lock Optimistic Set rs Insurance = m Command. I also tried getting rid of the uniqueidentifier field and I had the same problem. Would ahaving 3 fields as the primary key affect this problem. If you want a client side cursor to be updatable, the locktype must be adlockbatchoptimistic, and you have to use the updatebatch method.
Michael Lee Hi Roy, I just found a KB from Microsoft (KB188857) that talks to that some. Changing cursortype to keyset would therefore have no effect.
Open sqlstr, ado Con, 3, 3" line and the "rssoftwarelicenses .
Cursor Type = 3" line I guess that file is unneccessary. Helps make sure that your firewall rules are working as intended.
I try to rewrite the code to below ' CC_Order Action=Request.
If I check the Lock Type right after executing a addnew to the recordset the property changes to ad Lock Read Only. There is one other thing that I thought it could be. Here is an example of the code thats loading the recordset: If rs Insurance.
I have one field in the table set to uniqueidentifier and I have newid() in the Default value field in Enterprise manager.
Its either that or open the recordset and then use the filter property to filter the data. All this is causing me more problem because I was looking to bind the recordset to a TDBGrid (Component One Grid) and if I only have a read only recordset, this does me no good at all. The cursortype is always static if the cursorlocation is client, and the latter overrides the former.
Michael Lee Hi Roy, After taing a look at the KB that I found. If your stored proc is a select query, then is the right method, if it's an action query, then command.execute.
I added the above Cursor Location to see if problem went away, but it didn't. Michael Lee I have changed the above slightly but I'm getting the same results. Bob Just remove the space between faq and 222 - like this FAQ222-3670 ________________________________________________________________If you want to get the best response to a question, please check out FAQ222-2244 first'If we're supposed to work in Hex, why have we only got A fingers?