search

microsoft / ODBC-Specification

Microsoft ODBC Specification
Other
122 stars 40 forks source link

Require SQLGetData to retrieve exception data during a fetch #118

Closed mikepizzo closed 7 years ago

mikepizzo commented 7 years ago

Currently the spec says that, upon a data exception (length exception, data type exception, or dynamic column) the application can either call SQLGetData to retrieve the value or rebind in which case calling SQLNextColumn will populate that new binding.

It would be much simpler to say that the value for that row can only be fetched via SQLGetData (which may fetch into the bound buffer, but is explicit) rather than requiring the driver to (sometimes) populate this binding.

matthew-wozniczka commented 7 years ago

Is this about disallowing the rebinding, or that rebinding is allowed, but won't initially take effect?

If the latter, would the original binding stay in effect until the end of the fetch?

mikepizzo commented 7 years ago

We would still allow rebinding only for rowset size = 1, which would be applied on the next call to fetch/fetchscroll.