Assign value to a variable in load script using Inputbox and MsgBox

[#1]

Hi All,

Is it possible to have message box and inputbox in a load script where I advise

user to assign value to a variable vPriceType i.e. "Would you please choose Price Type"
assign number i.e. "1" for Distri or "2" for Street so when I reload script

I don't need to type text but only one number and then using assigned value 1 or 2
to re-assign textual value Distri or Street to vPriceType variable which I then use
in where clause i.e. where PriceType = vPriceType

Thanks in advance.

Amko

[swuehl · Accepted solution]

Something like this in the script:

Let vPriceType = Input('Would you please choose Price Type','Caption');

edit:

or to assing the text based on input 1 or 2:

Let vPriceType = Pick(Input('Would you please choose Price Type','Caption'),'Distri','Street');

[#3]

Stefan ich bedanke mich recht herzlich!

Thank you very much for solving this issue so fast

I used the variable in where clause like this and it works fabulous.

Where [PRICE TYPE] = '$(vPriceType)'