I need to store in trext fields some text files no bigger than a 100 k
using the following
UPDATE TBL_PATIENTS SET PAT_REM = LOAD_FILE('D:/TMP/PAT_MEMO.TXT') WHERE PAT_COD = 2;
it retuns ok but no change in the field... remains empty.
What am I doing wrong, is there a better way ?