Rajneesh,
On a quick look, I can't find anything wrong with your approach.
Looking at the error (NullPonterException) I think the potential candidate
in your brief code is a typo in the DataObject name in this line:
CSpInsert mnInsert = (CSpInsert)CSpider.getDataObject("doMNInsert");
Aby
TeamND
-----Original Message-----
From: Rajneesh Garg [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 05, 2000 2:17 AM
To: [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>
Subject: [ND] Insertion Query and CSpValues
Hi there!
I am working on this project on ND5 with Oracle 8i as database. As a part of
work, I am required to insert user-input values into the database. These
values are to be inserted into different tables.
I am using semi-automatic mode of ND transaction for this purpose. As far as
my knowledge of ND API goes, it requires a CSpValue variable for the value.
However, the work requires calculation of a field value (a alphanumeric
string). I am not been able to convert this String value into CSpValue.
e.g.
We are asking the user user-name and password. Thus, we can have these in
CSpValue. However, while inserting into the table, we are giving it a unique
alphanumeric code, which we calculate while inserting.
We are using the code similar to following :
CSpInsert mnInsert = (CSpInsert)CSpider.getDataObject("doMNInsert");
mnInsert.setValue(0,NameFieldValue);
mnInsert.setValue(1,PasswordValue);
mnInsert.setValue(2,"CalculatedValue"); //Problem probably lies here
CSpTransaction tr = new CSpTransaction();
tr.addDataObject(mnInsert);
int command = tr.execute();
if(tr.succeeded() && (command != STOP_PROCESSING))
{
CSpHtml.write("Operation Successful...");
}
Upon compilation and running of project, when button is clicked, it throws
exception, saying :
* Unexpected exception from an event (java.lang.NullPointerException).
This is when invoking method btInsert2_onWebEvent for event
spider.event.CSpWebEvent[ON_WEB_EVENT,
Method=Project.pgTest.btInsert2_onWebEvent (btInsert2)] on
spider.visual.CSpButton:
*
spider.event.adapters.CSpPageEventAdapter.relayGenericEventProcessing:
Unexpected Exception (java.lang.NullPointerException) caught. Top of stack:
|java.lang.NullPointerException
Please help me out.
Is my approach right?
Thanx.
Rajneesh
_________________________________________________________________________
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]
