| Superbase NG Programmer's Guide | ||
|---|---|---|
 | ||
Superbase NG Programmer's Guide
Getting to Grips with the SIMPOL Language
Copyright © 2001-2017 Superbase Software Limited
All rights reserved. The programs and documentation in this book are not guaranteed to be without defect, nor are they declared to be fit for any specific purpose other than instruction in the use of the programming language SIMPOL. It is entirely possible (though not probable) that use of any sample program code in this book could reformat your hard disk, disable your computer forever, fry your dog in a microwave oven, and even cause a computer virus to infect you by touching the keyboard, though none of these things is terribly likely (after all, almost anything is possible). It is just that most things are extremely improbable.
| Revision History | ||
|---|---|---|
| Revision 0.25 | 2017-04-22 | nr |
| Updated the copyright year. Added documentation for the CAST operator in SQL92. Significantly reworked and extended the documentation of the comparison between Superbase Basic Language functions and their equivalents in SIMPOL. | ||
| Revision 0.24 | 2016-03-29 | nr |
| Modified the name Papatuo Holdings Limited to Superbase Software Limited. Made various changes related to the use of Superbase NG as the overall product name and SIMPOL as the language name. | ||
| Revision 0.23 | 2014-03-20 | nr |
| Added section at the start of the Using Reports in SIMPOL chapter about using the sql1.sml library. Moved the SQL92 information to a more prominent location and added cross-references to it. Added the information about the new events and other properties for the quickreport1 object. Added a section about enhanced Quick Report output using the new events, plus additional information about using the new summarize capability. | ||
| Revision 0.22 | 2013-12-02 | nr |
| Modified reference to Simpol Limited to be Papatuo Holdings Limited. Added 2013, 2014 copyright years. | ||
| Revision 0.21 | 2012-01-31 | nr |
| Updated the list of supplied libraries with the recent additions. | ||
| Revision 0.20 | 2011-04-27 | nr |
| Updated the list of supplied libraries with the latest set. Improved the part on programming with the dataform1 family of types and extended it to cover the application framework, the printable forms, and the three report engines. | ||
| Revision 0.19 | 2010-09-23 | nr |
| Modified the list of supplied libraries with the latest set. Updated certain aspects of the documentation to reflect current practice. Added the chapter on programming with the dataform1 family of types. | ||
| Revision 0.18 | 2010-03-12 | nr |
| Updated the copyright year. | ||
| Revision 0.17 | 2009-01-15 | nr |
| Updated the copyright year. | ||
| Revision 0.16 | 2007-08-01 | nr |
| Correction to all wxform sample programs to use a named error parameter in the wxform.new(). | ||
| Revision 0.15 | 2007-06-12 | nr |
| Correction to a sample program in the user-defined types section. | ||
| Revision 0.14 | 2007-05-10 | nr |
| Spelling fixes plus updates of the chapter covering conversion from SBL. | ||
| Revision 0.13 | 2007-01-08 | nr |
| Modified reference to RealBasics Limited to be Simpol Limited. Added 2007 copyright. | ||
| Revision 0.12 | 2006-05-10 | nr |
| Updated the chapter about wxWidgets to include common dialogs and the grid control. Rewrote the chapter about Common Dialogs to be now based on the wxWidgets functions. | ||
| Revision 0.11 | 2006-03-07 | nr |
| Removed the chapters about window1 and form1 and added the chapter about wxWidgets. Added chapter about pre-programmed SIMPOL-language libraries. | ||
| Revision 0.10 | 2004-08-30 | nr |
| Added the chapter about moving from SBL to SIMPOL. | ||
| Revision 0.09 | 2004-04-28 | nr |
| Split the Programmer's Guide and the Reference Guide into two separate books. Added the majority of missing sections to the existing portions of the book. Added the chapters about the windows, forms, common dialogs, and message boxes. Minor fixes in other areas. | ||
| Revision 0.08 | 2003-09-04 | nr |
| Added the lock1 type, AND, OR, and XOR operators, the anyvalue type, additional narrative. | ||
| Revision 0.07 | 2003-01-13 | nr |
| Added the array type, .compress1, .decompress1, various type tags, additional narrative. | ||
| Revision 0.06 | 2002-10-02 | nr |
| Added the Superbase Micro Engine new types and wrote the content of the Variables chapter. | ||
| Revision 0.05 | 2002-09-30 | nr |
| Added the section covering the Superbase Micro Engine types. | ||
| Revision 0.04 | 2002-07-27 | nr |
| Added some more detail in the basic document and redesigned into parts. | ||
| Revision 0.03 | 2002-05-20 | nr |
| Added the section on esf1 types and reworked the smpol-types to be based on includes. | ||
| Revision 0.02 | 2002-02-27 | nr |
| Added the section on grammar and modified the book to include the initial main documentation. | ||
| Revision 0.01 | 2001-12-05 | nr |
| Initial conversion of existing SIMPOL documentation into DocBook XML format. | ||
Table of Contents
- 1. Introduction
- I. Quick Start With SIMPOL
- II. SIMPOL Language Basics
- III. Web Server Applications — CGI, ISAPI, and FastCGI for Dynamic Web Content
- IV. Using Databases
- V. Calling SIMPOL Functions as DLL Calls
- VI. Working with Sockets
- VII. User-Interface Components
- VIII. Converting From SBL
- IX. Supplied SIMPOL-Language Libraries
- X. Programming Data-Aware Form Programs
List of Tables
- 12.1. Comparison of SBL file access commands to SIMPOL methods
- 20.1. Comparison of SBL key words to SIMPOL equivalents
- 20.2. Comparison of SBL commands and functions to SIMPOL equivalents
- 20.3.
- 20.4.
- 20.5.
- 21.1. Supplied SIMPOL-Language Libraries
- 22.1. dataform1
- 22.2. dataform1 Methods
- 22.3. printform1
- 22.4. report1 Types
- 22.5. report1 Functions
- 22.6. quickreport1 Types
- 22.7. quickreport1 Functions
- 22.8. graphicreport1 Types
- 22.9. graphicreport1 Functions
- 22.10. application Properties
- 22.11. appwindow Properties
- 23.1. dataform1 dring Types
- 25.1. onoutput Function Prototypes
- 26.1. The Functions in the Application Framework
List of Examples
- 15.1. SBL program calling SIMPOL function
- 16.1. Constants portion of the urlget program
- 16.2. Beginning of the
main()function of the urlget program - 16.3. Creating the socket connection in the urlget program
- 16.4. Beginning the TCP/IP conversation in the urlget program
- 16.5. Retrieving the header from the web server in the urlget program
- 16.6. Checking the response code in the web page header in the urlget program
- 16.7. Parsing the web page header in the urlget program
- 16.8. Retrieving the web page content in the urlget program
- 16.9. Returning the results to the user in the urlget program
- 18.1. Creating a Single wxwindow
- 18.2. Example of Creating Multiple Top-Level wxwindows
- 18.3. A Minimal Modal wxdialog Example
- 18.4. A Modal wxdialog
- 18.5. A Non-Modal wxdialog
- 18.6. A Modal wxdialog with Standard Buttons
- 18.7. A Modal wxdialog with Standard Buttons Using
uisyshelp.sml - 18.8. A wxmenu Example
- 22.1. Iterating Through Form Controls
- 23.1. Iterating Through dataform1 dring Properties
- 23.2. Iterating Through the Controls on Each Page of a dataform1