Home Dashboard Directory Help

Setting the NULL value into table field by OLEDB API by Sasha Sitnikov


 as Won't Fix Help for as Won't Fix

Sign in
to vote
Type: Bug
ID: 776974
Opened: 1/19/2013 11:21:17 AM
Access Restriction: Public
User(s) can reproduce this bug


I use VC++ and SQL Server CE 4.0. My task is to add a new row in the table setting NULL into one of the fields. I've read MSDN http://msdn.microsoft.com/ru-ru/library/windows/desktop/ms718116(v=vs.85).aspx:

if Value = N, Length = N, Status = Y, "Can be used to set the value of a column or parameter to NULL or to specify that the provider is to use the default value for an input or input/output parameter in a procedure."

Thus in the DBBINDING struct for the corresponding column a dwPart member should be the DBPART_STATUS and the status is DBSTATUS_S_ISNULL. But it doesn't work. If dwPart is DBPART_VALUE | DBPART_STATUS it will be work. I think it's incorrect behavior.

Also, there is discussion this issue:
Sign in to post a comment.
Posted by Microsoft on 2/18/2013 at 11:16 AM
    Thank you very much for your feedback on this issue. SQL Server compact edition is in deprecation mode with no new releases planned near future. Last release SQL CE 4.0SP1 (and earlier releases that are still in the support cycle) will continue to be supported through its lifecycle and Microsoft is committed to fix any major, production blocking issues found in these releases. At this point, we don't consider this issue to be in that category and hence we are closing this issue.
On the desktop/laptop deployments, migrating to SQL Server LocalDB/SQL Express is a possible option for many of the current users (http://msdn.microsoft.com/en-us/library/hh510202.aspx)

thanks for your support
Microsoft SQL Server
Sign in to post a workaround.
File Name Submitted By Submitted On File Size  
db_test.zip 1/19/2013 3 KB