Drop-Down Combo Boxes

Drop-down combo boxes are used to specify values for most arguments. For example, drop-down combo boxes are used to specify values for the InConnectionString, StringLength1, and DriverCompletion arguments in SQLDriverConnect.

For numeric arguments, such as the Attribute argument in SQLSetStmtAttr, the list consists of all applicable #define names and the numeric value associated with each #define name. If Version Numbers in the User Options dialog box is selected, the version of ODBC in which each #define name was introduced is also displayed.

For character arguments, such as the InConnectionString argument in SQLDriverConnect, the list always contains <empty string> and <null pointer>. It may contain <input window> or <input window selection> (to use the currently selected text in the input window or, if no text is selected, all text in the input window), and it may contain any known text values, such as data source names. For character arguments, ODBC Test automatically places the length of the character argument in the corresponding length argument when you move the focus to a different control.

For some arguments, such as the ParameterValuePtr argument in SQLBindParameter, the list may contain <rowset values>. This activates the Rowset hdbc and Rowset hstmt list boxes, which enable you to specify the InputHandle and StatementHandle of the bound rowset. The Row and Column text boxes allow you to specify the row number and column number, respectively.

For pointer arguments, the list includes <valid pointer> and <null pointer>. If <valid pointer> is chosen, ODBC Test frees the existing pointer and creates a new pointer. If <null pointer> is chosen, ODBC Test passes a null pointer. This is true for the ParameterValuePtr argument in SQLSetDescRec, the ParameterValuePtr argument in SQLSetDescField for a field that is a pointer, or the ParameterValuePtr argument in SQLSetStmtAttr when the statement attribute is a pointer.

You can either select a value from the list or type a value in the text box. If the argument accepts values for which #define names apply, you can type the #define name (or any unambiguous portion of it) in the text box. For example, to specify that the driver prompt the user for connection information, select SQL_DRIVER_COMPLETE from the list of values for DriverCompletion in the SQLDriverConnect dialog box, or type 1, 0x01, or SQL_DRIVER_COMPLETE (COM would be sufficient). The entered text will automatically change to the appropriate value when you move the focus to a different control.