MTOS()

From Lianjapedia
Revision as of 05:19, 10 February 2012 by Yvonne.milne (Talk | contribs)

Jump to: navigation, search

Purpose

Function to convert a memo field to character data type

Syntax

MTOS(<memofield>)

See Also

MEMLINES(), MEMOLINE(), MEMOREAD(), MEMOTRAN(), MEMOWRITE(), MLCOUNT(), MLINE(), SET MEMOWIDTH, SET STRESCAPE, STRTRAN(), SUBSTR()

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

string = mtos(notes)
string = string + chr(10) + "AT" + date() +" " + time()
replace notes with string