Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Bulk insert VFP table to SQL with memo fields?
Message
From
19/01/2023 18:36:41
 
 
To
19/01/2023 16:44:00
John Ryan
Captain-Cooker Appreciation Society
Taumata Whakatangi ..., New Zealand
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01685857
Message ID:
01685870
Views:
46
>>>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 ?

>Or, create a sql script with lots of INSERTs that you can execute from VFP by various means: see https://learn.microsoft.com/en-us/sql/tools/sqlcmd-utility?view=sql-server-ver16
>You can use Profiler to review the insert created by the RV, which makes it easier to mimic an insert in a script.

written on the assumption Victor needs bulk as in block, not record inserts... ;-)

curious
thomas
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform