SetEmptyStrToNull

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Aufhauser
Posts: 56
Joined: Mon 21 Nov 2005 09:44
Location: Herzogenburg, Austria

SetEmptyStrToNull

Post by Aufhauser » 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

AndreyZ

Re: SetEmptyStrToNull

Post by AndreyZ » 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;

Aufhauser
Posts: 56
Joined: Mon 21 Nov 2005 09:44
Location: Herzogenburg, Austria

Re: SetEmptyStrToNull

Post by Aufhauser » 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

AndreyZ

Re: SetEmptyStrToNull

Post by AndreyZ » Wed 23 May 2012 14:16

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

Post Reply