The following program opens the Employee table in the Testdata database. ALINES( ) is used to copy the lines in the Notes memo field to an array named aMyArray
, and then the contents of the array is displayed.
In this example, ALINES( ) returns 1 because the employee description was typed into the memo field without pressing Enter after any of the sentences.
CLOSE DATABASES
CLEAR
SET TALK OFF
OPEN DATABASE (HOME(2) + 'data\testdata')
USE employee && Open Employee table
? ALINES(aMyArray, employee.notes) && Displays 1
? aMyArray(1)