Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
FILTER and GO
Message
De
11/02/2002 05:25:26
Lutz Scheffler (En ligne)
Lutz Scheffler Software Ingenieurbüro
Dresden, Allemagne
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
FILTER and GO
Divers
Thread ID:
00618202
Message ID:
00618202
Vues:
43
Hi All,
testing the SortGrid Class out of download area, I found an problem I have now good idea to solve.

The problem is not only by SortGrid it is in general.

I have a Table
RECNUM Idx cField
1      1   'aTest'
2      2   'bTest'
3      3   'aTag'
If I do the following
SET FILTER TO Idx#2
GO 2
?cField
I get 'bTest' printed out even it is a filtered record.

I look in EOF() and BOF(), both are .F.

Same problem happens, if I use SET ORDER TO with an filterd index (thats why I run in this with SortGrid, since SortGrid simple uses:
 IF BETWEEN(m.lnOldRecNo,1,RECCOUNT()) THEN
  GO (m.lnOldRecNo)
 ENDIF
and I'm within reccount).

So what I need is a way to determine if a record is after SET FILTER or SET ORDER within or without the filter.

Since this problem occurs with restore of grid's postion, what would be the best record the select if the one I stored is hidden?

Thank you for help
Agnes
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform