PDA

Click to See Complete Forum and Search --> : RDO get slow


Tonatiuh
Aug 30th, 1999, 02:14 AM
I'm opening a FoxPro database using the RDO object in VB. I have a 'SetDBToGUI' procedure to sweeps all records in the resultset from first to last to populate a control. But I have a very strange situation:

a) When I call 'SetDBToGUI' procedure from LOAD event of the form, it works "fast" (Normal, in fact). It takes about 0.10 second.

b) When I call the same 'SetDBToGUI' procedure from another location of the code (another procedure, a control event, etc) it works very slowly. It takes more than one second!

What´s happening? Do you think it's a language problem? or Do you think it's an ODBC driver problem?

Changing the ODBC driver, gives me the same thing.

Any idea will be very appreciated.

Thanks!

Ulises


[This message has been edited by Tonatiuh (edited 09-07-1999).]