This topic is locked

Suggestions for Version 4.x

10/23/2006 11:58:56 AM
ASPRunnerPro General questions
J
jlemecthomas author

Here are a couple of suggestion for the next version of ASPRunner:
This is a great piece of software. I've not purchased it yet. I am still experimenting with it but I would like to see the following features in a future update.

  1. More freedom in designing the layout of Master/Detail forms such as the Master info in a concise vertical format and the detail in horizontal format such as:
    xxxxxxxxxxx

    xxxxxxxxxxx

    xxxxxxxxxxx

    (master)
    xxxxxxxxxxx xxxxxxxxxx xxxxxxxxxx xxxxxxxxx xxxxxxxxxx xxxxxxxxx

    xxxxxxxxxxx xxxxxxxxxx xxxxxxxxxx xxxxxxxxx xxxxxxxxxx xxxxxxxxx

    xxxxxxxxxxx xxxxxxxxxx xxxxxxxxxx xxxxxxxxx xxxxxxxxxx xxxxxxxxx

    xxxxxxxxxxx xxxxxxxxxx xxxxxxxxxx xxxxxxxxx xxxxxxxxxx xxxxxxxxx
  2. Multi Column drop down list similar to MS Access
  3. Apply total to all seclected fields. Right now, you have to select Total for each field. It is nice that the information is passed on to other total pages but when you have 10+ fields to request a total on a page, that can be time consuming.
  4. A visual SQL designer; again similar to MS Acess
  5. To include a table or view in a drop down list, it must be created at the database leve. It would be nice if a view created in ASPRunner could be used for dropdown list.
    Thank you.

Sergey Kornilov admin 10/23/2006

Thanks for suggestions! See my answers below:

  1. Vertical layout on master table info

    You can do this already using WYSIWYG editor
  2. Multi Column drop down list

    You can do this using custom display expression (combine two or more fields together)
  3. Apply totals to several fields

    Will have this in on of the next versions.
  4. A visual SQL designer

    Will be added in one of the next versions as well.
  5. Custom view is basically another SQL query executed against the same database table. I can see two possible problems here:

  • if you delete this custom view dropdown box stops working
  • some databases won't allow you to use subqueries

    select id, name from (select ... from ...)
    In most cases you can achieve what you looking for using custom display expressions and WHERE clause.

J
jlemecthomas author 10/24/2006

Thanks for the info. I will experiment with them.
Another thought, how about a detail edit matrix where you can move from one record to another without going back to the master list.
JLT
>>>>>

Here are a couple of suggestion for the next version of ASPRunner:

This is a great piece of software. I've not purchased it yet. I am still experimenting with it but I would like to see the following features in a future update.

  1. More freedom in designing the layout of Master/Detail forms such as the Master info in a concise vertical format and the detail in horizontal format such as:
    xxxxxxxxxxx

    xxxxxxxxxxx

    xxxxxxxxxxx

    (master)
    xxxxxxxxxxx xxxxxxxxxx xxxxxxxxxx xxxxxxxxx xxxxxxxxxx xxxxxxxxx

    xxxxxxxxxxx xxxxxxxxxx xxxxxxxxxx xxxxxxxxx xxxxxxxxxx xxxxxxxxx

    xxxxxxxxxxx xxxxxxxxxx xxxxxxxxxx xxxxxxxxx xxxxxxxxxx xxxxxxxxx

    xxxxxxxxxxx xxxxxxxxxx xxxxxxxxxx xxxxxxxxx xxxxxxxxxx xxxxxxxxx
  2. Multi Column drop down list similar to MS Access
  3. Apply total to all seclected fields. Right now, you have to select Total for each field. It is nice that the information is passed on to other total pages but when you have 10+ fields to request a total on a page, that can be time consuming.
  4. A visual SQL designer; again similar to MS Acess
  5. To include a table or view in a drop down list, it must be created at the database leve. It would be nice if a view created in ASPRunner could be used for dropdown list.
    Thank you.