Lookup wizard

Hi,
it is not really clear what functionality do you want to get. Could you explain it in detail?

Hi,
Suppose a table where you have fields like

orderid

supplierid

item

quantity

where supplierid can be match with a field supplierid in table supplier.
If your user is entering such fields in a table and you woul like to check the supplierid to see whether it is a valid id then I suppose you would use a Lookup wizard ?

When the table of the suppliers where you would check the supplierid contains a lot of records ( +100000 ) than the lookup wizard is not the best way to perform the check and you should better control the validity of the supplierid when exiting the field or when saving the record.
Thanks

Christian,
I see what you saying.
You can check if entered value exists in lookup table and cancel record update if not. Also you will need to add some code to keep entered values in edit fields so user don't have to type everything once again.
Here is the sample code:

strSQL = "select * from LookupTable where LookupField ='" & Request.Form("LookupField") & "'"

Sergey,
are you adding this feature to V3.2? It is really slow when you have a lot of drop down boxes and some tables are big.
Alberto

Alberto,
I'm not sure if everyone needs to check input on the server side. We'll add this if more people ask for this feature.

I

Seem to have a lot of drop drowns but solve this by hard coding into client side page it is even slower so Here is another person asking for this feature
Thanks.

More advanced drop down is wanted

A cascading/dependent dropdown feature would be very welcome here <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=3636&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' /> <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=3636&image=2&table=forumreplies' class='bbc_emoticon' alt=':)' />

Hello Sergey,
We are having
SERIOUS PROBLEMS BECAUSE OF THE DROP DOWNS MAKE THE PAGE TO WORK REALLY SLOW.
When you want (Using Drop down boxes) to assign or select a client #, product # or any record number of a table that contains a lot of rows it works bad.

If we change the program manually later we are not going to be able to use ASPRunner to modify it.
Can you add something that help in that way, OR AT LEAST LET US TO MODIFI THE SQL ON THE STEP Look up wizard with including something like an indicator to use the standard SELECT or the one we typed in there and save it.
Mike

Hi,
we work on making lookup wizard faster in ASPRunner Pro v.3.2.

Sergey,
I think that Mike is right on several points.

I suppose the easiest feature would be to check if the value entered by the user exists in the defined table.
It would be very usefull to have this in the next version ( when will it be released ? )

I even would say that this is more usefull than making the lookup faster ( thnik e.g. in tablesize of several 100 000 records )
Thanks
christian

Christian,
I hardly imagine person that types something into a textbox several times and getting "Incorect input" error. However I see a lot of people who needs something like this.
In April-May we plan to introduce events or triggers like BeforeUpdate. Basically that would some function that will be called by ASPRunner before actually updating or inserting record. This function can check some values and cancel update if some validation rules fail. Also this function returns an error message that will be displayed to user. Using events you will be able to validate user's input against a lookup table with huge number of records.

I also back everyone up...anything on this side would be fantastic...

Robert

Hi,
look this problem related to lookup wizard
Thanks

Hi,
see answer here.