Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Associated statement is not prepared
Message
 
 
À
07/12/2012 15:44:39
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
01559065
Message ID:
01559090
Vues:
47
>>Can you see what is the command you're sending to the SQL Server by using SQL Server profiler?
>>
>>Try creating the variables then for your constant values, e.g.
>>
>>lnNull = null
>>
>>llIs = EditRec.lncSave
>>
>>etc.
>>
>>and pass them using ? syntax.
>
>I should add extras steps to replace something that was working before I removed 3 parameters and started getting the error?

I don't understand your question. What you have right now is incorrect and weird. I suggest to use simple variables for each parameter and pass them using

?m.Var1, ?m.Var2, ?m.Var3, etc.

to your stored procedure. Don't mix complex expressions, constants, etc. in one call.
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform