Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Updating Foxpro Databases
Message
De
07/02/2002 11:00:21
 
 
À
07/02/2002 09:49:22
Information générale
Forum:
Visual FoxPro
Catégorie:
Visual FoxPro et .NET
Divers
Thread ID:
00616591
Message ID:
00616665
Vues:
29
>I am currently using Visual Studio .NET beta 2, and experimenting with connecting to foxpro databases.
>
>I have managed to happily retrieve data using a Foxpro OLE DB connection, but I am having problems with the syntax for the update, insert and delete triggers.
>(I have no probles updating SQL Server databases)
>
>Does anyone know of any useful articles, or any information whatsoever on using .net to interact with vfp?


I don't know if the following, from the VFP7 README, is of any help to you, but here it is:
Syntax of Stored Procedure Calls in Visual FoxPro OLE DB Provider. When calling a stored procedure using the Visual FoxPro OLE DB Provider, set CommandType to adCmdText (1) or to adCmdUnknown (8), and not to adStoredProc (4). Visual FoxPro requires that stored procedures have open and close parentheses "()" at the end of the stored procedure name. However, ADO removes the parentheses from the end of the stored procedure name when you use adStoreProc.

good luck
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform