Use of vbscript input box function with mas 200

Posted By TomTarget over 12 years ago

I'm doing a button script to prompt for a value and then execute some code. Trying to avoid creating a udf to hold the parameter that will just be discarded after the code is run.

Succeeded in mas 90 using the following:

Retval = inputbox("enter value",,0)

However in mas 200 you get ole error number 70. Permission denied 'inputbox'

Sounds similar to issues of msgbox and message box. Anyone know how to get around this?

TomTarget over 12 years ago

Just found info on this in another thread which suggests I will have to use a UDF after all to get the info as inputbox isn't going to work in MAS 200.

However, if anyone has figured out a way to do it since, I would be happy to hear about it.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
connex over 12 years ago

You can use MessageBox to put up multiple response buttons and return an indication of what button was clicked, but no solution for general prompt data.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
TomTarget over 12 years ago

Yup. Have done the button trick for discrete options, but as you say it doesn't work if you have a range of values.

On to using UDF's.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
mroman over 7 years ago in reply to TomTarget

Hi,

Have you guys found an answer on using an InputBox in Sage 100 Advanced(Mas200) vbscript ?
Can you please let me know. I thought that with Sage 2015/2016 we were going to be able to do this.

Regards,
Manuel Roman
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Kevin M over 7 years ago in reply to mroman

And input box can work in a button script run client-side (not the server option), but then you don't have access to business objects.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
connex over 7 years ago in reply to Kevin M

If you need business object scripting methods, those won't work in a client side script; however you can point the button script at a server-side script and have that script invoke a client-side script. Good luck if you need to pass the input to the original script though.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Kevin M over 7 years ago in reply to connex

InputBox client side, write the value back to a UDF, with a trigger on that field which fires off a server side script. It gets complicated tracing execution through though, and it doesn't always work nicely.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
mroman over 7 years ago in reply to connex

Hi Conner

Thanks i will definitely need luck... i think

Regards,
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Sage 100

Use of vbscript input box function with mas 200

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING