>>>>Is there a way to perform a bulk insert from a VFP table to SQL table if the VFP table has memo fields?
>>>>I know I can take a VFP table, copy it to a .csv file, and then bulk insert that -- but of course I can't get the memo fields in the .csv file.
>>
>>You could try table buffering in your remote view.
>
>I always believed every branch of tableupdate() used single statements
>created for each dbf record - on dumb analogy of needs of "only changed fields"
>but never compared runtime or traced from server side
>perhaps lulled in by cursoradapter option to fire before and after hooks...
>did you test ?

IIRC, the option to insert multiple records with one command is a fairly recent addition to TSQL, and I'm sure that it was not added to VFP. But then, when generating code, why not. I think I did that a few times.