ASPRunnerPro 4.0 Observations

Alberto,
thank you for your feedback!
Help file is not updated yet and some Help links do not work.
I need your help clarifying some issues.

1. I wasn't able reproduce error with multiple selection not being saved. Make sure your field is large enough to accept multiple values. If this doesn't help give me more info on this.
   
2. We'll remove "Table:" word.
   
3. What exactly in Vertical layout should be customizable?
   
4. Please explain why Any condition is useless on Advanced search screen.
   
5. Simply add new records to users table filling field that you defined as a GroupID with correct group name.
   
6. I do not see how Quick Jump box is related to Group permissions. Quick Jump duplicates menu page.
   
7. I'll double check this.

You're very welcome Sergey. It is always good to contribute building this wonderful Product.

1. You were right. I was able to make it work ok. Thanks
   
2. Here some topics found related with it: Topic1, Topic2, Topic3, Topic4. In other words, would be great if we can make the Vertical Layout to show more than one field per line or create a new layout like a Spread Sheet Layout where we can decide how many columns to show and may be deciding if we want to live some cells in blank as we were working with a spread sheet so we can use screen better and accomplish different requirements. I have done so by using what you suggested by adding or deleting <tr> with the big problem that every time we regenerate the pages we have to redo it again resulting a very tiring and complex thing having high risk of errors.
   
3. For example:
   
   All Condition: I understand as AND conditions => Select from TableName Where A=1 AND B=2 AND C=3 AND D=4
   
   Any Condition: I understand as OR conditions => Select from TableName Where A=1 OR B=2 OR C=3 OR D=4
   
   If this is what was intended then we would not be able to mix both for example:
   
   *Select from TableName Where (A=1 AND B=2) OR (C=3 AND D=4)** just to say something. If I am worng please explain how it works. Thanks
   
4. I will try this. Thanks
   
5. Sorry for the confusion but for the people that is not using the menu generated by ASPRunner and instead created our own automatic menus, permissions and restrictions based on database tables, the quick jump give the chance to users to go where they are not supposed to go.
   10. New: I forgot to mention the point related with the combo boxes that contain too many values resulting in a very difficult task when trying to select the right value. If we can be allowed to type more that one letter to find the right value would be immediately solved, but as you mentioned before we created an AUX field next to the Combo where the user can input the value instead of looking for it in the combo. When the user try to save the data if combo not selected and something is entered in the AUX field it is validated against the lookup table. If it is ok is saved instead the value in the combo box, if it is work show a massage box requesting to fix what is wrong. Some topics found Topic1, Topic2
   
   For this point we do not need to add values when does not exist because it was entered wrong or there is already a way created to achieve this task.
   11. New: What about creating Mouse Overfunction? When Formating step 7-12 as you have columns Field, Label, etc. you could create a new one, just like Label but for Mouse Over function allowing us to explain users what to do with or what contain that field when the pass the mouse over the column or the title of the field only. It would show a good improvment to users specially when fields value are results of formula calculation or to explain the can do multiple selection, shold be numeric only, etc.
   
   Formating Step 7 of 12
   
   |Field| |Label| |Mouse Over Text| |View as| etc...
   Thanks

Alberto,
please see my answers below
3. We just added an option to build multiple records per row list page. It works with both horizontal and vertical layouts. You can set this in ASPRunnerPro on "Fields order" tab.
6. You are correct - AND and OR cannot be mixed however it doesn't make new feature useless. Previously we had AND search only. Now you can choose between AND and OR searches which is a step forward.
8. I won't recommend to break ASPRunnerPro logix creating your own menu. You can modify menu appearance without messing with logic and permissions.
10. This is not easlily doable because Internet Explorer do not support quick dropdown box navigation typing more than one character. Probably we'll add something in one of the following versions.
11. We work hard to keep this application as simple as possible. Each new setting adds confusion. I don't think it fits into current version of ASPRunnerPro.

Sergey:
3. Very good new feature it will allow us to add more ways to show the page Sergey but unfortunately it does not solve this particular problem which is not to show multiple records per layout. What we need is only one record (per page) distributed around as the page were like a spread sheet.

In some way we should be able to say how many Columns of 1 record per Row or Line. So if the record consists in 30 fields and we say 3 Columns per Row then this 1 record would be shown in 10 rows or lines. Now if we are able to enter to each field in what cell (row, col) to be shown having the chance to use more than one cell for long fields would be the best. We are doing that manually just by adding or deleting "</tr><tr>" and "<TD colspan=X>" where X is the number of columns needed for each particular field. Would be very useful we are able to do that.
6. Definitely is a step forward having more ways to filter the search and we appreciate a lot your work and that is also why spend the time testing it looking how it will help us in a better way. Thanks man <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=7434&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />
8. Sergey, working with multiples projects you still need to have most of the time 1 main menu with all the menu options to be shown depending on the user is quite complex. That is why I have created a menu using only one menu_list.asp page that list records containing the options and links to _list.asp pages depending on the UserID. That means no matter how many projects and pages you have there is only 1 dynamic menu for users. The security feature you have developed is really good and that is what we need but for people with complex scenarios is necessary to be dynamic and nor hard coded.

I our case we have about 10 Groups. Each group has combined menu options for users that in few cases pertain to more than 1 group. I am trying to use the security feature that is excellent but I can't see it possible yet. I think having the groups in a table separated from users table would solve it and ASPrunner should check doing a select from that table to see if the user is authorized to access the page.

Users(UserID, Pass, Etc)

GroupsUsersMenuOptions(GroupID, UserID, TableName, Etc)
I am still trying to see how we could use this very important feature but it seems to me not possible yet.
10. Yes please we need it.
11. I am agreeing with you but I personally don't think this well known feature could confuse more than the goodness of having it. It could be there just like "Label" feature and as useful too.
Sorry for english and escuse my expresions please, it is only intended for the good of asprunner therefore of all of us on board in this Ship. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=7434&image=2&table=forumreplies' class='bbc_emoticon' alt=':D' /> Thanks again

Alberto,
3. We'll try to add something like this however it's definitely out of ASPRunnerPro 4.0 scope.
8. With ASPRunnerPro you may consider joining your multiple projects into a single one.

Having multiple custom tables views should eliminate a need of several projects.

Sergey:
3. Thanks we'll be excited waiting for it.
8. Your right, definetely that would help and solve a lot of things but for this I tried it once but the problem was that:
ASPRunner each time you need to change or add a page, it rebuilds the complete thing. And so many times had problems with either because I screwed up or something else happens that made me to delete and redo 1 or more pages in the project causing me to lose the settings specially in the formatting step wish is 1 of the most painful for complex views. Some times need to republish the whole thing cause fails when try to publish only the pages I believe should be, etc. I got already more than 60 menu options linked to an xxxx_list.asp page, plus if it corresponds, their add, view, search, etc pages.

[color=#CC0000]B: I have created lot of different views for the same table, that now I would have to regenerate with same manual customizations that force us to do so much and at a very high risk.

Since we have different Groups of users and some of the users pertain to more than one (like Managers and Supervisors of people of different groups) 1 user needs to be able to be assigned to 1 or more groups of permissions.

[color=#CC0000]D: It is easier to manage and maintain systems when we divide it by modules.
E: It is very dificult but having 1 or 2 simple pages the Systems Administrator can easily change the dynamic menu by Adding, Changing, Deleting Groups of Permissions or Users, with nothing hardcoded. (just like user and passwords functionality)
Sergey, please this is of course not a destructive critic; I found your product the best thing I have seen in my 37 years. I am more than happy with what I paid for. And since you are building new version of it and you are considering security things, my experience building systems in different technologies and my needs make suggest this type of improvements. Thanks.