Using SQL within Applications
In This Chapter
Using SQL within an application
Combining SQL with procedural languages
Avoiding interlanguage incompatibilities
Embedding SQL in your procedural code
Calling SQL modules from your procedural code
Invoking SQL from a RAD tool
Previous chapters address SQL statements mostly in isolation. For example, questions are asked about data, and SQL queries are developed that retrieve answers to the questions. This mode of operation, interactive SQL, is fine for discovering what SQL can do — but it’s not how SQL is typically used.
Even though SQL syntax can be described as similar to that of English, it isn't an easy language to master. The overwhelming majority of computer users are not fluent in SQL — and you can reasonably assume that they never will be, even if this book is wildly successful. When a database question comes up, Joe ...