Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
FILTER and GO
Message
From
11/02/2002 05:25:26
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
FILTER and GO
Miscellaneous
Thread ID:
00618202
Message ID:
00618202
Views:
42
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]
Next
Reply
Map
View

Click here to load this message in the networking platform