Thread: [ psqlodbc-Bugs-1000413 ] Optimistic lock cannot be used with updateable cursors
Bugs item #1000413, was opened at 2005-11-07 11:33 You can respond by visiting: http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000413&group_id=1000125 Category: None Group: None >Status: Closed Resolution: None Priority: 3 Submitted By: Dave Page (dpage) Assigned to: Nobody (None) Summary: Optimistic lock cannot be used with updateable cursors Initial Comment: When using VB/ADO, adLockOptimistic or adLockBatchOptimistic when used with adOpenStatic or adOpenKeyset will cause a crashif UpdateableCursors are enabled. Sample VB code: Dim cn As New Connection Dim rs As New Recordset cn.Open "DSN=foo;UID=postgres;UpdatableCursors=1" rsSQL.Open "SELECT * FROM pg_class", cn, adOpenStatic, adLockOptimistic ---------------------------------------------------------------------- >Comment By: Dave Page (dpage) Date: 2006-04-28 08:23 Message: PRevious codebase - closing. ---------------------------------------------------------------------- You can respond by visiting: http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000413&group_id=1000125