This example uses a table named MyTable that was created using the following SQL statements:

CREATE TABLE MyTable( id int primary key, lname char(100), fname char(100) )
CREATE INDEX ix_lname ON MyTable ( lname )

The following code displays all the fname column contents where lname column is "Smith":

ULTable * tbl = conn->OpenTable( "MyTable", "ix_lname" );
char buffer[ 100 ];
bool found;
tbl->FindBegin();  // enter "Find mode"
tbl->SetString( "lname", "Smith" );  // set pointer row buffer to "Smith"
found = tbl->FindFirst();
while( found ) {
    tbl->GetString( 3, buffer, 100 );
    printf( "%s\n", buffer );
	found = tbl->FindNext();
}
tbl->Close();

In this example, the tbl variable is set to open MyTable using the ix_lname index so that rows are returned in same order as the lname column. ULTable objects use the values in the row buffer when they execute a find. This buffer is specified as "Smith", as defined by the SetString method. The FindFirst method indicates that traversal should begin at the first row that has lname set to "Smith"; the pointer is positioned after the last row of the table if there are no rows where lname is set to "Smith". The fname is retrieved by the GetString method because The fname has a column ID of 3. The results are then displayed, and the resources are freed.

• ULTable class [UltraLite C++]