[sqlite] how to use the query select with sqlite3_exec

[Kirrthana M]

Hi,
  Im new to sqlite,i have written a program to create a table and perform
the following operations
Insert,Delete,search.
To perform a search i used the query SELECT along with
sqlite3_exec..Execution is successful but the result is not displayed in the
screen.how to retrieve the result.Give me a suggestion.

Thanks,
Kirrthana