Navigation: Programming Cookbook > Database Connectivity >
Executing SQL Queries
The DBConnection class defines a number of methods for working with SQL statements. If you want to execute a query that answers a result table then you should use #query: to do this. Let us try executing a query to see how it works.
rs := c query: 'select * from Orders'. "Display it"
You should find that this answers a DBResultSet object capable of providing access to the rows of the result table.