Page History
...
You can edit an existing row of data, insert a new row of data or delete a row of data from the Results window.
This editing facility can be put to many different uses. Some of these are:
...
- because all the business rules and triggers are defined in the LANSA Repository. LANSA Client does not allow anyone to make changes which violate these rules.
- if errors are found in the data, it will be rejected and the appropriate error messages will be displayed from the LANSA Repository.
- before data is accepted, the LANSA Repository determines if the user has the appropriate authority to edit the data.
The editing facility cannot be used when:
- grouping conditions have been applied to the results.
- the query includes more than one file.
- the Allow Inserts/Updates option has not been enabled using the LANSA Client Administrator.
- editing has not been authorized using the Output Options command.
| Note |
|---|
| Note: The Edit Row dialog will only allow you to edit up to 32767 characters per field. If a field is longer than 32767 characters, the entry box for the field will be set to read only. |
| Note |
|---|
| Note: When you wish to, set SQLNULL value to an RDMLX field with an ASQN input attribute. You must type '*SQLNULL as the field value. |