Downloads

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.


Sample Code

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.


Tools

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.


Information and Documentation

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.


3rd-Party Products

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.