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