Last updated June 2nd, 1999
Copyright © 1998-1999 Thomas Althammer. All rights
reserved.
No part of this document should be reproduced, distributed or altered without my
permission.
QG.ZIP (SW/CTD)
QG.ZIP is a simple sample that show how to use the Quick Graph with SAL. That is, that
graph is not linked directly to a datasource. You control the graph programmatically.
QG.ZIP also include two options for printing the graph, one using a .WMF file, and another
showing how to print the QG by linking it to detail lines in a .QRP report.
REGISTRY.ZIP (CTD) Version
1.2
This APL implements the most important API calls for accessing the windows registry and
encapsulates them in a functional class. It is easy to read/write strings, floats,
integers, booleans and binaries from/to the registry and to enumerate tree parts. The APL
can handle all keys (HKEY_CURRENT_USER, HKEY_LOCAL_MACHINE etc.).
RESIZE.ZIP (SW/CTD)
This source contains code for resizing and aligning controls whenever their parent form's
size changes. It is especially useful with child tables that are placed within form
windows. By deriving a control from the "cControlParent" class, it can change
its size whenever the form resizes. Even pushbuttons can stick to the right or bottom
border of the form. Very simple to use, SAL-code only, including sample form.
REPWINMULTIDETAIL.ZIP
(SW/CTD)
RepWin.zip contain two sample files showing "Reporting on multiple detail
tables". One using "row by row" another using a tabbed string. RepWin1.apt
& RepWin2.apt is written in clean SAL, valid for both SQLWindows & Centura Team
Developer.
SBCAPI.ZIP (SW/CTD)
Examples for interfacing with the C/API and doing CONNECT SERVER, UNLOAD, DEINSTALL,
DELETE,CREATE,CONNECT CURSOR, LOAD & DISCONNECT [16 bit version also: EXIT SQLBase
Engine & WINDOWS]. The sample code can be used to regularly backup your databases.
VB5SQL.ZIP (VB)
Sample files for interfacing Visual Basic 5 with the SQLBase C/API.
WIN16VER.ZIP (SW)
This sample file demonstrates getting the "real" Windows version,
differentiating between all know Windows platforms. Such information is not available when
using the standard "GetVersion( )" function from the Windows SDK. Take a look at
"How do I determine the version of the operating
system?" for further information.
Most of the downloads in the "Tools" section are supplied with their sources.
ABTUSR.ZIP
This program aborts all processes from a server for a specified database. The zip file
contains the executable, the .app file and a documentation file.
BACKUPS.ZIP
This contains programs to do snapshots or database and log backups based on an .INI file -
multiple databases and multiple servers. Uses the 'on server' specification. The zip file
contains the executable, the .app file and a documentation file.
BKPTIP.ZIP
This is a TeamTip about backup/restore strategies in PDF format. It discusses the options
available and gives sample scenarios showing tradeoffs of disk space used versus
up-to-the-second data recovery.
CHECKER.ZIP
Checker is a slick little tool that can be used in project where TOM is used. It lists all
files currently checked out and by whom, extremely useful to get a quick overview of the
current checked out status. "Browse off-line" is available and uses the
machine's registry to list checked out status, although limited to the user's files.
DBCOPY.ZIP
This SQLWindows app will deinstall a database, copy it to a new directory, then install it
again. The documentation is in the program.
DBMAINT.ZIP
This program allows you to do SQLBase maintenance (update statistics and check database)
based on an .INI file - multiple databases and multiple servers (uses the same .INI format
as the backups system described above). The ZIP file contains the SQLWindows/CTD source
code file with the documentation contained in the program.
INIUPD.ZIP
This program will replace whole sections of an INI fle with text defined in another file.
Multiple INI files and multiple sections to replace may be specified. Written to handle
the specific problem of updating multiple client SQL.INI files when using TCP/IP under NT
where the SERVERPATH keyword must be specified for each database on each server, but
written generically so *any* INI file may be updated. The zip file contains the
executable, the .app file and a documentation file.
ODBCTestX.ZIP
Get connected with ActiveX & ODBC. The feature set of ODBCTestX.OCX includes:
- Get a list of available ODBC data sources.
- Get a list of available tables in a data source.
- Get a list of available columns in a table.
- Get column information & content.
- Issue SQL commands.
- Get unedited ODBC error messages.
- Examine the rows and columns in the result sets.
- Read selected rows one at a time and copy the data.
- Connect to SQLBase by using ODBC from a CTD application.
Includes documentation (15 pages) in .HTM format and a CTD sample application.
QRP-DOC.ZIP
The Report Doctor repairs QRP-Files that had been destroyed by ReportWindows due to a bug
that had been introduced in the 1.5 version. Saving a QRP-File not via menu entry or
toolbar but when closing ReportWindows causes some invalid data being saved at the
beginning of the file. Report Doctor checks all QRPs in the specified directory, detects
corrupted ones and recovers selected files. It allows you to save the original version to
a backup folder.
REORG.ZIP
This zip file contains a sample of how to do a reorganize of your SQLBase database using
SQLTalk script files. A readme.txt file explains each of the sample files included.
CTDDEPLOY.ZIP
This document is intended to answer questions about deployment requirements of Centura
Team Developer - SQLWindows/32 and ReportWindows on a Windows environment.
SWCSTRUC.ZIP
Documentation for SQLWindows' CSTRUCT.APL and Team Developer's CSTRUCTL.APL in HTML
format. This document was originally written for SQLWindows but the information provided
applies to CTD as well.
SWDEPLOY.ZIP
This document is intended to answer questions about deployment requirements of SQLWindows
5.0.3, ReportWindows 3.0.3 and Quest 3.0.3 on a Windows environment.
TCPIP95.ZIP
Set up your 32 bit LOCAL SQLBase server to accept connection from both SQLWindows (16 bit)
and Centura Team Developer (32 bit) by using TCP/IP Winsock connection.
QuickSQL
QuickSQL is a tool for "quick and easy" SQLBase querying (using direct SQL
or "ClickSQL") and data manipulation (every "one table result set"!).
The most important feature are the meta commands. You can load / unload complete tables,
privileges and stored SQL commands with one(!) meta command.
ANSWER!
(German)
ANSWER! ist das Abfragetool für SQLBase, mit dem ein Endanwender einfach und effizient
auf Daten zugreifen kann. Möglich macht dies die einzigartige
flexQuery-Technologie, die es dem Anwender erlaubt, genau definierte Teile
einer Abfrage zu verändern.