Many aspects of database application development depend on your application development tool, database interface, and programming language, but there are some common problems and principles that affect multiple aspects of database application development.
This chapter describes some principles and techniques common to most or all interfaces and provides pointers for more information. It does not provide a detailed guide for programming using any one interface.
Executing SQL statements in applications
Preparing statements
Introduction to cursors
Working with cursors
Choosing cursor types
Adaptive Server Anywhere cursors
Describing result sets
Controlling transactions in applications