>... > PADR(ALLTRIM(contacttype) + " - " + TEXT,254) AS act_notes, >... >>
>>SELECT TYPE, calldate AS act_time, lcPrblem AS problem_id, ; >> "OLDFLTDB" AS user_id, lcclient AS client_id, ; >> ALLTRIM(contacttype) + " - " + ; >> TEXT AS act_notes, ; <------- this is a memo field >> "Number: " + ALLTRIM(STR(NUMBER)) ; >> + " ID: " + ALLTRIM(STR(ID)) AS nxtact_not, ; <------- this is a memo field >> TTOD(calldate) AS act_date ; >> FROM ctempaction LEFT JOIN cactiontype ; >> ON ctempaction.TYPE = cactiontype.contacttypeid ; >> WHERE NUMBER = lnnumber ; >> AND !EMPTY(TEXT) ; >> INTO CURSOR csupaction READWRITE nofilter >>>>