FiveTech Software tech support forums

... Conceptos.CON_RUB " +; "AND " +; "WRK_CON = Conceptos.CON_NUM " +; "ORDER BY " +; "WRK_ROW" ,cTabNam ,adLockOptimistic,adOpenDynamic,0) <============ [code] It seems silly but it was stupid. I apologize, again Best regards

... ShowError(oError) orsPed := NIL lret:=.f. CLOSE_DBF(ODTEMP) RETURN(lret) END orsPed:CursorLocation := adUseClient orsPed:LockType := adLockOptimistic orsPed:CursorType := adOpenDynamic orsped:source:="SELECT * FROM ERP6_base" // ENVIAMOS QUERY DE PRUEBA PARA COMPROBAR CONEXIÓN ...

... ShowError(oError) orsPed := NIL lret:=.f. CLOSE_DBF(ODTEMP) RETURN(lret) END orsPed:CursorLocation := adUseClient orsPed:LockType := adLockOptimistic orsPed:CursorType := adOpenDynamic orsPed:Source :="select * from BasedeDatos" orsPed:ActiveConnection( oApp:oCon ) TRY orsPed:Open() ...

... ShowError(oError) orsPed := NIL lret:=.f. CLOSE_DBF(ODTEMP) RETURN(lret) END orsPed:CursorLocation := adUseClient orsPed:LockType := adLockOptimistic orsPed:CursorType := adOpenDynamic orsped:source:="SELECT * FROM ERP6_base" // ENVIAMOS QUERY DE PRUEBA PARA COMPROBAR CONEXIÓN ...

... ShowError(oError) orsPed := NIL lret:=.f. CLOSE_DBF(ODTEMP) RETURN(lret) END orsPed:CursorLocation := adUseClient orsPed:LockType := adLockOptimistic orsPed:CursorType := adOpenDynamic orsped:source:="SELECT * FROM ERP6_base" // ENVIAMOS QUERY DE PRUEBA PARA COMPROBAR CONEXIÓN ...

Hola Carlos el recordset se abre en modo adUseClient (modo 3) como puedes ver en el modulo, y adLockOptimistic, el problema surge cuando despues de recorrer y grabar el primer registro del recordset, ya no se puede mover hacia ningun lado, da errores de movefirst, recordcout, ...

... "ADODB.RecordSet" ) WITH OBJECT oRsDir :ActiveConnection := oApp:oCon :Source := cSql :CursorLocation := adUseClient :LockType := adLockOptimistic :CursorType := adOpenDynamic TRY :Open() CATCH FW_ShowAdoError( oApp:oCon ) END END oRsDir:Properties("Unique Table"):Value ...

... )  If you change it as oRs := FW_OpenRecordSet( oDg, "Marcas" )//ORoRs := FW_OpenRecordSet( oDg, "Marcas", adLockOptimistic )// default lockmode is adLockOptimistic  everything works correctly as expected. First please try it before getting into the next ...

It is true that ADO reads the data from the server and holds it in the client's memory. We normally open recordsets using adLockOptimistic . All calls to the methods Update(), Delete() and AddNew( aCols, aVals ) make the changes to the underlying database immediately and are visible ...

... : We need to lock each record for modification. Rarely anybody uses it. 5. adLockBatchOptimistic: Useful. But for more advanced users. 4. adLockOptimistic: This is the only choice we have CursorType: 0. adOpenForwardOnly : Works only with adUseServer and in anycase this is not what we ...

... : We need to lock each record for modification. Rarely anybody uses it. 5. adLockBatchOptimistic: Useful. But for more advanced users. 4. adLockOptimistic: This is the only choice we have CursorType: 0. adOpenForwardOnly : Works only with adUseServer and in anycase this is not what we ...

... 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 := adUseClient oRs:LockType := adLockOptimistic Endif oRs:ActiveConnection ...

... may result in wrong results because we lose the benefit of snap-shot query benefits. What we mostly use is RecordSet with adUseClient with either adLockOptimistic or adLockBatchOptimistic. All this is static information as at the time when we executed the query. The recordset does not get updated ...

... mandatory at ADO_OPEN() : oRecordSet:CursorLocation := adUseClient //its slower but has avntages such always bookmaks oRecordSet:LockType := adLockOptimistic

... mandatory at ADO_OPEN() : oRecordSet:CursorLocation := adUseClient //its slower but has avntages such always bookmaks oRecordSet:LockType := adLockOptimistic Thank you.