Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Insert records to a linkedserver VFP DBF with MEMO field
Message
 
 
À
30/08/2005 17:09:10
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 6 SP3
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
MS SQL Server
Divers
Thread ID:
01045319
Message ID:
01045323
Vues:
19
>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--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform