SetEmptyStrToNull

[Aufhauser]

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

[AndreyZ]

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;

[Aufhauser]

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

Stefan

[AndreyZ]

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