HOME PAGE
Introduction
How It Works
Assumptions
Getting started
First Time Use
Setup
Tutorial
Changing Data
Data Structure
Data
Relationship
Index
Comments
Distributing Your New Front End
Data PRO Links
|
|
How It Works
'SSW Data PRO!' assumes you have divided your database into a front end
(containing the forms, modules and the user interface in general) and a backend
(containing the data tables). The front end is typically located on a
workstation, while the backend is on a shared network drive.
In order to be able to automatically upgrade the backend via the front end, the
following objects will be added to the databases. These tables will ensure that
the data structure changes are logged and that the front end has a means of
checking whether a backend is out-of-date.
More info: http://www.ssw.com.au/ssw/KB/KB.asp?KBID=Q197286
Objects added to the front end
Tables:
-
zsDPVersionDataPRO
-
zsDPDataChange
-
zsDPDataChangeRelationshipFields
-
zsDPDataChangeIndexFields
-
zsDPDataChangeModifyFieldProperties
Relationships:
-
zsDPDataChangeRelationshipFields.ChangeID - zsDPDataChange.ChangeID
-
zsDPDataChangeIndexFields.ChangeID - zsDPDataChange.ChangeID
-
zsDPDataChangeModifyFieldProperties.ChangeID - zsDPDataChange.ChangeID
Modules:
-
basSSW1_OpenDialog_aGetFileName_v6
-
basSSWDataPROUpgradeNoReference_v1
Macro:
|
Objects added to the backend
Tables:
Macros:
|
|