Language: VB6
In my project, I create a Table that holds specific information based on a
User's selection.
When the user runs a new selection, my procedure that creates this table is
run again to recreate the table but with new information.
However, the problem I have is that since the
On Wed, Jul 1, 2009 at 5:29 PM, Rick Ratchfordr...@amazingaccuracy.com wrote:
1. Determine if the table has already been created due to a prior run.
2. If so, to remove the information currently in that table and replace it
with new information.
I'm not sure how to determine whether the
DROP TABLE Foo;
-- It's okay to execute this command, even if Foo does not exist
already.
Hello David. Thanks for your reply.
The above Drop Table created an error when I tried to run it when no table
existed.
CREATE TABLE Foo ( ... );
Forgive my novice ignorance. Although I have
Discussion of SQLite Database'
Subject: Re: [sqlite] Changing Table Contents
DROP TABLE Foo;
-- It's okay to execute this command, even if Foo does not exist
already.
Hello David. Thanks for your reply.
The above Drop Table created an error when I tried to run it when no table
existed
On 2 Jul 2009, at 1:22am, Rick Ratchford wrote:
Okay, I found what needed to be added to DROP TABLE to make it not
produce
the error.
DROP TABLE IF EXISTS Foo
That did the trick.
Still haven't figured out how to get the test result from...
SELECT count(*) FROM sqlite_master WHERE
On Wed, Jul 1, 2009 at 6:05 PM, Rick Ratchfordr...@amazingaccuracy.com 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
.
Rick
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] 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
On Wed, Jul 1, 2009 at 9:50 PM, Rick Ratchfordr...@amazingaccuracy.com 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