Kbase P34200: How to update a record interactively using 4GL?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
29/07/2003 |
|
Status: Unverified
GOAL:
How to update a record interactively using 4GL?
FIX:
FIND <Table Name> WHERE <Field Name> = <Field Data>.
Update <Table Name>.
Using Sports2000 database:
FIND customer WHERE custnum = 1.
Update customer.
If the above code is run against sports2000 database, the error "**FILL-IN Comments will not fit in FRAME in PROGRAM (4028)" will be displayed. The reason for getting this error is because the comments field in the customer table has a display format that will not fit in this default screen. In order to avoid this error, the comments field needs to be formatted using editor. If the field name to update is specified, all the field's name that need to be updated also need to be specified but, smaller display length fields do not need to be formatted using the editor. The example below demonstrates updating the customer name and the comments fields in the customer table in the sports2000 database.
FIND customer WHERE custnum = 1.
Update name
comments VIEW-AS EDITOR SIZE 60 BY 5.