Example 7: Browse mode and ad hoc queries

The example7.c sample program uses browse-mode techniques to determine the source of result columns from ad hoc queries. Determining the source of result columns is important because a browse-mode application can only update columns that are derived from a browsable table and are not the result of a SQL expression.

This sample program demonstrates how an application can determine which columns resulting from ad hoc queries can be updated using browse-mode techniques. It also prompts you for an ad hoc query. Notice how the results differ depending on whether the select query includes the keywords for browse and whether the table selected is able to be browsed.