>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