Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Calling an Update Stored Procedure.
Message
Information générale
Forum:
ASP.NET
Catégorie:
Visual FoxPro Toolkit pour .NET
Divers
Thread ID:
00674696
Message ID:
00674716
Vues:
18
Can you post your code?

I think your problem is just a syntax error versus a problem with ADO.NET.

>Okay, so calling SP with parameters to get data is no problem. Even using SQL pass-through to get data is no problem.
>
>Now I want to update some data. So I try to use a SP and just pass the data as parameters. I also create a SQL Update statement but I get teh same the same error message with both attempt. The error I get is system.IndexOutOfRangeException and Cannot find table 0. I drag the offending command to SQL Query Analyzer and the statement runs without a problem. I have SQL Trace on and no errors are displayed in the trace log. The SP runs to completion without any server errors. The error appears to be a VB.Net problem.
>
>Ideas?
-----------------------------------------

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