Hi,
I also think SQLExec is better from a performance point of view, although using views is much simpler. I'm working with tables with less than 20,000 records so I think the difference shouldn't be noticeable.
Thanks for the TEXT / ENDTEXT tip.
>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!
R. Davila
DBA / Network Administrator
Administracion de Fomento Comercial
Gobierno de Puerto Rico
Still waiting for FoxPro for LINUX