Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Won't generate update/delete statements for fox tables
Message
Information générale
Forum:
ASP.NET
Catégorie:
Bases de données
Divers
Thread ID:
00635807
Message ID:
00638173
Vues:
16
>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?
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform