FiveTech Software tech support forums

... agree. I also found this regarding MySQL: http://bugs.mysql.com/bug.php?id=42316 Thanks for the information. However its somewhat comforting that clientside recordsets are working well and inserts are working well. In the case of MSAcess can you take the trouble of doing this test? oRs:AddNew( ...

... a recordset. If we set connection object's CursorLocation property to adUseClient, all recordsets opened with that connection are all by default clientside only. We save one line of code while opening every recordset. Even otherwise it is always desirable to set connection object's CursorLocation ...

goosfancito wrote:hola.

estoy incursionando oracle con ado y resulta que siempre recordCount() me devuelve -1, pero esto es falso, tengo datos.

porque pasa esto?

Serverside recordsets return -1 as RecordCount.
We need to open recordsets on clientside, by using adUseClient, for browsing. Default is adUseServer.

... of a recordset can be checked either by ( oRs:Bof .and. oRs:Eof ) or by ( oRs:RecordCount == 0 ) safely. ( Note: Our discussion is confined to ClientSide recordsets only ). When recordset is empty almost all other methods ( bookmark, absoluteposition, etc ) fail. So, a codeblock like this : ...

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 PgDn me da este ...

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 error, ...

You shd open your recordset on clientside
Please reproduce your code for opening the recordset. I shall let you know what to do

... 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 by our own experiences. It is desirable ...

Still this is a clientside recordset. ROWNUM of Oracle gives numbers from 1 onwards for the rows returned. Same values as ADO absolute position. When we use ADO we dont need to use ROWNUM. (Note: Rownum helps only to know the order ...

There was a discussion above to use adOpenDynamic or adOpenKeyset for opening a recordset. But when a recordset is opened on clientside (with cursorlocation as adUseClient) the provider ignores what we speicfy as CursorType (adOpenDynamic or Keyset), and returns a recordset with cursortype ...