Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Problem with filepath in script

Posted By chuntley87 over 5 years ago

I'm trying to pass a filepath in a button script (MAS 200 "Execute on Server"). I can't get the variable to take the literal string that I assign. Here's what I mean:

sample script:

sAttach = "\\fileserver\folder\file.pdf"

retVal = oSession.AsObject(oSession.UI).MessageBox("",sAttach)

The result is not "\\fileserver\folder\file.pdf", but

fileserver

folder

file.pdf

Everywhere there were backslashes in the string, a new line gets inserted and the backslash doesn't appear. This behavior doesn't happen with non-Sage vbs scripts. Has anybody ever run into this?

0 Kevin M over 5 years ago

That could just be how the MessageBox method displays slashes.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 chuntley87 over 5 years ago in reply to Kevin M

Kevin,

Thanks for the reply. I think you may be right. My script that contained a filepath variable is working as expected, I just assumed it wouldn't since the messagebox displayed it wrong.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Alnoor over 5 years ago in reply to chuntley87

Kevin is correct. In the MessageBox function the presence of \ is treated as CR + LF. It's actually an old feature. So for messaging purposes Replace(sAttach, "\", "/")
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

Problem with filepath in script

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING