This topic is locked
[SOLVED]

 Problem with prev/ next button on edit page

6/27/2012 9:57:48 AM
PHPRunner General questions
S
Sitaraman author

Hi

I am using dynamic permissions for my table. There is a group which have access to data belonging to a particular department. So I set this group as administrator and add a filter for the department in before sql query event of list and add pages. My problem is when I edit data when logged on in this group, the prev/next button does not behave as expected and instead returns to the list page. Any solutions??

Sergey Kornilov admin 6/29/2012

Instead of BeforeSQLQuery event use AfterTableInitialized event and SQLQuery object.

See examples at http://xlinesoft.com/phprunner/docs/addwhere.htm

S
Sitaraman author 7/1/2012

Dear Sergey,
Your solution worked like a charm!! The same solution worked for my another post relating to advanced searchhttp://www.asprunner.com/forums/topic/19797-problem-with-advanced-search/pagegopid66863&#entry66863
Thanks a lot for your great support and good work!!
Regards

Sitaraman