Hello all,
I try to insert data into sql server table by calling sql stored procedure with parameters.
my problem is that when one of the parameters include single quote i got exception. and the process fail.
Here is an example of how i call the stoerd procedure:
EXEC [dbo].[spInsertIECMazkirotPermissionForm]
{ItemProperty:ID}
,'{ItemProperty:City}'
,'{ItemProperty:Street}'
if Street value is AB'C for example it fail.
* I have to use ItemProperty