Devart Forums

Posted: **Tue 22 May 2012 13:57**

Hi,

I want to use the new "TDADataSetOptions.SetEmptyStrToNull" property, described in:
What's new: 15-Sep-11 New Features in SQL Server Data Access Components 6.00
In my actual SDAC 6.1.6 I cannot see this property - why?

Stefan

Posted: **Wed 23 May 2012 07:33**

Hello,

You can use the SetEmptyStrToNull option of the TMSQuery, TMSTable, and TMSStoredProc components. Here is a code example:

Code: Select all

MSQuery1.Options.SetEmptyStrToNull := True;
MSTable1.Options.SetEmptyStrToNull := True;
MSStoredProc1.Options.SetEmptyStrToNull := True;

Posted: **Wed 23 May 2012 13:09**

Sorry, my fault. I used "TDADataSetOptions" (I use DAC and SDAC in one project) instead of TMSQuery.
Thank you for help.

Stefan

Posted: **Wed 23 May 2012 14:16**

Feel free to contact us if you have any further questions about SDAC.

Devart Forums

SetEmptyStrToNull

SetEmptyStrToNull

Re: SetEmptyStrToNull

Re: SetEmptyStrToNull

Re: SetEmptyStrToNull