Increasing Edit Record Speed

Increasing Speed of Moving Between Fields

You can increase the speed at which a user can tab from field to field by doing the following:

·       Field Validation

·       If you don’t need to validate a field, put an asterisk in the field control’s Valid method. This will prevent the default validation code from running in the control class Valid event.

·       Field Security

·       If you don’t need Field Security for a field, in the Form Designer blank-out the cCSControlID property of the field’s control.

Increasing Speed of Save Record

When a user saves a record that has been edited on a form, the VPM Enterprise Audit Trail routine adds a record for every field that has been changed on the form to the Audit Trail table. Consequently, the Audit Trail feature slows down the saving of an edited record. You can increase the speed at which records are saved by doing one of the following:

·       Turn off the Audit Trail for the Application

·              If you don’t need the Audit Trail for any forms in an application, you can turn it off on the Admin Tools form reached from the Security popup on application’s Admin menu.

·       Turn off the Audit Trail for Changes on Selected Forms

·              If you need the Audit Trail for some forms but not for others, don’t turn the Audit Trail off on the Admin Tools form. Instead, turn off the Audit Trail for forms that don’t need it by setting the forms’ lNoChangeAuditTrail property to .T..

Note: This does not turn off the Audit Trail for deletions and additions for a form. There are lNoDeleteAuditTrail and lNoNewAuditTrail properties that control the creation of Audit Trail records for those functions.

·       Turn off the Audit Trail for Selected Fields

·              If you need the Audit Trail for some fields on a form but not for others, you turn can off the Audit Trail for fields that don’t need it by unchecking the fields’ Audit Trail field property checkboxes in the application’s Data Manager form.

More:

Increasing New Record Speed