| 1 |
tony |
37 |
Script Engine Playground
|
| 2 |
|
|
========================
|
| 3 |
|
|
|
| 4 |
|
|
This example application illustrates use of the TIBXScript SQL script engine. It works with
|
| 5 |
|
|
the example employee database and comes with various test scripts to illustrate how it works.
|
| 6 |
|
|
These are all located in the "tests" directory.
|
| 7 |
|
|
|
| 8 |
|
|
Compile and run the application after first ensuring that the example employee database is
|
| 9 |
|
|
available on the local server. If it is on a remote server, then you will have to adjust
|
| 10 |
|
|
the IBDatabase1.DatabaseName property accordingly.
|
| 11 |
|
|
|
| 12 |
|
|
You can just type SQL queries into the left hand text box and click on "Execute" to
|
| 13 |
|
|
run them. The results appear in the right hand text box. Select queries are supported
|
| 14 |
|
|
by opening a new dynamically created window with a grid containing the query results. This
|
| 15 |
|
|
window is non-modal and multiple query results can be shown simultaneously. The grid
|
| 16 |
|
|
is a TIBDynamicGrid and clicking on the column header will resort the grid using the
|
| 17 |
|
|
selected column.
|
| 18 |
|
|
|
| 19 |
|
|
The test scripts are loaded in the left hand text box by clicking on the "Load Script"
|
| 20 |
|
|
button. The scripts are:
|
| 21 |
|
|
|
| 22 |
|
|
1. CreateCountriesTable.sql
|
| 23 |
|
|
|
| 24 |
|
|
This adds a new table "COUNTRIES" to the employee database and then populates
|
| 25 |
|
|
it with country data including the country name and ISO2 and 3 character shortnames.
|
| 26 |
|
|
|
| 27 |
|
|
2. CreateCountriesTablewithError.sql
|
| 28 |
|
|
|
| 29 |
|
|
This does the same as the above, except that the first insert statement contains
|
| 30 |
|
|
a syntax error. It may be used to experiment with the "Stop on First Error" checkbox,
|
| 31 |
|
|
and shows how the script engine can recover and continue from (some) syntax errors.
|
| 32 |
|
|
|
| 33 |
|
|
3. DeptListView.sql
|
| 34 |
|
|
|
| 35 |
|
|
This script adds a complex View to the database and tests the script engine in complex
|
| 36 |
|
|
scenarios, such as recursive queries.
|
| 37 |
|
|
|
| 38 |
|
|
4. createproc.sql
|
| 39 |
|
|
|
| 40 |
|
|
This script adds three simple stored procedures. It demonstrates the different ways
|
| 41 |
|
|
that procedure bodies can be declared (ISQL compatible, standard terminator and no
|
| 42 |
|
|
terminator). Use of comments is also demonstrated.
|
| 43 |
|
|
|
| 44 |
|
|
5. ParameterisedQueries.sql
|
| 45 |
|
|
|
| 46 |
|
|
This script demonstrates the use of IBX style query parameters for BLOB columns.
|
| 47 |
|
|
In this case a new column "Image" is added to the COUNTRY Table and an image in
|
| 48 |
|
|
png format (the flag of St George) is added to the entry for England. The value
|
| 49 |
|
|
of the Image column is given by a parameter ":MyImage". This is resolved by the a
|
| 50 |
|
|
pplication which asks for the file containing the image to be placed in the field.
|
| 51 |
|
|
You should locate and return the "flag_en.png" file.
|
| 52 |
|
|
|
| 53 |
|
|
Note that the interactive resolution of the parameter is an example. The parameter
|
| 54 |
|
|
resolution is carried out by an event handler that could, for example,
|
| 55 |
|
|
have looked for a file which might conventionally have been called "MyImage.bin"
|
| 56 |
|
|
to correspond to the query parameter.
|
| 57 |
|
|
|
| 58 |
|
|
6. Reverseall.sql
|
| 59 |
|
|
|
| 60 |
|
|
Reverses out the above.
|
| 61 |
|
|
|
| 62 |
|
|
7. SelectQuery.sql
|
| 63 |
|
|
|
| 64 |
|
|
Illustrates handling of select queries.
|
| 65 |
|
|
|
| 66 |
|
|
|
| 67 |
|
|
|
