FiveTech Software tech support forums

... ADO invariably opens the recordset as adOpenStatic only for CursorLocation adUseClient. There is not point in assigning a value like adOpenKeySet or adOpenDynamic

... This is the only choice we have CursorType: 0. adOpenForwardOnly : Works only with adUseServer and in anycase this is not what we want 1. adOpenKeyset : Whether we like or not this work only with adUseServer 2. adOpenDynamic : This also does not work with adUseClient 3. adOpenStatic: This ...

... This is the only choice we have CursorType: 0. adOpenForwardOnly : Works only with adUseServer and in anycase this is not what we want 1. adOpenKeyset : Whether we like or not this work only with adUseServer 2. adOpenDynamic : This also does not work with adUseClient 3. adOpenStatic: This ...

... Local e := nil Default lNew := FALSE Try If lNew // New way... // Suggested by Rick Lipkin from the FW Tech Board. oRs:CursorType := 1 // adOpenKeyset oRs:CursorLocation := 3 // adUseClient oRs:LockType := 3 // adLockOptimistic Else oRs:CursorType := adOpenDynamic oRs:CursorLocation := ...

... found out that the problem is with cursorlocation because with ACCESS aduseclient you can not :update() so I've change it to adUseServer but with adOpenKeyset because with adOpenDynamic ACCESS also does not work correctly. In my tests with MYSql everything its ok. Also since locks are enforced ...

Lucas,

lucasdebeltran wrote:

Try using adOpenDynamic:

http://www.w3schools.com/ado/met_rs_open.asp

EMG

No effect, the same problem .

Thanks.

Did you read the article? This is expected behavior for adOpenKeySet:

you can't see records that other users add

EMG

What is the most desirable cursor type to use while opening a Recordset in ADO? adOpenKeySet or adOpenDynaic or adOpenStatic? We almost always open RecordSet on client side, using CursorLocation as adUseClient (3) Brief note on CursorLocation: It is not necessary ...

... issue. If the Update fails, ReQuery() the recordset, inform the user about the concurrency issue and offer to re-edit. Note on: oRS :CursorType := adOpenKeyset When we open a recordset on the client side (this is what we should do) there is no use of assigning any values like adOpenKeyset or adOpenDynamic. ...

... oRS :CursorLocation := adUseClient oRS :LockType := adLockOptimistic <------------ TIPO DE BLOQUEO oRS :CursorType := adOpenKeyset oRs:ActiveConnection(oCon) oRs:Source := "SELECT * FROM clientes ORDER BY NomCuenta "

... oRS :CursorLocation := adUseClient oRS :LockType := adLockOptimistic <------------ TIPO DE BLOQUEO oRS :CursorType := adOpenKeyset oRs:ActiveConnection(oCon) oRs:Source := "SELECT * FROM clientes ORDER BY NomCuenta "

... en casi todos lados encuentro este codigo WITH OBJECT oRs :CursorLocation := 3 //AdUseClient :LockType := 3 //adLockOptimist :CursorType := 2 //adOpenKeyset :Source := cSql :ActiveConnection( oCn ) END pero a mi no me funciona asi, me da error de argumentos en :activeconnection, pero si lo cambio ...

... o ID da conexão atualmente ativa PRIVATE oRs := TOLEAUTO():New("adodb.recordset") oRs:LockType := adLockOptimistic oRs:CursorType := adOpenKeyset oRs:CursorLocation := adUseClient oRs:ActiveConnection(nID) oRs:Source := "Select * from catalogo" Isso é possível ? Se não, ...

... PRIVATE oRs := TOLEAUTO():New("adodb.recordset") oRs:LockType := adLockOptimistic oRs:CursorType := adOpenKeyset oRs:CursorLocation := adUseClient oRs:ActiveConnection(oCon) oRs:Source := "Select * from catalogo" oRs:Open() Public oDlg, Public ...

... .f. END //Configuramos el recordset que manejara la tabla oRs:CursorLocation := adUseClient oRs:LockType := adLockOptimistic oRs:CursorType := adOpenKeyset//adOpenDynamic oRs:Source := "SELECT * FROM imovweb; " oRs:ActiveConnection(oCn) //Ahora si cargamos los datos en el recordset ...

... al tipo será más lento o más velóz. ******************* Tipo de cursor: adOpenForwardOnly,sólo permite desplazarse hacia adelante en los registros AdOpenKeyset, Igual que un cursor dinámico, excepto que no se pueden ver los registros que agregan otros usuarios adOpenDynamic, Las incorporaciones, ...