Hello,
I try to call a stored procedure to insert data into a database.
When I call the stored procedure through Telerik Data Access, the insertion is never performed.
Trace with SQL Server Profiler
RPC:Completed => exec [dbo].[CreatePerson] @CivilityId=2,@FirstName=N'Sandro',@LastName=N'00000000-0000-0000-0000-000000000000',@BirthDate='2015-06-29 22:03:30.287',@ProfessionId=1,@MobilePhone=N'06-01-18-12-18',@EmailAddress=N'tape@ici.com',@Password=N'2usaoT3IHoOkOjilIT/8RQ==',@Culture=N'fr-FR'
When I call the stored procedure directly from Microsoft SQL Server Management Studio with the same parameters, the insertion is done well.
I note that the id placed in auto-increment jumped a notch (so on inserting missed telerik).
What's wrong ?
thank you in advance
Sandra