voilà j'ai trouvé quelque chose :
la première fois ça marche, et le profiler de SQL me done :
exec InsertProspect @ProspCompany=N'test 19',@ProspFirstName=N'',@ProspLastName=N'',@ProspAddress1=N'',@ProspAddress2=N'',@ProspZipCode=N'',@ProspCity=N'AAA M 2',@ProspCountry=N'AAA M3',@ProspMessage=N'',@ProspPhone1=N'',@ProspPhone2=N'',@ProspMail1=N'',@ProspMail2=N'',@ProspPseudo=N'',@ProspMDP=N''
ensuite ça ne marche plus,
le profiler me donne :
exec InsertProspect @ProspCompany=N'test 19',@ProspFirstName=N'',@ProspLastName=N'',@ProspAddress1=N'',@ProspAddress2=N'',@ProspZipCode=N'',@ProspCity=N'AAA M 2',@ProspCountry=N'AAA M3',@ProspMessage=N'',@ProspPhone1=N'',@ProspPhone2=N'',@ProspMail1=N'',@ProspMail2=N'',@ProspPseudo=N'',@ProspMDP=N'',@ProspCompany=N'test 19',@ProspFirstName=N'',@ProspLastName=N'',@ProspAddress1=N'',@ProspAddress2=N'',@ProspZipCode=N'',@ProspCity=N'AAA M 3',@ProspCountry=N'AAA M3',@ProspMessage=N'',@ProspPhone1=N'',@ProspPhone2=N'',@ProspMail1=N'',@ProspMail2=N'',@ProspPseudo=N'',@ProspMDP=N''
il faut que je réinitialise les paramètres à zéro quelque part !!!!
Partager