Re: [sqlite] which func could get the number of rows

2009-03-08 Thread liubin liu
Yes, sqlite3_get_table() is good to handle the mission. and I am always using it. but I found that the prefomance was a little weak. and so I want to get some other API to handle the same mission. Kees Nuyt wrote: > > On Sat, 7 Mar 2009 01:09:28 -0800 (PST), liubin liu > <7101...@sina.com>

Re: [sqlite] which func could get the number of rows

2009-03-07 Thread Kees Nuyt
On Sat, 7 Mar 2009 01:09:28 -0800 (PST), liubin liu <7101...@sina.com> wrote: >I'm very happy that my question have triggerred the wiki-FAQ's question. > >but if the next version could solve(settle?) the question, >many guys will be happy, :) In my opinion, there is no problem, so there is

Re: [sqlite] which func could get the number of rows

2009-03-07 Thread liubin liu
I'm very happy that my question have triggerred the wiki-FAQ's question. but if the next version could solve(settle?) the question, many guys will be happy, :) and now, does it mean that we have to use link-list struct to write such kind of codes? Kees Nuyt wrote: > > On Fri, 6 Mar 2009

Re: [sqlite] which func could get the number of rows

2009-03-06 Thread Kees Nuyt
On Fri, 6 Mar 2009 02:15:10 -0800 (PST), liubin liu <7101...@sina.com> wrote: >which func could get the number of rows? There is no function to retrieve the number of rows in a result set. SQLite doesn't know the number in advance, but returns row by row while iterating through the tables. The

Re: [sqlite] which func could get the number of rows

2009-03-06 Thread John Machin
On 6/03/2009 9:15 PM, liubin liu wrote: > which func could get the number of rows? select count(*) from your_table_name; ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users