Identify Update Files

Identify (perhaps, list) the files you need to include in the update. You will need a list of update files when you run the Copy Files Update Builder option to copy files from your applicationís project directories to the update directory.

You should know which of your applicationís unique files (for example, database, table, index, report, etc. files) you have changed in some way as you were modifying your application.

To help you identify the system tables and indexes that you might need to include in an update, the following table lists the VPME system tables that are distributed with VPME applications. This table describes how each system table gets updated, or changed, as you work in VPM Enterprise. If you have taken action that updated a system table while you were modifying your application, that system table should be included in the application update.

Table Name

How is the table updated?

SDATA.DBC

Updated through VPMís Data Builder as well as the applicationís Data Manager when a system table is added or removed from the database or the structure of a system table is modified.

SDATA_V.DBC

Updated through VPMís Data Builder as well as the applicationís Data Manager when a system view is added or removed from the database or the structure of a system view is modified.

SDataAudit.DBF

Updated by the RI routine in the application where records are added, or records are deleted through the applicationís Audit Trail form or Data Manager as well as VPMís Data Builder.

SDataDDCK.DBF

Updated through VPMís Data Builder as well as the applicationís Data Manager when a Candidate Key definition is created, changed, or removed.

SDataDDD.DBF

Updated through VPMís Data Builder as well as the applicationís Data Manager when a database or cursoradapter library is created, added, or removed.

SDataDDDS.DBF

Updated through VPMís Data Builder as well as the applicationís Data Manager when a Data Source definition is created, changed, or removed.

SDataDDF.DBF

Updated through VPMís Data Builder as well as the applicationís Data Manager when a database or cursoradapter library is added or removed, a table, view, or cursoradapter is created, added, removed, its structure is changed, or a field property or Integrity is set.

SDataDDFH.DBF

Updated on the Help page for fields in VPMís Data Builder and the applicationís Data Manager as well as when the F3 editing form is brought up from a data-entry form by pressing Alt+F3.

SDataDDGK.DBF

Updated when records are added to a table, view, or cursoradapter for which the generation of a key field value has been set up in VPMís Data Builder as well as the applicationís Data Manager.

SDataDDIT.DBF

Updated through VPMís Data Builder as well as the applicationís Data Manager when a database is added, a database or cursoradapter library is removed, a table is created, added, or removed, or a view or cursoradapter tag definition is created, modified, or removed.

SDataDDSI.DBF

Updated on the Integrity page for fields in VPMís Data Builder and the applicationís Data Manager when the Set Integrity definition is created, changed, or removed.

SDataDDTV.DBF

Updated through VPMís Data Builder as well as the applicationís Data Manager when a database or cursoradapter library is added or removed, a table, view, or cursoradapter is created, added, or removed, or a table/view/cursoradapter property is set.

SDataErrors.DBF

Updated when the error handler adds records, or records are deleted through the applicationís Errors form or Data Manager as well as VPMís Data Builder.

SDataUsers.DBF

Updated through the applicationís Users and Passwords forms.

SVPM.DBC

Updated through VPMís Data Builder as well as the applicationís Data Manager when a system table is added or removed from the database or the structure of a system table is modified.

SVPM_V.DBC

Updated through VPMís Data Builder as well as the applicationís Data Manager when a system view is added or removed from the database or the structure of a system view is modified.

SVPMActivity.DBF

Updated at various points in the application where records are added, or records are deleted through the applicationís Activity form or Data Manager as well as VPMís Data Builder.

SVPMAdminTools1.DBF

Updated through VPMís Options/Admin Tools Selection form. Table is built into EXE so is not distributed.

SVPMAdminTools2.DBF

Updated through the applicationís Admin Tools form.

SVPMApplicationControls.DBF

Updated through VPMís Data Builder as well as the applicationís Data Manager when its structure is changed.

SVPMApplicationDefinition.APD

Updated through VPMís Options/Developer Info form (Start and Completed fields), Options/Environment form, Options/Identification form (Name and Version fields), Options/Logo and Icons form, as well as the applicationís Admin/Environment form, Admin/Directories form, and Admin/Security/Password Setup form.

SVPMConditionDetail.DBF

Updated through the Condition Builder form (Filter, Locate, and Group Delete toolbar controls as well as For and While controls on Report Setup form).

SVPMConditionFields.DBF

Updated through the Condition Field List Builder and Report Setup Options form.

SVPMConditions.DBF

Updated through the Condition Builder form (Filter, Locate, and Group Delete toolbar controls and For and While controls on Report Setup form).

SVPMControlGroupDefinitions.DBF

Updated through VPMís Tools/Security Builder/Control Group Definitions form.

SVPMControlPermissionGroups.DBF

Updated through the applicationís Control Permission Groups form.

SVPMControlSecurityForms.DBF

Updated when security tables are built through the VPMís Tools/Security Builder/Control Security Forms form.

SVPMDDFP.DBF

Updated on the Integrity page for fields in VPMís Data Builder and the applicationís Data Manager through the Picklist Builder button when a Picklist definition is created, changed, or removed.

SVPMFieldPermissionGroups.DBF

Updated through the applicationís Field Permission Groups form.

SVPMLanguages.DBF

Updated through VPMís Language Builder as well as the applicationís Language Manager.

SVPMMenuOptions.DBF

Updated through VPMís Tools/Security Builder/Load Menu Option Table form.

SVPMMenuPermissionGroups.DBF

Updated through the applicationís Menu Permission Groups form.

SVPMMessages.DBF

Updated through VPMís Message Builder and the applicationís Message Manager.

SVPMMessageTranslations.DBF

Updated through the applicationís Message Translations form.

SVPMReports.DBF

Updated through VPMís Report Builder and the applicationís Report Manager.

SVPMSecurityData.DBF

Updated when Field, Menu, and Control Permissions are set for individuals as well as groups.

SVPMStrings.DBF

Updated through VPMís String Builder as well as the applicationís String Manager.

SVPMStringTranslations.DBF

Updated through the applicationís String Translations form.

SVPMSystemControls.DBF

Updated through VPMís Data Builder as well as the applicationís Data Manager when its structure is changed.

 

More:

Building an EXE