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