[sqlite] sqlite3_column_count and sqlite3_data_count

2015-02-26 Thread Bart Smissaert
Well, sqlite3_column_count seems to have a clear advantage here in that you don't have to worry about being in a row or not. RBS On Thu, Feb 26, 2015 at 12:45 AM, Simon Slavin wrote: > > On 26 Feb 2015, at 12:41am, Bart Smissaert > wrote: > > > OK, thanks for clearing that up. So there seems

[sqlite] sqlite3_column_count and sqlite3_data_count

2015-02-26 Thread Simon Slavin
On 26 Feb 2015, at 12:41am, Bart Smissaert wrote: > OK, thanks for clearing that up. So there seems then little point then in > using sqlite3_data_count? Use whichever one you prefer the sound of. No clear advantage of either one. Simon.

[sqlite] sqlite3_column_count and sqlite3_data_count

2015-02-26 Thread Bart Smissaert
OK, thanks for clearing that up. So there seems then little point then in using sqlite3_data_count? RBS On Thu, Feb 26, 2015 at 12:16 AM, Igor Tandetnik wrote: > On 2/25/2015 7:03 PM, Bart Smissaert wrote: > >> Could somebody tell me what the difference is between these 2 functions? >> > >

[sqlite] sqlite3_column_count and sqlite3_data_count

2015-02-26 Thread Bart Smissaert
Could somebody tell me what the difference is between these 2 functions? Couldn't work it out from the documentation and not been able to setup an example where they produce different results. RBS

[sqlite] sqlite3_column_count and sqlite3_data_count

2015-02-25 Thread Richard Hipp
On 2/25/15, Igor Tandetnik wrote: > > Why both are needed, I'm not sure. > Historical accident -- D. Richard Hipp drh at sqlite.org

[sqlite] sqlite3_column_count and sqlite3_data_count

2015-02-25 Thread Igor Tandetnik
On 2/25/2015 7:03 PM, Bart Smissaert wrote: > Could somebody tell me what the difference is between these 2 functions? sqlite3_column_count() returns correct number as soon as the statement is prepared. sqlite3_data_count returns zero unless the statement is actually positioned on a row

Re: [sqlite] sqlite3_column_count vs. sqlite3_data_count

2012-05-16 Thread Dan Kennedy
On 05/16/2012 06:04 PM, Stephan Beal wrote: On Wed, May 16, 2012 at 1:02 PM, Dan Kennedy wrote: Not so. It's the number of columns of data currently available. Which is sometimes the same as sqlite3_column_count() and sometimes zero. Can sqlite3_data_count() be used

Re: [sqlite] sqlite3_column_count vs. sqlite3_data_count

2012-05-16 Thread Dan Kennedy
On 05/16/2012 05:57 PM, Petite Abeille wrote: On May 16, 2012, at 12:49 PM, Baruch Burstein wrote: sqlite3_column_count Number of columns. http://www.sqlite.org/c3ref/column_count.html sqlite3_data_count Number of rows. http://www.sqlite.org/c3ref/data_count.html Not so. It's the

Re: [sqlite] sqlite3_column_count vs. sqlite3_data_count

2012-05-16 Thread Dan Kennedy
On 05/16/2012 05:49 PM, Baruch Burstein wrote: sqlite3_column_count sqlite3_data_count What is the difference between the two? sqlite3_data_count() will return zero if the statement handle does not currently point to a row of data. For example if it has just been prepared or reset, or if the

Re: [sqlite] sqlite3_column_count vs. sqlite3_data_count

2012-05-16 Thread Petite Abeille
On May 16, 2012, at 12:49 PM, Baruch Burstein wrote: > sqlite3_column_count Number of columns. http://www.sqlite.org/c3ref/column_count.html > sqlite3_data_count Number of rows. http://www.sqlite.org/c3ref/data_count.html ___ sqlite-users

[sqlite] sqlite3_column_count vs. sqlite3_data_count

2012-05-16 Thread Baruch Burstein
sqlite3_column_count sqlite3_data_count What is the difference between the two? -- ˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users