odbcGetQueryTimeout: Gets the current query timeout of a prepared query

In zozlak/RODBCext: Parameterized Queries Extension for RODBC

Description

A query has to be already prepared using SQLPrepare()

Throws an error if an error occured

Usage

odbcGetQueryTimeout(channel)

Arguments

channel

an RODBC channel containing an open connection

Value

The current query timeout value in seconds. 0 means "no timeout"

See Also

odbcSetQueryTimeout, odbcConnect, odbcDriverConnect

Examples

## Not run: 
  conn = odbcConnect('MyDataSource')
  
  sqlPrepare(conn, "SELECT * FROM myTable WHERE column = ?")
  odbcGetQueryTimeout(conn)   # shows the current query timeout of the prepared statement
  sqlExecute(conn, 'myValue')
  sqlFetchMore(conn)

## End(Not run)

zozlak/RODBCext documentation built on Feb. 27, 2020, 10:28 p.m.