Home » Forums » PHP OpenBiz 2.X Forums » Developer Help

Updating Datetime field

Submitted by andrewseagull on Tue, 10/06/2009 - 03:35.

It looks like there is an issue with updating datatime type fields that initially have some value setting them to no value. I verified it with baseapp and those datetime fields that were set to "" are not included in "update" statement.

-Andrew

‹ BizForm Link attribute It's impossible to list all items ›
#1Submitted by support on Thu, 10/08/2009 - 04:26.

Thanks Andrew to detecting

Thanks Andrew to detecting it. Will commit it to SVN.

- support
#2Submitted by andrewseagull on Wed, 10/07/2009 - 17:41.

The problem is with line 120

The problem is with line 120 in BizDataObj_SQLHelper.php.

Original line is the following:

         if ($fldobj->m_Value == "" && ($fldobj->m_Type == "Date" || $fldobj->m_Type == "Datetime"))

which should be changed to:

         if (($fldobj->m_Value == "" && $fldobj->m_OldValue == "") && ($fldobj->m_Type == "Date" || $fldobj->m_Type == "Datetime"))

Thanks,

Andrew
#3Submitted by support on Wed, 10/07/2009 - 06:13.

What is the update SQL like

What is the update SQL like with datetime columns? Thanks.

- support