How to add carriage return in MsgBox when in Script?

[#1]

Hi

Trying to add a carriage return for the long error msg that i have in script and cannot seem to get it working.

I'm new user and is using version 11.2 SR5

Below is what I want to show:

Missing Source File: InternalHedges.qvd. 

The file is incomplete, use with caution. 

Please contact IT Team for assistance.
email@company.com

this is what i wrote for my script:

Test:

Load
MsgBox('Missing Source File: InternalHedges.qvd. '

&chr(10)&'The file is incomplete, use with caution. '
&chr(10)&'Please contact IT Team for assistance. '

&chr(10)&'email@company.com',
'MISSING SOURCE FILE', 'OK', 'ICONEXCLAMATION')
autogenerate 1;
DROP TABLE Test;

Any help/tip is greatly appreciated!  Thanks!

Louise

[swuehl]

Strange...

I initially added the Recno() because it didn't worked correctly without (ok, also not with recno() ).

Adding rowno() seems to help, but why?

Anyway, I don't think I will ever use MsgBox() within a LOAD statement again...