⚠️ 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 Structure

Distributing Your New Front End

SSW Data PRO! SSW Data PRO!

How It Works

'SSW Data PRO!' SQL assumes you have divided your database into a front end (containing the forms, modules and the user interface in general) and a backend SQL Server (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.

Objects added to the front end

Tables:

    zsDPDataChange

    zsDPVersionDataPRO

Modules:

    basSSW1_OpenDialog_aGetFileName_v6

    basSSWDataPROUpgradeNoReference_v1

Macro:

    SSWSampleAutoExec_v1

Objects added to the backend

Tables:

    _zsDataVersion

 

Previous page Next page

SSW