Sergey,
I am using VFP 9.0 SP1. After retrieving them (already with an ORDER BY clause), they are SET RELATIONed TO another table which was also retrieved from MySQL. The code goes something like this:
SELECT StudentRecHDR
SET RELATION TO StudentID INTO StudentRecDTLX
SET SKIP TO StudentRecDTLX
IF llAllStudents
GO TOP
REPORT FORM ReportCard TO PRINTER PROMPT PREVIEW
ELSE
LOCATE FOR StudentID = lcStudentID
REPORT FORM ReportCard TO PRINTER PROMPT PREVIEW ;
WHILE StudentID = lcStudentID
ENDIF
The memo fields are in StudentRecHDR (the header table).
Dennis
>Dennis,
>
>Are you doing anything with records between retrieving them and printing report?
>What VFP version are you using?
>
>>
>>Actually, every time I test it, the records are always correct.
>>
>>Quite a few times though, during the actual run of the report card generation, the teachers have shown me a 'jumbling' of two TEACHER REMARKS memo fields. ( Student A has in his printout the Teacher Remarks of Student B and vice versa ).
>>
>>Worth noting though is that it happens to the FIRST and SECOND students that are printed out. A section usually has around 40-50 student records.
>>
>>These memo fields are coming MySQL table fields of the TEXT data type.
>>
>>