Kbase P86809: Error 132 when copying a record using the smartToolbar
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/07/2004 |
|
Status: Unverified
SYMPTOM(s):
Error 132 when copying a record using the smartToolbar
The create function works fine
There is an unique key in the table that is assigned in the CREATE trigger, in the same way as Cust-Num for customer in the sports DB.
** <file-name> already exists with <field/value...>. (132)
CAUSE:
The unique key is set as updatable in the SDO so when a record is copied the BUFFER-COPY that follows the CREATE statement override the new assigned ID with the one coming from the old record
FIX:
Make the field not updatable in the SDO in order to do this:
1) Open the SDO object
2) Open the property sheet
3) Click the 'Fields' button and locate the fiedl. Un-check the updatable checkbox for the field.
4) Save the SDO