Jaime,
Yes the method will work using the Item Code as long as you have an index
based on the Item Code as the VFP "Rushmore Technology" will activate making
a fast efficient query possible.
If you don’t have an index on the Item code then the process will still work
but take much much longer and be inefficient.
As per all the records being retrieved the answer is NO, the whole file
isn't brought over but sections of the index (if not all) are - which would
be much smaller in size. The selection of the required records is done
locally using the index and just the required records are transmitted to the
local result cursor/grid etc. in one action
Effectively there is no need to close/reopen the file to bring back sections
(see above).
When you do the query the entire result set will be retrieved and you are
better off just displaying the first 10 records in a grid and allowing the
user to PAGE DOWN 10 at a time.
Ed's comment relates to the fact that the whole query can be done in one
shot without going back for groups of 10 records thus making the next 10
records available immediately as they have been pre-selected/loaded onto the
local machine.
Just as a matter of interest why do you only want to display 10 records at a
time? Some details on volumes of records would help here maybe.
Dave Crozier
-----Original Message-----
From: profox-bounces AT leafe DO.T com [mailto:profox-bounces@leafe.com] On Behalf
Of jaime zorrillo
Sent: 31 May 2006 18:33
To: profox
Subject: paginacion in VFP
Thanks to all for your answers.
If instead of using the primary key I want to use the
items codes, which are alphanumeric, will the
methodology suggested (select top n where code >
lastcode) work ?
Also, Mr.Leafe said that it is pointless to do it if
the database is VFP. He speaks about the table being
used anyways. I do not understand very well what he
means.
If I open the database (in VFP) make my select and
then close the table and the database, does the
network bring all the table anyways?
Jaime
__________________________________________________
Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam ˇgratis!
ˇAbrí tu cuenta ya! - http://correo.yahoo.com.ar
[excessive quoting removed by server]
©2006 Dave Crozier |
