GNADE User's Guide: GNADE, The GNat Ada Database Environment; Version 1.5.0; Document Revision $Revision: 1.42 $ | ||
---|---|---|
Prev | Chapter 6. Using the release with your database | Next |
All examples are located in the directories samples and contrib. In the directory samples you will find the following files and directories:
Makefile
This is the makefile which builds all examples
esql
Several examples demonstrating the features of the esql translator. All example programs are using the test database as it is generated while building the GNADE distribution.
Table 6-1. Examples of embedded SQL
simple | This demonstrates a simple like SELECT. There are two version demonstrating the capability to process different comilation units. |
nobel_co | This examples demonstrates the uage of nested cusrsors and enhanced connection management. |
dynamic | A nice example for using dynamic sql with the esql translator. |
attachment | This example demonstrates the usage of the GNADE SQL types VARCHAR and VARBINARY. This example allows to store/delete and retrieve the contents of a file from a test database. |
mysql
Example for the MySQL native bindings
This example creates it's own data base called "testdb" and issues a query. The query result is printed out.
odbc
An example how to use the ODBC interface directly.
A simple example that executes a query on the gnade test data base.
postgres
Example for the Postgres native bindings
A simple example that executes a query on the gnade test data base.