It sounds a bit like my old problem.... Take a look at
"http://forums.netdynamics.com/go/forums?cmd=article&group=netdynamics.public.support.nd4.talk&item=14712"
This is an issue at the EU support ("ref: Issue 3311 - update ignored", still
open, as far as I know) that has been passed along to the States.
If it's the same problem, you can expect to have it in ND 5.0 as well (at least
is wasn't fixed in 5.0 beta).
Cheers,
/JMK
"Pham, Tuan A" wrote:
> > Hi,
> > I wanted to test overrid an entire Update query without using default
> > functions. It gave errors:
> >
> > MyProject.pgTableUpdate.FAiled Update!!!: Unexpected Exception
> > (java.lang.NullPointerException) caught in
> > pgTableUpdate(a MyProject.pgTableUpdate) [Parent: 'MyProject'(a
> > MyProject.MyProject)]. Top of stack:
> > |java.lang.NullPointerException at
> > MyProject.pgTableUpdate.Update_onWebEvent(pgTableUpdate.java:42) at
> >
> > The same SQL statement runs OK in ISQL. Do you know what problem it could
> > be ?
> >
> > Thanks for any help.
> > Tuan Pham
> >
> > Following is the code:
> >
> > public int Update_onWebEvent(CSpWebEvent event)
> > {
> > CSpMultiSQL doTableUpdate =
> > (CSpMultiSQL)
> > CSpider.getDataObject("doTableUpdate");
> > int command = PROCEED;
> > try
> > {
> > // Please note that the following technique
> > could be used on any
> > // Multi-SQL Data Object regardless of its type
> > doTableUpdate .setSqlTextOverrideUpdate
> > (CSpSQLObject.FULL_TEXT_OVERRIDE);
> >
> > String sql = "UPDATE table_a SET col1 = 'A' WHERE
> > row_id = 1000";
> > doTableUpdate .setSqlTextFullUpdate (sql);
> > command = doTableUpdate .executeUpdate ();
> > if ((command == PROCEED) && doTableUpdate .succeeded
> > ())
> > {
> > command = load ();
> > }
> > }
> > catch (Exception ex)
> > {
> >
> > CSpLog.exception (this, "FAiled Update!!!", ex);
> > }
> > finally
> > {
> > // Always restore the text override so as not
> > to create side effects
> > doTableUpdate .setSqlTextOverrideUpdate
> > (CSpSQLObject.NO_TEXT_OVERRIDE);
> > doTableUpdate .setSqlTextFullUpdate ("");
> > }
> >
> > return (command);
> > }
_________________________________________________________________________
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]
