I would say using SQLExec. I've had intermittent problems when appending several records to a view and then trying to save changes.
In case you don't know this, you can simplify the creation of the SQL statement to submit by using TEXT / ENDTEXT command in VFP. For example:
text to cSQLInsert textmerge noshow
insert into mytable( field1, field2, field3 )
values( '<<MyCursor.fieldA>>', <<MyCursor.fieldB>>, '<<MyCursor.fieldC>>' )
endtext
nError = SQLExec( nConn, cSQLInsert )
>Hi everyone,
>
>I'd like to know your thoughts on which is the best approach for inserting data in SQL Server tables.
>
>Using SQLEXEC(...) and passing a long INSERT sql statement.
>or
>Using a remote view:
>USE RemoteView NODATA
>APPE BLANK
>.
>.
>.
>TABLEUPDATE()
>
>This is strictly from a VFP and performance points of view.
>
>Cheers!
Hector Correa