>>>>>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.

Project for the great fantastic Chen? lol lol. Which reminds me -- can't download the latest VFP10 Advanced from the website right now, it's showing too many downloads wait till next month..