DBGridList

(ODBC Manager Library)

Description:              Populates a grid list using the results of a database query

 Format:                    \ODBCManager\DBGridList(  DSN,  UserName,  Password,  SelectQualifier,  Fields,  Tables,  WhereFields,  WhereOperators,  WhereValues,  WhereAndFlag,  UserQuery,  ColName,  ColFormat,  ColCellWidth,  RowHeight,  TitleHeight,  ExtDisplayRef,  AutoResizeWidths,  OrderBy,  LockFirstColParm,  SortParm,  SelectedRowParm,  SelectedColParm,  Horiz,  Vert,  Refresh,  DataPtr)

Returns:                    Numeric

Usage:                       Script

Parameters:          DSN   {  text  }  { required }  { no default: }

                             Datasource name to query.

                             UserName    { text }  { required }  { no default: }

                             The user name in the database for authentication.

                             Password     { text }  { required }  { no default: }

                             The user name in the database for authentication.

                             SelectQualifier       { text }  { required }  { no default: }

                             SQL selelection qualifier, such as "top 100" etc.

                             Fields { array of text }  { required }  { no default: }

                             Field names to query for

                             Tables          { array of text }  { required }  { no default: }

                             Tables to query from

                             WhereFields { array of text }  { required }  { no default: }

                             field named for SQL WHERE clause

                             WhereOperators    { array of text }  { required }  { no default: }

                             Operators for the SQL WHERE clause

                             WhereValues         { array of values }  { required }  { no default: }

                             Array of values for the SQL WHERE clause

                             WhereAndFlag       {  Boolean }  { required }  { no default: }

                             Set 1 for AND of where fields, reset for OR

                             UserQuery   { text }  { required }  { no default: }

                             Overrides Fields, Tables, & Where when defined

                             ColName      { text }  { required }  { no default: }

                             Text array of titles for displaying data

                             ColFormat    { text }  { required }  { no default: }

                             Text array of format qualifiers for each of the values.

                             ColCellWidth { array of numeric }  { required }  { no default: }

                             Array giving the size to use for the cells columns

                             RowHeight   { numeric }  { required }  { default: Invalid }

                             Height of the data rows.  Set to invalid to use the defaults.

                             TitleHeight   { numeric }  { required }  { default: Invalid }

                             Height of the column titles. Set to invalid to use the defaults.

                             ExtDisplayRef        { object }  { required }  { default: Invalid }

                             Object value of where ColFormat modules located

                             AutoResizeWidths  { Boolean }  { required }  { no default:}

                             Automatically resize the widths to fit the available space

                             OrderBy       { text}  { required }  { no default:}

                             Field names for ORDER BY clause only used

                             LockFirstColParm   { Boolean }  { required }  { no default:}

                             True to lock column 0 while horizontal scrolling

                             SortParm     { Boolean }  { required }  { no default:}

                             Enables grid list sorting

                             SelectedRowParm  { numeric }  { required }  { no default:}

                             0 - based value of row of selected item

                             SelectedColParm    { numeric }  { required }  { no default:}

                             0 - based value of column of selected item

                             Horz   { numeric }  { required }  { no default:}

                             Horizontal scroll position

                             Vert   { numeric }  { required }  { no default:}

                             Vertical scroll position

                             Refresh                  { Boolean }  { required }  { no default:}

                             Set flag to re-query data

                             DataPtr        { pointer }  { required }  { no default:}

                             Pointer to data read from db in [Col][Row] format

Comments:               This module is a member of the ODBCManager Library, and must therefore be prefaced by \ODBCManager\, as shown in "Format" above.

See Also:

Gridlist