Accessing Databases
*******************

Database Access Introduction
============================

Oleo can interface to database management systems (DBMSs) in more than one way.

This is work in progress though, we expect the implementation to evolve quite a bit from the current status.

Currently there are three ways of accessing databases from Oleo :

  * reading a DBF (xbase) file

  * reading rows of content from an MySQL database, prompted by the user

  * reading the single result of an SQL query (to MySQL) into a cell

MySQL
=====

You can get a value from a database into a cell by putting a statement like

     @mysql_query("select max(salary) from salaries")

in the cell.

Xbase
=====