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

Nick Gorham nick at lurcher.org
Tue Oct 30 22:07:56 GMT 2012


On 30/10/12 22:01, jon pounder wrote:
> 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.

Hi Jon, long time no email.

SQL_NO_DATA should be only returned when a update or delete query uses a 
search that returns no rows.

ie

delete from table where col = 10

if there are no rows in table that have a col value 10.

-- 
Nick7


More information about the unixODBC-dev mailing list