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.