Great!!! Thanks! Roger.
----- Original Message ----- From: "Doug Currie" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 26, 2004 4:10 PM Subject: Re: [sqlite] Versions 2.8.15 and 3.0.3 available > > Monday, July 26, 2004, 12:33:41 PM, Roger Reghin wrote: > > > I also use EMPTY_RESULT_CALLBACKS for the same reason Nuno does. And my > > software also needs FULL_COLUMN_NAMES as well. So, no 3.x for me... =( > > In 3.x column names are available as soon as the query is prepared. > See the C API reference at > http://www.sqlite.org/capi3ref.html#sqlite3_column_name > > > const char *sqlite3_column_name(sqlite3_stmt*,int); > > const void *sqlite3_column_name16(sqlite3_stmt*,int); > > > > The first parameter is a prepared SQL statement. This function returns > > the column heading for the Nth column of that statement, where N is > > the second function parameter. The string returned is UTF-8 for > > sqlite3_column_name() and UTF-16 for sqlite3_column_name16(). > > In other words, there is no need for the pragma. > > e > > > ----- Original Message ----- > > From: "Nuno Lucas" <[EMAIL PROTECTED]> > > To: "sqlite" <[EMAIL PROTECTED]> > > Sent: Monday, July 26, 2004 12:33 PM > > Subject: Re: [sqlite] Versions 2.8.15 and 3.0.3 available > > > >> D. Richard Hipp, dando pulos de alegria, escreveu : > >> > The following pragmas are scheduled to be removed in the future: > >> > > >> > EMPTY_RESULT_CALLBACKS > >> > FULL_COLUMN_NAMES > >> > SHORT_COLUMN_NAMES > >> > COUNT_CHANGES > >> > > >> > >> What would be the equivalent to EMPTY_RESULT_CALLBACKS=TRUE then? > >> > >> I use it to get the column names list to display in a grid, even when > >> the result is empty. I think it is better to the user to see them, even > >> if no results are present. > >> > >> Regards, > >> ~Nuno Lucas > >> > >> > >