Hi,

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 is 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 forget 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.


PS. I'm sorry if this message is sent twice, I tried the first time
from outside of Yahoo and didn't seem to get posted