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]
