On Wed, Jul 1, 2009 at 9:50 PM, Rick Ratchford<[email protected]> wrote: > From what I understand, ANYTIME you do a SQL statement, such as "SELECT...", > you are doing this to a TABLE and returning the result in a sort of > 'recordset'. > > So then, the table is this sqlite_master, the field is tbl_name, and the > result of the SQL query can be had from the recordset it returns. Right?
That is correct. I think that, to be very pedantic, "column" might be a better term than "field" for tbl_name. > So using VB and my wrapper, with SQLite, it is... > > Set Rs = Cnn.OpenRecordset(SQLString) > > I did this and it worked! The returned recordset has a field named after the > function, called count(*). Here's another trick you can do too if you want to give specific names to the resulting columns: SELECT count(*) AS my_count FROM sqlite_master WHERE tbl_name = 'Foo'; > So I guess the answer I was looking for as to where to find the returned > result is "RECORDSET". It wasn't that obvious to me until a few minutes ago. Glad you found it! :-) If you're still new to SQL and want to delve more into theory, you could search Google for "normal forms" (e.g. database normalization)... but that may not be too important until you start working with larger or complex data. -David _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
