SQLColumnMap Command

Obsolete

Refer to the SQLColumnMap method in the cSQLStatement class.

SQLColumnMap hstmt sColName To iColNumber

The SQLColumnMap command maps a column name to a column number.

Example

Open Customer
SQLFileConnect Customer To hdbc
SQLOpen hdbc To hstmt
SQLExecDirect hstmt "SELECT * FROM Customer"
SQLColumnMap "Picture" To iColNum

Repeat
    SQLFetch hstmt
    Move SQLResult To FetchResult

    If (FetchResult) Begin
        Repeat
            SQLGetData hstmt iColNum Length 1024 To sPictureChunk

            If (SQLResult) ;
                Send HandlePictureChunk sPictureChunk
        Until (SQLResult <> SQLSuccess)
    End
Until (Not(FetchResult))