FiveTech Software tech support forums

... speed up the query? Another important information to all of u: Whatever value we specify for oRs:CursorType, ADO invariably opens the recordset as adOpenStatic only for CursorLocation adUseClient. There is not point in assigning a value like adOpenKeySet or adOpenDynamic

... 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 adOpenDynamc the ADO system will open the recordset with adUseStatic ...

... 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 adOpenDynamc the ADO system will open the recordset with adUseStatic ...

... de conteo más rápidos. No almacena en caché ninguna tabla con la cláusula WHERE. Todos los cursores ADO cambiaron en el código de adoptendynamic a adopenstatic, aunque siempre Comenzó como adoptenstatic. Nuevas características: Nueva opción PORT en SET ADO DEFAULT DATABASE ... ADO_ORDINFO ordwildseek ...

... 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 ordwildseek implemented ...

... // 3,3,3 !!!!! // Is it normal that cursortype is changed in 3 ? Always and at all times, a client side record-set is opened with cursor-type adOpenStatic only, whatever cursortype we specify while opening the recordset. In other words, it is just useless and meaningless for us to specify ...

... , 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 := "Test" , gives : (DOS Error ...

... ) oCommand := TOLEAUTO():New("adodb.command") Abriba:CacheSize := 50 Abriba:CursorLocation := adUseClient Abriba:CursorType := adOpenStatic Abriba:LockType := adLockPessimistic alert(cSelect +" "+ cString) TRY Abriba:Open( cSelect , cString ,1, 3 ) CATCH oError MsgStop(oError:Operation+CRLF+oError:Description,"No ...

NageswaraRao,

nageswaragunupudi wrote:Note: If the CursorLocation property is set to adUseClient, the only valid setting for the CursorType property is adOpenStatic.

You missed "Remote Data Service Usage".

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 that we specify ...

... TOleAuto():New( "ADODB.Recordset" ) oRecordSet[nRecordSet]:CursorLocation := adUseClient oRecordSet[nRecordSet]:CursorType := adOpenStatic oRecordSet[nRecordSet]:LockType := adLockPessimistic oRecordSet[nRecordSet]:Open( "Select "+ cSelect +" from " + cTabla ...

... Las incorporaciones, cambios y eliminaciones que hacen otros usuarios permanecen visibles, y se admiten todo tipo de movimientos entre registros adOpenStatic, Cursor estático. Una copia estática de un conjunto de registros que se puede usar para buscar datos o generar informes. Las incorporaciones, ...

... done via ADO. This would be the method that I try to use: method TXTtoSQL() class TFormPrincipal LOCAL o LOCAL oRs LOCAL a LOCAL adUseClient LOCAL adOpenStatic //Open conexion. WITH OBJECT o := TAdoDatasource():Create() :cConnect := "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security ...

... hago vía ADO. Este sería el método que intento utilizar: method TXTtoSQL() class TFormPrincipal LOCAL o LOCAL oRs LOCAL a LOCAL adUseClient LOCAL adOpenStatic //Abro la conexión. WITH OBJECT o := TAdoDatasource():Create() :cConnect := "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist ...

... :Connect() END WITH OBJECT oRs := TSqlQuery():Create( o ) :oDatasource := o :ncursorlocation := adUseClient :ncursortype := adOpenStatic :cSelect := "Select * FROM clientes" END oRs:Open() IF !oRs:lOpen MsgInfo("ERRRO") ENDIF ::cFicheroR := Memoread("Info.txt") ...