SET FIELDS TO fieldname1, fieldname2By leaving out the memo fields in the list of fields in SET FIELDS TO, your CURSORTOXML will output just the fields in the list and may be faster than SQL SELECT of just those fields. (Remember to SET FIELDS TO afterwards to restore visibility of all fields if you need to do anything further with that open DBF). SET FIELDS TO is sort of like a filter on a DBF, except that it filters fields instead of records. It also handles skeletons, as in:
SET FIELDS TO ALL LIKE skeleton SET FIELDS TO ALL EXCEPT skeletonwhich might be helpful if all your memo fields are named in a way that a skeleton could apply to them and not to other fields. For example, if I had fields test, testnum and testmemo I could eliminate the memo with
SET FIELDS TO ALL EXCEPT *memo