Cetin, greetings again

quick question about

>SQLExec(lnHandle,'insert into SomeTable (textField) values (?myTemp.myMemo)')
>

whats the best syntax for inserting records with a few fields? and how would that differ if, say, the records had 100 fields.

I'm trying to insert a bunch of records using

for n=1 to reccount()
scatter memvar
result=SQLEXEC(gnhandle,'insert into mytable (field1,field2,field3 etc) values (m.field1,m.field2,m.field3 etc),'')
endfor

the "result" is coming back as minus 1 so obviously I've got something wrong.

In any case, is there a more efficient way? Particularly for tables with large numbers of columns that looks horrendous!

Thanks

Harry