Re: [sqlite] Is there any API for counting number of rows in a particular table.

2012-02-05 Thread Michael Steiger
On 05.02.2012 19:18 Fabio Spadaro said the following: 2012/1/31 John Elrick On Tue, Jan 31, 2012 at 6:01 AM, Fabio Spadaro How do you make it open database files that have an

Re: [sqlite] Is there any API for counting number of rows in a particular table.

2012-02-05 Thread Michael Steiger
On 05.02.2012 19:18 Fabio Spadaro said the following: 2012/1/31 John Elrick On Tue, Jan 31, 2012 at 6:01 AM, Fabio Spadaro How do you make it open database files that have an

Re: [sqlite] Is there any API for counting number of rows in a particular table.

2012-02-05 Thread Fabio Spadaro
2012/1/31 John Elrick > On Tue, Jan 31, 2012 at 6:01 AM, Fabio Spadaro >wrote: > > > Hi > > > > 2012/1/30 Bart Smissaert > > > > > How do you make it open database files that have an extension other > than > > >

Re: [sqlite] Is there any API for counting number of rows in a particular table.

2012-01-31 Thread John Elrick
On Tue, Jan 31, 2012 at 6:01 AM, Fabio Spadaro wrote: > Hi > > 2012/1/30 Bart Smissaert > > > How do you make it open database files that have an extension other than > > .slt? > > > > RBS > > > Tonight I will see to create a new version with

Re: [sqlite] Is there any API for counting number of rows in a particular table.

2012-01-31 Thread Fabio Spadaro
Hi 2012/1/30 Bart Smissaert > How do you make it open database files that have an extension other than > .slt? > > RBS Tonight I will see to create a new version with bug fixes. Meanwhile you could give me some feedback such as opening a file with any extension by

Re: [sqlite] Is there any API for counting number of rows in a particular table.

2012-01-31 Thread Bart Smissaert
SQLiteRoot is a free SQLite manager managed in this thread. I downloaded and tried it, but couldn't figure out how to open databases with an extension other than the default for that app, which I think was .slt Nil to do with SQLite really. RBS On 1/31/12, Tim Streater

Re: [sqlite] Is there any API for counting number of rows in a particular table.

2012-01-31 Thread Tim Streater
On 30 Jan 2012 at 21:58, Bart Smissaert wrote: > OK, so how you open those then with SQLiteRoot? I use PHP, thus: $dbh = new PDO ("sqlite:" . $db); where $db is a string like "/path/to/database". I don't know what SQLiteRoot is although possibly I should do.

Re: [sqlite] Is there any API for counting number of rows in a particular table.

2012-01-30 Thread Bart Smissaert
OK, so how you open those then with SQLiteRoot? RBS On Mon, Jan 30, 2012 at 9:46 PM, Tim Streater wrote: > On 30 Jan 2012 at 16:37, Bart Smissaert wrote: > >> How do you make it open database files that have an extension other than >> .slt? >

Re: [sqlite] Is there any API for counting number of rows in a particular table.

2012-01-30 Thread Tim Streater
On 30 Jan 2012 at 16:37, Bart Smissaert wrote: > How do you make it open database files that have an extension other than .slt? Eh? None of my SQLite databases has any extension at all. -- Cheers -- Tim ___ sqlite-users

Re: [sqlite] Is there any API for counting number of rows in a particular table.

2012-01-30 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 30/01/12 04:45, bhaskarReddy wrote: > Is there any API that will return number of rows (records) present in a > particular table. I want to access the table using its database name > and corresponding table. > > If possible give one example. You

Re: [sqlite] Is there any API for counting number of rows in a particular table.

2012-01-30 Thread Bart Smissaert
How do you make it open database files that have an extension other than .slt? RBS On 1/30/12, Fabio Spadaro wrote: > Hi > > 2012/1/30 bhaskarReddy > >> >> Its working with only table name. >> >> >> Regards, >> Bhaskar. > > > You could use a GUI to

Re: [sqlite] Is there any API for counting number of rows in a particular table.

2012-01-30 Thread Fabio Spadaro
Hi 2012/1/30 bhaskarReddy > > Its working with only table name. > > > Regards, > Bhaskar. You could use a GUI to facilitate these requests, and your this regard we propose to test my application it is freeware: www.sqliteroot.com -- Fabio

Re: [sqlite] Is there any API for counting number of rows in a particular table.

2012-01-30 Thread bhaskarReddy
Its working with only table name. Regards, Bhaskar. Igor Tandetnik wrote: > > bhaskarReddy wrote: >> I am getting an error as, >> >> sqlite> select count (*) from LR6000.ONTtable; >> Error: no such table: LR6000.ONTtable > > Just do "select count (*) from ONTtable;" >

Re: [sqlite] Is there any API for counting number of rows in a particular table.

2012-01-30 Thread Igor Tandetnik
bhaskarReddy wrote: > I am getting an error as, > > sqlite> select count (*) from LR6000.ONTtable; > Error: no such table: LR6000.ONTtable Just do "select count (*) from ONTtable;" -- Igor Tandetnik ___ sqlite-users mailing list

Re: [sqlite] Is there any API for counting number of rows in a particular table.

2012-01-30 Thread bhaskarReddy
I am getting an error as, sqlite> select count (*) from LR6000.ONTtable; Error: no such table: LR6000.ONTtable Regards, Bhaskar. Simon Slavin-3 wrote: > > > On 30 Jan 2012, at 12:45pm, bhaskarReddy wrote: > >> Is there any API that will return number of rows (records) >> present

Re: [sqlite] Is there any API for counting number of rows in a particular table.

2012-01-30 Thread Simon Slavin
On 30 Jan 2012, at 12:45pm, bhaskarReddy wrote: > Is there any API that will return number of rows (records) > present in a particular table. I want to access the table using its database > name and corresponding table. Nope. It's quite difficult doing that in SQLite because of how

[sqlite] Is there any API for counting number of rows in a particular table.

2012-01-30 Thread bhaskarReddy
Hi Friends, Is there any API that will return number of rows (records) present in a particular table. I want to access the table using its database name and corresponding table. If possible give one example. Regards, Bhaskar Reddy. -- View this message in context: