This topic is locked

lookup based on custom view?

9/4/2010 7:36:49 AM
ASPRunnerPro General questions
W
waynes888 author

Why is it not possible to use a custom view as a look table? Afterall, doesn't the lookup just create a list of value/options? My tables are normalised so I want to use a custom view to display text options rather than numbers. Is there a way around this?

W
waynes888 author 9/7/2010

hello? Anyone out there?

Sergey Kornilov admin 9/7/2010

You cannot use custom view as a source for a Lookup wizard.
As a workaround you can create an additional view/query right in your database using the same SQL query.

W
waynes888 author 9/8/2010



You cannot use custom view as a source for a Lookup wizard.
As a workaround you can create an additional view/query right in your database using the same SQL query.



That's part of my problem as mentioned in a previous issue (convert to mysql). The host for the site I am working on has admitted they have an issue with MySql and access to views & won't be fixing it till later this year. I can't use a view in the database and was hoping I could use the custom views. I understand it doesn't work, my question was why? What would prevent using a custom view as a lookup? In normal programming this is easy to do as a query but there is no way to do it in asprunner? Is there any thought in the future to creating dynamic lookup tables that are not tied directly to a table or database view?

Sergey Kornilov admin 9/8/2010

We definitely going to add this feature however this won't happen till ASPRunnerPro 7.0.
Choosing between waiting for your provider to "fix" this and switching to another web hosting I'd definitely choose latter.

W
waynes888 author 9/9/2010



Choosing between waiting for your provider to "fix" this and switching to another web hosting I'd definitely choose latter.


Unfortunately it's not an option for me as it's a client site but I will find other workarounds.