Add query timeout functions and parameters (closes #10) - Githubissues

zozlak / RODBCext

14 stars 10 forks source link

Add query timeout functions and parameters (closes #10) #12

Closed aryoda closed 7 years ago

aryoda commented 7 years ago

The patch contains:

New functions odbcSetQueryTimeout and odbcGetQueryTimeout
New parameter query_timeout in the functions sqlPrepare and sqlExecute
Roxygen documentation
R testing script for manual testing with MS SQL Server on Windows (in "tests/manual/test_query_timeout_with_MS_SQL.R")
some minor fixes of documentation errors in the functions sqlPrepare and sqlExecute

Closes https://github.com/zozlak/RODBCext/issues/10

Open issues:

errors parameter is ignored when setting the query timeout via param query_timeout: An error is still thrown (not wrapped and replaced by an error return code) that is caused by setting the query timeout value.