Although I'm going to use the easier DROP TABLE IF EXISTS... line as this works wonderfully.
The only reason I asked about the other method you mentioned is that I wanted to at least understand how it worked. The more one knows, the easier it gets later on. Anyway, I think I may know how the value is returned. I have to assume that you thought I was looking for a VB solution. Actually, I'm still brand new at this so sometimes the answer is something obvious to others. >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? 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(*). 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. Thanks David. (and Simon for your comments as well). Thank you again. Rick -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of David Baird Sent: Wednesday, July 01, 2009 9:05 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Changing Table Contents On Wed, Jul 1, 2009 at 6:05 PM, Rick Ratchford<[email protected]> wrote: > I'm using a VB wrapper, and so I run this by... > > Cnn.Execute "Select count(*) FROM sqlite_master WHERE tbl_name = > 'DeltaGrid'" > > Thing is, I don't know where to check for the return value. I'm afraid I can't help with this - I don't have Visual Basic experience :-( _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
