FiveTech Software tech support forums

... crear el OBJETO"+ oError:Description ) RETURN .F. END oRSet:CursorLocation:=adUseClient;oRSet:LockType:=adLockReadOnly;oRSet:CursorType:=adOpenForwardOnly;oRSet:ActiveConnection( oConnection ) sSQLQuery := "SELECT * FROM CONSULMARKET" TRY oRSet:Open( sSQLQuery, oConnection ) ...

... 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 want 1. adOpenKeyset : Whether we like or not this work only with ...

... 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 want 1. adOpenKeyset : Whether we like or not this work only with ...

... want to mimic the ODBC fetch() record by record and then copy into your own memory, I suggest the following way: Open serverside recordset with adOpenForwardOnly and adLockReadOnly. Keep reading the recordset as and when you need and copy to your memory ( array or whatever you were using with ...

... 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 that other users add, ...

... hacer, si se quiere solo consultar o una edición en línea. De acuerdo 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 ...

... "Provider=sqloledb;Data Source="+alltrim(instancia)+";Initial Catalog="+alltrim(bbdd)+";User Id=user;Password=***;", adOpenForwardOnly, adLockReadOnly ) nNum:=oRs:Fields("num"):Value oRs:Close() Un Saludo.

HO FATTO: #define adOpenForwardOnly 0 #define adOpenKeyset 1 #define adOpenDynamic 2 #define adOpenStatic 3 #define adLockReadOnly 1 #define adLockPessimistic 2 #define adLockOptimistic 3 #define adLockBatchOptimistic 4 local cDsn ...

... SIEMPRE devuelve -1. Dependiendo del tipo de cursor son las cosas que pudes hacer con el recordset Estos son los tipos de cursores existentes: adOpenForwardOnly 0 Es el cursor por defecto y nos permite recorrer el Recordset en forma secuencial. adOpenKeySet 1 Permite movernos hacia delante ...

... OPEN relativamente alla riga oRs:Open( "SELECT * FROM Clienti ORDER BY Cliente", "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=clienti.mdb", adOpenForwardOnly, a

Enrico //--- oRs:Open( "SELECT * FROM Contatti", "Provider=SQLOLEDB;Integrated Security=SSPI;Data Source=EMAG\Emag;Initial Catalog=Ecmp", adOpenForwardOnly, adLockOptimistic ) //--- Source is the IP or DNS name of the server cFROM := "EMAG\Emag" // not a servername .. looks like a folder No, ...

Enrico //--- oRs:Open( "SELECT * FROM Contatti", "Provider=SQLOLEDB;Integrated Security=SSPI;Data Source=EMAG\Emag;Initial Catalog=Ecmp", adOpenForwardOnly, adLockOptimistic ) //--- Source is the IP or DNS name of the server cFROM := "EMAG\Emag" // not a servername .. looks like a folder cUSER ...

... Table"), cnn:Errors and open method of recordsets is fast. My suggestion: ADORDD.CH #ifndef _ADORDD_CH #define _ADORDD_CH // Cursor Type #define adOpenForwardOnly 0 #define adOpenKeyset 1 #define adOpenDynamic 2 #define adOpenStatic 3 // Lock Types #define adLockReadOnly 1 #define adLockPessimistic ...

Enrico,

>oRs:RecordCount() is -1 when an adOpenForwardOnly or adOpenDynamic cursor type is used.

OK, so oRS:RecordCount() <= 0 when there are no records, right?

Or, oRS:RecordCount() < 1

James

oRs:RecordCount() is -1 when an adOpenForwardOnly or adOpenDynamic cursor type is used.

EMG