Difference between revisions of "MTOS()"

From Lianjapedia
Jump to: navigation, search
 
(One intermediate revision by the same user not shown)
Line 6: Line 6:
  
 
==See Also==
 
==See Also==
[[ATOM()]], [[MEMLINES()]], [[MEMOLINE()]], [[MEMOREAD()]], [[MEMOTRAN()]], [[MEMOWRITE()]], [[MLCOUNT()]], [[MLINE()]], [[MTOA()]], [[SET MEMOWIDTH]], [[SET STRESCAPE]], [[STRTRAN()]], [[SUBSTR()]]
+
[[ATOM()]], [[HTML_TOPLAINTEXT()]], [[MEMLINES()]], [[MEMOLINE()]], [[MEMOREAD()]], [[MEMOTRAN()]], [[MEMOWRITE()]], [[MLCOUNT()]], [[MLINE()]], [[MTOA()]], [[SET MEMOWIDTH]], [[SET STRESCAPE]], [[STRTRAN()]], [[SUBSTR()]]
  
 
==Description==
 
==Description==
Line 22: Line 22:
 
[[Category:Formatting Functions]]
 
[[Category:Formatting Functions]]
 
[[Category:String Data Functions]]
 
[[Category:String Data Functions]]
[[Category:Memos]]
 
 
[[Category:Memos Functions]]
 
[[Category:Memos Functions]]
 
[[Category:Lianja VFP Extensions]]
 
[[Category:Lianja VFP Extensions]]
 
[[Category:VFP Function Extensions]]
 
[[Category:VFP Function Extensions]]

Latest revision as of 09:27, 20 September 2016

Purpose

Function to convert a memo field to character data type

Syntax

MTOS(<memofield>)

See Also

ATOM(), HTML_TOPLAINTEXT(), MEMLINES(), MEMOLINE(), MEMOREAD(), MEMOTRAN(), MEMOWRITE(), MLCOUNT(), MLINE(), MTOA(), 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