Read up on SQL Insert and later Update to get syntax and basic understanding.
read up on using parameters as to not fall prey to SQL injection.
Sleep a night.
Read up on Cursoradapter. Get them to work.
If the Cursor of a cursoradapter is workink ok with the backend,
Select into CursoradapterCursor (Select * from vfptable)
Tableupdate()

or
use CursoradapterCursor
Append from vfptable
Tableupdate()

Gives you isolation from backend differences AND nice hooks in case of trouble.