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

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 776974 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 1/19/2013 11:21:17 AM
Access Restriction Public


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

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 (

thanks for your support
Microsoft SQL Server