Re: when to return SQL_NO_DATA from SQLExecute/SQLExecDirect

Nick Gorham <[email protected]>
Newsgroups gmane.comp.db.unixodbc.devel
Message-ID <[email protected]>
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
_______________________________________________
unixODBC-dev mailing list
[email protected]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-dev
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.