General information
Category:
Visual FoxPro and .NET
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only