Re: SQL_SUCCEEDED macro / SQL_NO_DATA for CREATE TABLE

Frediano Ziglio <[email protected]> Fri, 19 Oct 2018 12:08:27 +0100
Newsgroups gmane.comp.db.tds.freetds
Message-ID <CAHt6W4eY6aEUfVFMx1BY_T0hvUNC4Fqa6kKHJGeyrSpDrYM+3g@mail.gmail.com>
I think mostly historic reasons.
I remember I wrote a macro that considered SQL_NO_DATA as success too
to use in these cases.
Is not clear the distinction between SQL_NO_DATA and SQL_SUCCESS in
these cases, seems that for instance updates/inserts should return
SQL_NO_DATA and not SQL_SUCCESS according to the documentation.
Maybe would be good to check and change for version 1.1.

Frediano

Il giorno mer 10 ott 2018 alle ore 15:43 Sebastien FLAESCH
<[email protected]> ha scritto:
>
> Hi all,
>
> Must have been discussed several times:
>
> Why does FreeTDS APIs return SQL_NO_DATA for an DDL SQL such as
> CREATE TABLE, when other ODBC drivers just return 0/SQL_SUCCESS
> (or 1/SQL_SUCCESS_WITH_INFO)?
>
> This prevents us to use the standard SQL_SUCCEEDED() macro.
>
> Seb
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> https://lists.ibiblio.org/mailman/listinfo/freetds