Hi,

I am trying to do a simple insert using  a CspInsert dataobject :
I am really surprised why is it not working with setSqlTextFull whereas
it works fine if I do CSpDataObject.setValue( ) for the data fields
before executing. It does not give any error and happily goes into the
CspDataObject.succeeded( ) loop but actually not inserting in the table.
Has anyone faced this problem before ?

CSpInsert doLabTestCell = (CSpInsert) CSpider.getDataObject
("doLabTestCell");
strInsert = "INSERT INTO TABLE (Col1, Col2, Col3 ) values(19990330, '01'
, null )";
doLabTestCell.setSqlTextOverride(CSpSQLObject.FULL_TEXT_OVERRIDE);
doLabTestCell.setSqlTextFull(strInsert);
doLabTestCell.execute();


Thanks
Deepak

_________________________________________________________________________

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]

Reply via email to