fyi, there was no bug logged for this problem. I logged a bug with id: 7197.
Untill this issue is resolved please use executeImmediate().
lidia
Mary Hill wrote:
> This has been reported to ND. This problem occurs with updates also. You
> need to do a dummy setvalue on one of your fields to get the insert to work.
> The setValue will not take effect since you are doing an override, but
> something in the setValue is triggering that an insert needs to be done.
>
> For an update you also have to do a setValue on a "NON-KEY" field. If you do
> the setValue for a key it will get ignored also.
>
> Curt Springer wrote:
>
> > 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]
>
> --
> --------------------------------------------------------
> Mary Hill 2919 Taubman Library
> [EMAIL PROTECTED] 1135 E. Catherine
> University of Michigan Ann Arbor, MI
> Med School Information Systems 48109-0726
> 734-763-6752
>
> _________________________________________________________________________
>
> 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]
