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.comwww.prenia.comWeblog: blogs.prenia.com/cathi