Hi
I have a situation like this
A data object for updating
CSpUpdate dobUpdObj = (CSpUpdate) CSpider.getDataObject("doUpdObj1");
dobUpdObj.clearDynamicCriteria();
dobUpdObj.addDynamicCriterion("CODE",CSpCriteriaSQLObject.EQUAL_TO_STR_OPERATOR,Code);
dobUpdObj.addDynamicCriterion("ID",CSpCriteriaSQLObject.EQUAL_TO_STR_OPERATOR,this.getDisplayFieldValue("ID"));
dobUpdObj.setValue("Column_1",new CSpString(""));
I would like to set the value for column "Column_1" to NULL VALUE in the
database, there are other fields in dataobject "doUpdObj1" ,their values should
not be changed
only Column_1 should be set to "Null" value
if i use
dobUpdImgTour.setValue("Column_1",new CSpString(""));
(or)
dobUpdImgTour.setValue("Column_1",new CSpNull());
the generated Update statement from the Logviewer is as follows
" UPDATE TABLE SET MAINT_BY = 'USER', MAINT_ON = TO_DATE('1999/06/07
17:47:50','YYYY/MM/DD HH24:MI:SS') WHERE (((CODE = 'ABCD')) AND (ID = 391))"
where the Column_1 itself does not appear.
Any suggestions are welcome.The database used is Oracle.
rgds
S.Puru
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
