Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Insert records to a linkedserver VFP DBF with MEMO field
Message
 
 
To
30/08/2005 17:09:10
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 6 SP3
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01045319
Message ID:
01045323
Views:
25
>I create a linked server with VFP ODBC driver in MSDE to a VFP table which has some memo fields.
>
>SELECT, UPDATE and DELETE (with OPENQUERY...) works fine, but INSERT doesn't. If I modify the structure of a DBF and delete all memo fields, INSERT works.
>
>Is there some workaround about memo fields with INSERT command?

A while back I couldn't get insert to work in this situation so I switched to VFP OLE DB provider. It's not supported option but it did work for me until we moved the table to SQL Server. Fortunatelly, I only had to do insers in that linked server.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform