Has this been reported as a bug? If not, should be. Sounds as though ND
is looking for evidence of 'setValue' having been executed on at least one
column. But in the case of a full override, it ought to assume that you
know what you're doing, and just send the sql.
-- Curt Springer, Team ND
At 08:19 PM 6/14/99 +0530, Deepak Kumar Adhikary wrote:
>In the CPService Log there is no mention whatsoever for the 2 lines
>containing the override statements.
>Then it continues to give the following :
>
>CPService TestLtrs.doLabTestCellIns:constructDefaultInsertDBRequest: No
>values for 'doLabTestCellIns' INSERT query
>CPService TestLtrs.doLabTestCellIns:execute: Nothing to execute for
>'doLabTestCellIns'. Indicate default success
>CPService TestLtrs.pg1: doLabTestReqUpd executed successfully ( What I
>had given is CspLog.send)
>
>It does not seem to recognize the explicit Sql statement given . This
>was also the response I got from another person. It was the similar
>situation there too. This seems to be a bug with ND4.1.3 . I learnt it
>rather the hard way after spending so much time on it. In fact this was
>the reason why my CSP transaction was not working which I had put in one
>of my earlier mails. There seems no way out than to adopt the good old
>CSpDataObject.setValue( field).
>
>Deepak
>
>
> -----Original Message-----
> From: Curt Springer
>[mailto:[EMAIL PROTECTED]]
> Sent: Monday, June 14, 1999 7:58 PM
> To:
>[EMAIL PROTECTED]
> Subject: Re: [ND] Simple CSPInsert DataObject not
>working with SqlTextOverride !!!
>
> 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]
>
_________________________________________________________________________
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]
