I have no idea, but have you turned on all levels of logging in the CP and
RDBMS service, and checked the log? You might find the answer there.
-- Curt Springer, Team ND
At 04:43 PM 6/14/99 +0530, Deepak Kumar Adhikary wrote:
>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]
>
_________________________________________________________________________
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]
