SparForte understands basic SQL commands. This feature is a great convenience for people who work frequently with databases. The SQL command parameters are given directly to your database. SparForte recognizes the following SQL commands:
SQL is a different language from AdaScript and the Bourne shell. SQL for one database may not be compatible with another. For example, an asterisk (*) will not expand to a list of files and quote marks indicate strings or table names, not how to expand dollar variables. Your database documentation will explain how to use your version of SQL.
SparForte submits the SQL command to the database with only one change. Bush will search command for variables and will substitute values using a dollar sign ($) and escape characters with a backslash. Single and double quotes have no effect on how the variable is substituted since quote marks used for a different purpose in SQL.
Like a shell command, the output from the database commands can be redirected or captured using backquotes. The commands can be intermixed with the db package database commands.
=> db.connect( "ken" )
The format of select statements is the same as db.show in the db package.
Some limitations on database commands:
|Back To Top|