MTOS()
From Recital Documentation Wiki
Revision as of 15:24, 28 October 2009 by Helengeorge (Talk | contribs)
Purpose
Function to convert a memo field to character data type
Syntax
MTOS(<memofield>)
See Also
HARDCR(), MEMLINES(), MEMOEDIT(), MEMOLINE(), MEMOSAY(), MEMOREAD(), MEMOTRAN(), MEMOWRITE(), MLCOUNT(), MLINE(), SET MEMOCLEAR, SET MEMOFORMAT, SET MEMOWIDTH, SET MEMOWINDOW, SET PRERECORD, SET WP, STRTRAN(), SUBSTR(), TEXTEDIT()
Description
The MTOS() function converts the memo field <memofield> to a character data type. This function is particularly useful for modifying fields globally. If the specified <memofield> is empty, the MTOS() function returns a null string ("").
Example
set memoformat off string = mtos(notes) string = string + chr(10) + "AT" + date() +" " + time() replace notes with string
Products
Recital Database Server, Recital Mirage Server, Recital Terminal Developer