Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Inserting a new record via OleDbCommand
Message
General information
Forum:
ASP.NET
Category:
ADO.NET
Miscellaneous
Thread ID:
00693070
Message ID:
00694262
Views:
24
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform