Devart Forums

When using TMyStoredProc not pass an empty string not looking of the fact that the property MyStoredProc.Options.SetEmptyStrToNull default False. Version MyDAC 7.6.11.

Hello.

The SetEmptyStrToNull option affects only editing of the record set returned by TMyStoredProc. This option doesn't affect transferred parameters. If you want to transfer NULL as a parameter, you can do it using the TParam.Clear method, e.g.:
MyStoredProc1.ParamByName('param1').Clear;

My problem is just the opposite - I need to pass an empty string, not NULL. How can I do this?

Hello.

I couldn't reproduce the problem. I assign an empty string to the function parameter in the following way: And the function receives just the empty string, not NULL.