Thanks for all your answers and suggestions and sorry for my message, this was my very first one.As Martin already answer me don't worry any more. Thanks again, next time I will do better.
2008/12/8 P Kishor <[EMAIL PROTECTED]> > On 12/8/08, Oscar Alejandro Alvarado Prieto <[EMAIL PROTECTED]> > wrote: > > how can I retrieve the result of a "SELECT COUNT(*) FROM atable" > statemen? > > thanks > > > > > > Hi Oscar, > > As MikeW mentioned, please use a subject line more descriptive than > "newie question." Additionally, please pose a better question as well. > Martin already explained some of the basics, but your question, as is, > doesn't make any sense. "SELECT COUNT(*) FROM atable" *is* the way to > retrieve the result. If you run that query in the sqlite3 shell, or > through the interface of your choice, you will get back a count of > rows in atable. Perhaps you want to provide some additional > information about where and how you want to "retrieve" the desired > result. > > -- > Puneet Kishor > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Oscar A. Alvarado _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users