>But what I am not clear is, if we talk about updating VFP table at this time, how do you do a single update from a temp table (where this temp table has more than one row)? And how do you do single insert command whereas the temp table may have many rows that need to be inserted?

* Update
UPDATE table SET ... FROM table JOIN cursor ON table.pk = cursor.pk 
* Insert
INSERT INTO table SELECT * FROM cursor