In the Translator, you can read data from a database by either calling stored procedures or using conn:query
...
{} to execute
...
ad hoc SQL SELECT
...
statements on a database. See Writing SQL Statements.
| Code Block | ||
|---|---|---|
| ||
local R = conn:query{ |
...
example of query and annotation results
...
Link to “writing SQL statements“
...
sql='SELECT * FROM Patients WHERE LastName=' ..conn:quote(lastName)} |
The conn:query{} method prevents the accidental use of SQL statements that might modify the database from the Translator, which automatically executes when you make script changes or sample data changes.
| Expand | ||
|---|---|---|
| ||
Using the Annotations you can view database query result tables easily:  The function returns the database query result sets and a Lua table of all result sets. A for loop can be used to iterate through the results table and access values using  |
| Expand | ||
|---|---|---|
| ||
pcall() can be used to perform a protected call, capturing any returned database errors allowing you to appropriately handle errors according to your needs. In this example, we are using  |