Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Inserting a new record via OleDbCommand
Message
Information générale
Forum:
ASP.NET
Catégorie:
ADO.NET
Divers
Thread ID:
00693070
Message ID:
00694262
Vues:
23
Paul,

Using the CommandType = CommandType.StoredProcedure is not supported for VFP. Nor is using the Parameters collection. You need to pass any parameters within the procedure statement, building up a string that is passed to VFP, just like you would execute from within VFP.

>>
>>You will need to set CommandType for the command object.
>>
>>For example,
>>
>>oleCmd.CommandType = CommandType.StoredProcedure
>
>When I originally tried that (and I just tried it again), it (the ExecuteNonQuery() ) fails with a "Unrecognized command verb." If I don't include it, it seems to work (except for the return value). I've checked the ID table and the table PK is definitely being incremented.
-----------------------------------------

Cathi Gero, CPA
Prenia Software & Consulting Services
Microsoft C# / .NET MVP
Mere Mortals for .NET MVP
cgero@prenia.com
www.prenia.com
Weblog: blogs.prenia.com/cathi
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform