FiveTech Software tech support forums

Mr EMG

I agree. I also found this regarding MySQL:

m

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( { "test" }, { 12.50 } )
and ...

... 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 to ...

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

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, por si te sirve de algo

Destructors ...

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

... 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 in which we read oringally after we sort or filter rows in ADO on ...

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 as ...