>Hi Cetin,
>
>thanks for your reply.
>
>For the 2nd question:
>Well, I tried to do: 'SCATTER MEMVAR MEMO' but it won't succeed. Usually, when I had the RESULTS, I need to save to another cursor using 'create cursor' then use 'scatter memvar'. it works fine for another data type, except MEMO. May be I've done something wrong somewhere.
>
>Best regards,
>William

I don't understand why you need scatter-gather there. Scatter-gather work with memo quite well though :

scatter memvar memo
...
gather memvar memo

scatter name oRecord memo
...
gather name oRecord memo

and so on.

For SQL server :

scatter name oRecord memo

SQLExec(lnHandle, ;
 'insert into SQLServerTable (MemoFieldName) values ?oRecord.MemoField')

scatter memvar memo
SQLExec(lnHandle, ;
 'insert into SQLServerTable (MemoFieldName) values ?m.MemoField')

However I'm still not sure I understood it right.
Cetin