hey guys,

i can't do what are you talking about!

i have this part of a ququerynd i can't pass the parameter through it (it's a date).

"select coalesce(SUM(case when Dat_Echeance=? then 0 else Taux * Qte_Devise end ) ,0) AS Qte_Ecrs_Tx FROM Wrk_Agreg_Faible

WHERE Id_Tranche_Rec_Dur_Init IS NOT NULL

AND Cod_Famille_Taux <> 'S' -- hors produits structurés

GROUP BY Dat_Mvt_Ecrs

,Cod_Type_Tcn_Transcod

,Cod_Devise

,Cod_Famille_Taux

,Id_Fam_Tranche_Rec

,Id_Tranche_Rec_Dur_Init

,Cod_Emet

,Lib_Zone_Geo_Mec

,Id_Categorie_Not;

"

the error is:

"It is not possible to extract parameters from the SQL command.

The provider can prevent analyze the parameter information from the command.

In this case, use the access mode "SQL command from variable" in which the

entire SQL command is stored in a variable.

violation of authorization or other non-specific error (Microsoft SQL

Server Native Client 10.0)"

thank you for rsponding me.