Hi, this is a normal select statement, you can retrieve the result in the same way as for 'select foo from bar' - Statement. The tecnical way depends on the interface you use.
If you need a name of the result field, you can use 'SELECT COUNT(*) as MyField FROM atable'; the result field is the named "MyField". HTH Martin Oscar Alejandro Alvarado Prieto wrote: > how can I retrieve the result of a "SELECT COUNT(*) FROM atable" statemen? > thanks > > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
