Kbase P135823: Getting error 91 when trying to update or add record using SmartObjects
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/28/2008 |
|
Status: Unverified
SYMPTOM(s):
Getting error 91 when trying to update or add record using SmartObjects
** No <file-name> record is available. (91)
No RowObjUpd record is available. (91)
FACT(s) (Environment):
10.1C
All Supported Operating Systems
CHANGE:
Migrated from 9.1x to 10.1C
CAUSE:
Client validation code is using RowObjUpd
FIX:
Replace the RowObjUpd with RowObject in the ClientNameValidate where the error happens.
The <fieldname>validate and RowObjectValidate hooks are client side hooks for validation of the RowObject table. These hooks fire on save even if data has not been committed.
The pre- post- hooks are server side hooks for validation of the RowObjUpd table which is created when data is committed, either on save (if AutoCommit) or on commit.
It has never been ok to use RowObjUpd for client side validation, but the record is created before the submitValidation and has apparently been available at this stage in 9.x.
There's no rule that says the RowObjUpd table cannot be used in client side validation, for example to check the before values, but you have to ensure that you find the right one and also check for availability. (There are two RowObjUpd records for an update.)