FiveTech Software tech support forums

... " +; "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

... := 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 orsPed:ActiveConnection( oApp:oCon ...

... := 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() CATCH oError MsgStop( "No ...

... := 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 orsPed:ActiveConnection( oApp:oCon ...

... := 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 orsPed:ActiveConnection( oApp:oCon ...

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

... ) 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 := "DIRECCION" && ...

... : 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 is the only choice left to us. Even if you try to use adOpenKeySet or ...

... : 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 is the only choice left to us. Even if you try to use adOpenKeySet or ...

... 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 := cConnStr oRs:Source := cSql oRs:Open() ...

... especially using the opendkeyset cursor type If you are using the FW_Ado wrappers ( adofuncs.prg ) it uses the 2 parameter ( if not specified ) or adOpenDynamic for the Cursor Type .. there are pros and cons on Open and Dynamic keysets and they are mentioned here : https://docs.microsoft.com/en-us/sql/ado/guide/data/keyset-cursors ...

... default one. ADOPREOPENTHRESHOLD Faster counting records. Doesn't cache any tables with WHERE clause. All ADO cursors changed in the code from adopendynamic to adopenstatic, although it always started as adopenstatic. New features: New option PORT in SET ADO DEFAULT DATABASE ... ADO_ORDINFO ...

... oRs := USRRDD_AREADATA( Select() )[1] DBG oRs:CursorType , oRs:CursorLocation , oRs:LockType 3 3 3 In AdoRdd i can see oRecordSet:Open(......., , adOpenDynamic , .... ) Cursortype ist'n 2 as expected but 3 (adOpenStatic) 2) Ors:Delete() gives an error without a proper message 3) Ors:Fileds("First"):Value ...

You can use: CursorLocation := adUseServer CursorType := adOpenDynamic Pros: Selects without where clause much faster because you dont load immediately all records You'll see new adds deletes changes by others. You will always have the last info version. ...

... 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 using Browse() you need to ...