U++ framework: U++ SQL » sqlite3 get number of occurrences

Home » U++ Library support » U++ SQL » sqlite3 get number of occurrences

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

sqlite3 get number of occurrences [message #21134]

Mon, 04 May 2009 17:18

darthspawn
Messages: 58
Registered: February 2009

Member

How can i get the number of occurrences of a database? thanks!

Sam

Report message to a moderator

Re: sqlite3 get number of occurrences [message #21136 is a reply to message #21134]

Mon, 04 May 2009 19:59

mirek
Messages: 14291
Registered: November 2005

Ultimate Member

I do not understand the question. Can you reformulate, please?

Mirek

Report message to a moderator

Re: sqlite3 get number of occurrences [message #21146 is a reply to message #21134]

Tue, 05 May 2009 10:12

darthspawn
Messages: 58
Registered: February 2009

Member

Sure!

I need to have the total number of rows in my db, so, i need to count the total lines inserted. There is a way to have that number?

Sam

Report message to a moderator

Re: sqlite3 get number of occurrences [message #21160 is a reply to message #21146]

Wed, 06 May 2009 08:58

mirek
Messages: 14291
Registered: November 2005

Ultimate Member

int n = SQL % Select(SqlCountRows()).From(MYTABLE);

Mirek

Report message to a moderator

Re: sqlite3 get number of occurrences [message #21164 is a reply to message #21134]

Wed, 06 May 2009 10:19

darthspawn
Messages: 58
Registered: February 2009

Member

Thank you very much! there is in the documentation a page with this functionality?

Sam

Report message to a moderator

Re: sqlite3 get number of occurrences [message #21165 is a reply to message #21164]

Wed, 06 May 2009 10:37

mirek
Messages: 14291
Registered: November 2005

Ultimate Member

http://www.ultimatepp.org/src$Sql$SqlExp$en-us.html

But of course, SQL knowledge is expected...

Mirek

Report message to a moderator

Re: sqlite3 get number of occurrences [message #21172 is a reply to message #21165]

Wed, 06 May 2009 14:21

darthspawn
Messages: 58
Registered: February 2009

Member

I know SQL, I don't know when to use
SQL %
SQL *
SQL * ::

what are the difference between this syntax?

Report message to a moderator

Re: sqlite3 get number of occurrences [message #21175 is a reply to message #21172]

Wed, 06 May 2009 19:52

mirek
Messages: 14291
Registered: November 2005

Ultimate Member

Search the forum, this was discussed.

Mirek

Report message to a moderator

Previous Topic:	OrderBy Descending missing
Next Topic:	OleDB Compile error in release 2008.1

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Sep 16 23:18:54 GMT+2 2026

Total time taken to generate the page: 0.00820 seconds