The Servoy Beginner's Handbook

by



Servoy Training & Consulting
San Francisco, CA, USA
Website:   
www.mcgilly.com
E-mail:      
info@mcgilly.com

v 1.4, last updated November, 2007
Copyright 2006, All Rights Reserved


 

Below is the full Table of Contents of the Servoy Beginner's Handbook, with some items linked to actual content to give you a preview. The complete handbook is 121 pages long. You can download it now in a fully-bookmarked PDF format for just $40 US.

 

Table of Contents
Highlighted items are new or revised since from previous edition.
Throughout the handbook, text that has been revised is also highlighted

 

Introduction. 8

How to Learn Servoy. 9

Available Resources. 9

Suggested Learning Path. 10

Getting the Most Out of the Servoy Forum.. 11

Do I have to know SQL to use Servoy?. 12

Overview of Servoy’s Architecture. 14

Connecting to SQL Anywhere Databases. 16

About SQL Anywhere. 16

Connecting to the Repository. 17

Troubleshooting Connecting to SQL Anywhere: 18

Creating and Connecting to a New Database. 20

How can I see my raw data?. 21

Where is my database schema stored? In Servoy or in the DBMS?. 22

Tables and columns. 22

Sequences. 23

Everything You Wanted To Know About Foundsets. 24

What is a foundset?. 24

How do foundsets work?. 26

How to programmatically navigate a foundset 27

Looping Through a Foundset containing 200+ Records. 30

How Adds, Edits & Deletes Affect Foundsets. 31

Caching & Data Broadcasting. 32

Containers: Overview of Vars, Dataproviders, Calcs and Elements. 32

Dataproviders. 32

How to reference dataproviders in forms & methods. 36

Referring to Dataproviders in Related Records. 37

Elements. 42

The Controller and Currentcontroller objects. 43

Controller Object 43

Currentcontroller Object 44

How & When Data Changes Are Saved. 45

Servoy's Default Saving Behavior 45

Overriding Servoy's Default Saving Behavior 47

Reverting Records Before Saving to the DB. 48

How to use Transactions. 48

Validating a Record Before Saving. 49

Overview of Data Validation. 49

Field-level Validation using Field Events. 50

Field-Level Validation: Column-based. 52

Record-Level Validation Using Form Events. 58

Record-Level Validation Using Table Events. 59

Controlling the UI for Data Validation Purposes.