Navigation:  Programming Cookbook > Database Connectivity > Executing SQL Queries >

Accessing a Row

Previous pageReturn to chapter overviewNext page

When you ask a DBResultSet for a particular row of information you are returned an instance of DBRow. From this you can access the individual fields using either their symbolic names or their index positions within the row.

rs := c query: 'select * from Orders where ShipCountry=''France'''. "Display it"

row := rs first. "Display it"

row columns. "Display it"

row at: #ShipCountry. "Display it"

row at: #ShipCity. "Display it"

row atIndex: 2. "Display it"