Aims
To introduce attendees to the Texapi Client-Server Applications Programming Interface. This interface enables programmers to develop applications which connect to the database server engine to perform searches and updates on Texpress databases.
Who Should Attend
This course is designed for developers wanting to use Texpress as a database server engine linked to custom-made user interfaces.
Format
This course is a two day workshop. Each attendee has exclusive access to a PC or terminal connected to a Unix host on which Texpress, the Texapi server, the Texapi client libraries and a C compiler are installed. Attendees develop and test a range of C programs for Unix which query and update data held in their own databases. Developing client applications under Microsoft Windows and Apple Macintosh is also discussed.
Prerequisites
Attendees must have attended the KE Software Texql course before attending this course. This course also assumes that attendees are conversant with the C programming language.
Course Outline - Day One
- Texapi Introduction
- Overview
- Terminology
- Compiling programs
- Error Status of API Calls
- Program Initialisation
- Initialising Texapi
- The TEXPARAMS structure
- Processing on-line arguments and environment variables
- Connecting to the Texapi Server
- Session Ids and multiple connections to servers
- Performing Queries
- The TexCommand call
- Cursors
- Overview of cursor operations
- Types of cursors
- "Walking" cursors
- Nested cursors
- Processing Query Results
- Retrieving matching rows
- Extracting column data from matching rows
Course Outline - Day Two
- Convenience Functions
- Accessing data by items and fields
- Miscellaneous Operations
- Estimating number of query matches
- Determining number of query matches
- Updating Tables
- Insert, update and delete commands
- Updating data on a query cursor
- Error Processing
- Detecting error statuses
- Reporting error messages
- Debugging Techniques
- Using KE Texql to debug TexCommand statements
- Program diagnostics
- Unix debugging tools
- Developing Clients without a Server
- Non-Unix Clients
- Microsoft Windows access
- Apple Macintosh access
- Using Visual Basic
For further information and bookings, email: