In this thread,http://msgboard.alphasoftware.com/al...ad.php?t=72708, Selwyn confirms this is a bug. However, this was back in April and it still seems to be a problem.
Maybe, I'm approaching this the wrong way, who knows....
1. I have a table of customers.
2. If a user logs in and he doesn't have a specific group access then he can only see the customers that are assigned to him.
3. The form (with an embedded browse) displayed has a filter applied with the expression: user=user_name(). This would be most users except for the Administrator who sees a different form named Customers-Admin that has no filter set on the form.
4. I have buttons on the form that allow a user to see Customers designated as "Hot", "Overdue for a Call", etc. which basically run simple querys on the form.
So far everything is great, EXCEPT...
5. When the user tries to sort the column it removes the sort applied by the button. So let's say I have 20 customers in the embedded browse. The "Show only 'Hot'" button is pressed and only 10 show. When the customer clicks on the column to sort (which is the behavior I want) the embedded browse shows all 20 customers again.
6. I tried applying the workaround Selwyn suggested which is to call an Xbasic event when the column is clicked- namely Quicksortexplicit() - but this doesn't work either.
So my question is, knowing what I'm trying to accomplish (i.e. only showing distinct records based upon user group) am I approaching this the right way? I'd be surprised if I'm the only one who is trying to use Alpha in this way.
This only happens with an embedded browse. It does not occur with a named Browse - unless I embed it!?!?!
This is critical to my app. Unfortunately, using a named Browse won't work because I want specific buttons on the screen that I do not want to place on the toolbar.
Maybe, I'm approaching this the wrong way, who knows....
1. I have a table of customers.
2. If a user logs in and he doesn't have a specific group access then he can only see the customers that are assigned to him.
3. The form (with an embedded browse) displayed has a filter applied with the expression: user=user_name(). This would be most users except for the Administrator who sees a different form named Customers-Admin that has no filter set on the form.
4. I have buttons on the form that allow a user to see Customers designated as "Hot", "Overdue for a Call", etc. which basically run simple querys on the form.
So far everything is great, EXCEPT...
5. When the user tries to sort the column it removes the sort applied by the button. So let's say I have 20 customers in the embedded browse. The "Show only 'Hot'" button is pressed and only 10 show. When the customer clicks on the column to sort (which is the behavior I want) the embedded browse shows all 20 customers again.
6. I tried applying the workaround Selwyn suggested which is to call an Xbasic event when the column is clicked- namely Quicksortexplicit() - but this doesn't work either.
So my question is, knowing what I'm trying to accomplish (i.e. only showing distinct records based upon user group) am I approaching this the right way? I'd be surprised if I'm the only one who is trying to use Alpha in this way.
This only happens with an embedded browse. It does not occur with a named Browse - unless I embed it!?!?!
This is critical to my app. Unfortunately, using a named Browse won't work because I want specific buttons on the screen that I do not want to place on the toolbar.
Comment