[unixODBC-dev] when to return SQL_NO_DATA from SQLExecute/SQLExecDirect

jon pounder jonp at inline.net
Tue Oct 30 22:01:42 GMT 2012


On 10/30/2012 05:48 AM, Peter Harvey wrote:

I have run into that before and I think its pretty common actually.
No data does not necessarily mean error at all.

> Christian,
>
> drvexecute returns SQL_NO_DATA, as follows, when I submit a simple
> "CREATE TABLE" statement.
>
>      if (*s->ov3 && !s->isselect && ret == SQL_SUCCESS && nrows == 0) {
>      ret = SQL_NO_DATA;
>
> My take on the specification is that this is not a time to return
> SQL_NO_DATA. This should be SQL_SUCCESS. I may be wrong?
>
> --
> Cheers
> Peter
>
>
> _______________________________________________
> unixODBC-dev mailing list
> unixODBC-dev at mailman.unixodbc.org
> http://mailman.unixodbc.org/mailman/listinfo/unixodbc-dev



More information about the unixODBC-dev mailing list