Scalable Database Server, HiRDB Version 8 UAP Development Guide

[Contents][Index][Back][Next]

13.7 Setting cursor libraries

A cursor library must be set before SQLExtendedFetch can be used in an ODBC UAP. A cursor library can be set in two ways:

When the SetConnectOption ODBC function is used:
Use the SetConnectOption ODBC function and specify SQL_ODBC_CURSORS in the fOption argument and SQL_CUR_USE_ODBC in the vParam argument.

When RDO of Visual Basic is used:
Specify rdUseOdbc in the CursorDriver property of the rdoEnvironment object. The following is an example of coding when RDO of Visual Basic is used:
Dim mrdoEnv as rdoEnvironment
Set mrdoEnv = rdoEngine.rdoCreateEnvironment("","","")
    mrdoEnv.CursorDriver = rdUseOdbc
    Src = "DSN=host1; UID=USER_A;PWD=USER_A"
    Set mrdoConn = mrdoEnv.OpenConnection
                   ("", rdDriverComplete, False, Src)
        ...
        ...
See the simple sample UAPs found in the Sampleap directory of the installation floppy disk for the ODBC driver.