Hi,

I'm posting this message again, because it seems to be a bug and the
message may have been ignored the first time.


I'm having the following problem with orderinglinks

SQL Statement:
SELECT * FROM INVENTORY
WHERE ACTIVESTATUS <> :MYPARAM

Param:
MYParam = 'N'

ORDERING LINKs:
....
STOCKNUMBER=ITEM=4;POS=1
....

Example Data:
ID, ACTIVESTATUS
1,Y
2,N
3,N
4,Y
5,Y
6,Y

Problem
(All this happens in a grid.)

When I open the table everything is perfect, I only see my 4 records.
But if I move my cursor to ID 4, then press REFRESH Button (Nav Bar)
ID 2, 3 APPEAR!.
I've traced it with the SQL Monitor to verify that my param isn't
lost. The SQLMonitor tells me the Param is assigned 'N'. So thats
not the problem.

If I remove POS=1 from my Ordering Links so that it looks like the
following:
....
STOCKNUMBER=ITEM=4
....

Everything works fine. But if I use ANY Pos it seems to ignore the param.

Besides this problem... Everything is fine. I'm currently not using
the POS, but I'd like use it, for it increases the speed of my searches.

Thank you.

Have a nice day.