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]
