Records count Sqlite

[autoitxp]

Hi

Is there any way to reocrds count for Sqlite database ?

[picaxe]

I've been using this

_SQLite_SQLiteExe($db_name, "SELECT COUNT() FROM database;", $raw_output)

if @error=0 then, Number($raw_output) is record count. However duplicate primary keys will return zero.

Edited October 31, 2007 by picaxe