... you are aware that a RecordSet supports "index" property and "seek" method only when the recordset opens a physical table as Serverside Cursor using adUseServer and with adCmdTableDirect option and all other kinds of RecordSets do not support Seek method. (Mostly RecordSets ...
Secure Serverside Scripting More advanced Examples An example of a safer stored procedure: db():Execute( "DROP PROCEDURE IF EXISTS states_read" )TEXT INTO cSql CREATE PROCEDURE states_read( ...
... what locking is to be provided, which we know by querying the :LockType after opening. To my knowledge, adLockPessimistic is available only for serverside recordsets. Normally used for single records. There is no call for locking, but the moment any field is modified the lock is applied till ...
... an error. Please note that the recordset has in fact only the records within the condition although RECORDCOUNT reports all records. This is using serverside cursor.
... to be read. Still if you 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 ...
... etc. It defaults to the cusrorlocation of the connection object. If we do not set oCn:CursorLocation to adUseClient, this recordset is opened on serverside and we can not navigate the recordset backwards and not all methods and data work like clientside recordset. Back to CursorType: When we ...
The real problem is when we need to pass NULL value to a parameter of a ServerSide procedure or function. For example, this is a function stored on the MSSQL server. CREATE FUNCTION nulltest( @nVar Int )RETURNING IntASBEGINDECLARE @RetVal IntIF @nVar ...
... the Dataset is detatched .. > In ADO, we can detach, work and reconnect. In ADO.NET, that is the only way. ( Incidentally, that also means no serverside cursors. Can not browse large tables.) Microsoft will not 'support' ADO. But I think ADO will not stop working. Thats what I hope. For Oracle ...
Adolfo: Tiempos de respuesta: ServerSide = 6.265 pero no me muestra datos... ClientSide = 6.422 Páginado: 1.688 browse simple: 8.203 anidado: me dice 0.609 pero seguramente es el tiempo del segundo browse. paginado: 0.953, pero cuando presiono ...
Adolfo: Tiempos de respuesta: ServerSide = 7.297 ClientSide = 6.860 Páginado: 1.093 Fecha y hora de la prueba: 14/Jun/2008 14:45hrs desde México. Conexión de 1mb Por cierto despues del browse anidado al salir de la aplicación me tiró este ...
... I am aware I have a few other options, but I am more interested in using the multi-thread approach, if it is possible. By the way, ADS Serverside filters work like miracle even with hundreds or users simultaneously accessing huge tables with million rows.
Mr Enrico You found the reason. Most of the data and methods do not work on serverside cursors and some work only for serverside cursors but not for clientside. I have a few advices to make in general, based on theory, widely accepted good practices, confirmed ...