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

Ban Data StartBan Data PRO

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

Previous button Next button

Footer SSW