Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updating Foxpro Databases
Message
From
07/02/2002 11:00:21
 
 
To
07/02/2002 09:49:22
General information
Forum:
Visual FoxPro
Category:
Visual FoxPro and .NET
Miscellaneous
Thread ID:
00616591
Message ID:
00616665
Views:
25
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform