Well, the problem was ...
The same MultiSQL dataobject was being used for both display and update
purposes(Select & Update queries). For one of the data fields (static text)
of type NUMBER, I had applied a CHARACTER mask to get rid of decimal part.
Even though it was fetching the records for display, the update command was
getting failed and ND's message was not sufficient for me to fix this. Now I
am removing the decimal part of the display field in onBeforeDisplayEvent()
of that visual object.
I still wonder why ND considered this static field to be a potential
candidate for updation. The other static fields in the same 'repeated' were
ignored for updation.
Regds,
Krupesha
> -----Original Message-----
> From: Krupesha C
> Sent: Thursday, July 22, 1999 8:29 PM
> To: ND-Forum (E-mail)
> Subject: Could'nt retrieve RWDBColumn for insert
>
>
> I am trying to update the database using the ND built-in update
> facility. The values to be updated are taken from a combobox which is
> embedded in a repeated object and is the only field to be updated. The
> WHERE part for the updation-query is supplied by a hidden object which
> also lies in the repeated object. I am getting the error "Could'nt
> retrieve RWDBColumn for insert" whenever I try to update.
>
> The same page works fine in ND3. The problem was induced while ND4
> porting.
> There is no custom code associated with this page. Everything is done
> through ND built-in actions
>
>
> Here is the extract from log file:
> 328 Jul 22, 1999 at 18:17:31.823 Error 223 DSRdbmsService
> DSRdbmsService:c:932649330320:w:932649332221:Could'nt retrieve RWDBColumn
> for insert
> 329 Jul 22, 1999 at 18:17:31.552 Terse Debug Thread-10
> CPService faa.doAAdjFaaShip:c:932649332723:w:932649333502:execute:
> 'doAAdjFaaShip', request=[EC-[offset=0, count=1, whence=B],
> tableName=|faamgr.T_FAA_SHIP|,
> nameValues=(T_FAA_SHIP_QUANTITY=TO_CHAR(QUANTITY)), (STATUS=ENRICH),
> whereClause=|((faamgr.T_FAA_SHIP.STATUS <> 'READ') AND
> (faamgr.T_FAA_SHIP.REFERENCE_NO = 100053))|]
> 330 Jul 22, 1999 at 18:17:31.642 Terse Debug Thread-10
> CPService
> faa.doAAdjFaaShip:c:932649332723:w:932649333502:executeTheRequestAtTheDS:
> 'doAAdjFaaShip' executed SUCCESSFULLY.
> results=spider.database.CSpDBSQLResult [spider.database.CSpDBResultStatus
> [SUCCESS(0)], spider.database.CSpDBResultTable [rows=0, cols=0,
> firstRowIndex=0, data(no trim)=, spider.database.CSpDBResultSchema []]
>
>
> Thanks for your suggestions,
> Krupesha
_________________________________________________________________________
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]
