Not Null date, but I need to pass the empty value.

QuestionsNot Null date, but I need to pass the empty value.
Thales Faco asked 5 years ago

Hi Abu!

I have a SQL database that I can’t change the configurations(DML), beacause the DBA do not permit.

We Have a Collumn Date called C7_YEMBARQ in this Database, the data can be empty, but not NULL.

I can’t register EMPTY DATA in PHP GRID, beacause the data ALWAYS GO NULL to the database.

My collumn configuration is like that:

$col = array();
$col[“title”] = “DT. EMBARQUE”; // caption of column
$col[“name”] = “C7_YEMBARQ”;
$col[“editable”] = true;
$col[“width”] = “110”;
$col[“formatter”] = “datetime”; // format as date
$col[“editrules”] = array(“required”=>false);
$col[“formatoptions”] = array(“srcformat”=>’Ymd’,”newformat”=>’d/m/Y’,”dateformat”=>’d/m/Y’);
$myfieldval .= ‘,’. $col[“name”];
$myfieldnam .= ‘,’. $col[“title”];
$cols[] = $col;

Can you help me?

 

Couldn’t execute query. SQLState: 23000 Error Code: 515 Message: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Cannot insert the value NULL into column ‘C7_YEMBARQ’, table ‘PRODUCAO.dbo.SC7010’; column does not allow nulls. UPDATE fails. SQLState: 01000 Error Code: 3621 Message: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]The statement has been terminated. – UPDATE SC7010 SET C7_YEMBARQ=NULL,C7_YPREFAT=N’20200214′,C7_YPREMBA=N’20191111′,C7_YFUPDT1=N’20191111′,C7_YFUPHR1=N’ ‘,C7_YFUPOB1=N’ ‘,C7_YFUPDT2=N’20191111′,C7_YFUPHR2=N’ ‘,C7_YFUPOB2=N’ ‘,C7_YFUPDT3=N’20191111′,C7_YFUPHR3=N’ ‘,C7_YFUPOB3=N’ ‘,C7_YFUPDT4=N’20191111′,C7_YFUPHR4=N’ ‘,C7_YFUPOB4=N’ ‘,C7_YFUPDT5=N’20191111′,C7_YFUPHR5=N’ ‘,C7_YFUPOB5=N’ ‘,C7_YFUPDT6=N’20191111′,C7_YFUPHR6=N’ ‘,C7_YFUPOB6=N’ ‘ WHERE R_E_C_N_O_ IN (‘179482’)

2 Answers
Abu Ghufran Staff answered 5 years ago

I’m emailing you updated build. After update, If you set following with date column setting, it will insert empty string instead of NULL.

$col[“isnull”] = false;

_________________________
Abu Ghufran - Dev Team
Grid 4 PHP Framework
 
Thales answered 5 years ago

Abu,

 

Thank you one more time!

Works perfect.

 

See Ya.

Your Answer

7 + 0 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?