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 table name is constant
(DataTable), running the procedure again will simply cause a "Table already
exists" error.
What I need to do is to:
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 table already exists.
If it does exist, I suppose I can then use the SQL Delete to delete all the
records and then write the new stuff. If this is not the way to do it, maybe
someone can suggest the proper way.
I've seen some routines where you try to create a RS from the Table in order
to test if it exists. Is this how it is done for SQLite?
Thanks.
Rick
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
