msql insert new record

[Robert Mann]

have a update code that works great, with some held form this list

put "UPDATE rider SET "&updateColValListOf123Pairs&" WHERE record_id = '" &
fld "record_id" & "'" into tSQL

how would I change this to insert a new record


get   "fcomp = " &'& fld fcomp &'
get it & ",freb = " &'& fld freb &'
get it & ",fctgmods = " &'& fld fctgmod &'
put it into updateColValListOf123Pairs

put "INSERT INTO rider "&updateColValListOf123Pairs&" " into tSQL

the above does not seem to work?

any help would be greatly appreciated

Thanks


Robert Mann