Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Won't generate update/delete statements for fox tables
Message
General information
Forum:
ASP.NET
Category:
Databases
Miscellaneous
Thread ID:
00635807
Message ID:
00638173
Views:
17
>SQL Server uses the @parameter syntax, but I've had no luck at all with that and the fox oledb driver...

The VFP OleDb driver doesn't support the Store Procedure syntax that uses

System.Data.CommandType.StoredProcedure

Instead you'll have to create the SQL command manually and embed the data into it (System.Data.CommandType.CommandText) as a function call string.

This can be a problem for some things like binary data or text in certain character sets that are non default which you won't be able to get in there as a literal string.

+++ Rick ---
+++ Rick ---

West Wind Technologies
Maui, Hawaii

west-wind.com/
West Wind Message Board
Rick's Web Log
Markdown Monster
---
Making waves on the Web

Where do you want to surf today?
Previous
Reply
Map
View

Click here to load this message in the networking platform