FiveTech Software tech support forums

... HEHEHEHE try oRs := CreateObject("ADODB.RecordSet") oRs:CursorLocation := adUseClient oRs:LockType := adLockOptimistic oRs:CursorType := adOpenDynamic oRs:ActiveConnection := "Provider=VFPOLEDB.1;Data Source=c:\bazevani\loc.tmp;Mode=Read;Extended Properties=DBASE IV" catch If ...

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

Try using adOpenDynamic:

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

EMG

No effect, the same problem .

Thanks.

Lucas,

lucasdebeltran wrote:Just click on Añadir, and you will see that oRs is not updated:

Try using adOpenDynamic:

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

EMG

... data work like clientside recordset. Back to CursorType: When we look around we see many postings setting custor type either to adOpenKeySet or adOpenDynamic but never adOpenForwardOnly or adOpenStatic. adOpenKeySet ( 1 ) keyset cursor. Like a dynamic cursor, except that you can't see records ...

... oCone ) Local Data1 Local oError Data1:=tOleAuto():New("ADODB.RecordSet") Data1:CursorLocation := adUseClient Data1:CursorType := adOpenDynamic Data1:LockType := adLockOptimistic Data1:ActiveConnection := oCone Data1:Source := "CREATE TABLE ARTICULOS(" + ; " Registro ...

... desde ya: cQry = "select * from autores" oRS:cursorLocation = 3 //adUseClient oRS:lockType = 3 //adLockOptimistic oRS:cursorType = 2 //adOpenDynamic oRS:source = cQry oRS:activeConnection = oServer TRY oRS:open() CATCH oError ? "Build RecordSet Failed!!! "+xtabla ShowError( ...

... 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. Whatever we want ADO always opens the recordset with CursorType static only.

... exemple try oRs := CreateObject("ADODB.RecordSet") oRs:CursorLocation := adUseClient oRs:LockType := adLockOptimistic oRs:CursorType := adOpenDynamic oRs:ActiveConnection := "Provider=VFPOLEDB.1;Data Source="+Curdrive()+":\"+Curdir()+";Mode=Read;Extended Properties=DBASE ...

... example, try oRs := CreateObject("ADODB.RecordSet") oRs:CursorLocation := adUseClient oRs:LockType := adLockOptimistic oRs:CursorType := adOpenDynamic oRs:ActiveConnection := "Provider=VFPOLEDB.1;Data Source="+Curdrive()+":\"+Curdir()+";Mode=Read;Extended Properties=DBASE ...

... Local Data1 Local oError Data1:=tOleAuto():New("ADODB.RecordSet") Data1:CursorLocation := adUseClient Data1:CursorType := adOpenDynamic Data1:LockType := adLockOptimistic Data1:ActiveConnection := oCone Data1:Source := "CREATE TABLE BANCOS ( Registro COUNTER, Numero ...

... por la definicion del Recordset, ahora lo tengo de la siguiente manera: oRs := TOleAuto():New( "ADODB.Recordset" ) oRs:CursorType := adOpenDynamic oRs:CursorLocation := adUseClient oRs:LockType := adLockOptimistic oRs:ActiveConnection(oConnection) oRs:Source := "EXEC sp_Menu ...

... inicio mais depois é uma maravilha. Porem, tenho um problema: Estou usando esta configuração: oRs:LockType := adLockOptimistic oRs:CursorType := adOpenDynamic oRs:CursorLocation := adUseClient Com esta configuração não estou conseguindo visualizar as alterações feitas por outros usuários. Tenho ...

... use use ADO to access MySql DB. I try modify a row using :   oRecordSet := TOleAuto():New( "ADODB.Recordset" ) oRecordSet:CursorType := adOpenDynamic oRecordSet:CursorLocation := adUseClient oRecordSet:LockType := adLockOptimistic TRY oRecordSet:Open( "SELECT filename FROM testi ...

... 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 TRY oRs:Open() ...