SSW-Data PRO!

⚠️ This page has been archived

✅ New page with updated info: ssw.com.au

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:

SSWSampleAutoExec_v1

Objects added to the backend

Tables:

_zsDataVersion

Macros:

Autoexec