2. ASPRunnerPro General questions
  3. Edit Page button Next and previous filter rs
This topic is locked

Edit Page button Next and previous filter rs

 		10/19/2009 1:06:17 PM
ASPRunnerPro General questions
R
 RASM author

Hi,
Version Asprunner 6.01

In Edit page , have buttons next register and previous register, but when clicked shows all register of table, i need filter register equals register shows in page list.
In list page i filter with event Function BeforeQueryList(strSQL,strWhereClause,strOrderBy) and clause :

strWhereclause = WhereAdd(strWhereClause,"IDEmpresa= "&Session("IDEmpresaPK")&" ")
But i tried for edit event Function BeforeQueryEdit(strSQL,strWhereClause) and equals clause :

strWhereclause = WhereAdd(strWhereClause,"IDEmpresa= "&Session("IDEmpresaPK")&" ")
But don´t work and shows all register of table.
Any suggestion?
thanks.
J
 		Jane 10/20/2009

Romulo,
It's difficult to tell you what's happening without seeing actual files.
Please publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages along with instructions on reproducing this error.
R
 		RASM author 10/23/2009

OK, but to filter edit page in next and previous buttons , i have to use event edit page : before sql query (BeforeQueryEdit) ??
thanks.