Browse mode and ad hoc queries sample program

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 example demonstrates how an application can determine which columns resulting from ad hoc queries can be updated using browse-mode techniques.

This example 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 you selected can be browsed.

NoteAccess to Adaptive Server is required.