check the Table if exist

[Sinan Tuzcu]

Helo,

can i checked the table, if the exist with follow code

SQL1.ExecNonQuery("DROP TABLE IF EXISTS" & Name & ")

gruß
sinan

 

[Mahares]

Do not do that. You will delete the table. Do this:

If Sql1.ExecQuerySingleResult("SELECT count(name) FROM sqlite_master WHERE type='table' AND name ='yourTableName'") = 0 Then
 msgbox("Does not exist","")
Else
 msgbox("Table exists","")
End If

 

[Sinan Tuzcu]

helo,

I would only check if the table exists, if not, then I want to create it.

SQL1.ExecNonQuery("DROP TABLE IF EXISTS" & ayir2(0) & ")
SQL1.ExecNonQuery("CREATE TABLE"  & ayir2(0) & "(Nummer TEXT , Name TEXT, Mesaj TEXT , LinkAdres TEXT, Datum TEXT)")
SQL1.ExecNonQuery2("INSERT INTO"  & ayir2(0) & "VALUES(?,?,?,?,?)", Array As Object(ayir2(0), ayir2(1), ayir2(2), ayir2(3),ayir2(4)))

but doesn't work

 

[Mahares]

Replace this line:

SQL1.ExecNonQuery("DROP TABLE IF EXISTS" & ayir2(0) & ")

with this line:

SQL1.ExecNonQuery("DROP TABLE IF EXISTS " & ayir2(0))

Notice the space after EXISTS

EDIT: I forgot to mention also that you need a space here after TABLE like this: ("CREATE TABLE "
Also, you need a space after INTO like this: "INSERT INTO "

 

[mc73]

I'm trying to understand... You want to delete a table and recreate it, or you want to create it in case it doesn't exist? If it's the second, you should use

create table if not exists yourTable (and so on...)

SQLite Query Language: CREATE TABLE

 

[Sinan Tuzcu]

Replace this line:

SQL1.ExecNonQuery("DROP TABLE IF EXISTS" & ayir2(0) & ")

with this line:

SQL1.ExecNonQuery("DROP TABLE IF EXISTS " & ayir2(0))

Notice the space after EXISTS

EDIT: I forgot to mention also that you need a space here after TABLE like this: ("CREATE TABLE "
Also, you need a space after INTO like this: "INSERT INTO "

only after TABLE ?
and here & ayir2(0) & " VALUES
between & and values?

 

[Mahares]

@Sinan: Here is the code with all the necessary spaces and syntax:

SQL1.ExecNonQuery("DROP TABLE IF EXISTS " & ayir2(0))
SQL1.ExecNonQuery("CREATE TABLE "  & ayir2(0) & " (Nummer TEXT , Name TEXT, Mesaj TEXT , LinkAdres TEXT, Datum TEXT)")
SQL1.ExecNonQuery2("INSERT INTO "  & ayir2(0) & " VALUES(?,?,?,?,?)", Array As Object(ayir2(0), ayir2(1), ayir2(2), ayir2(3),ayir2(4)))

 

[madSac]

you can use

if(table_name.compareto(SQ.ExecQuerySingleResult("Select name From sqlite_master WHERE Type='table' AND name='"& table_name & "'"))==0)then
log("Table exist")
else
log("Table don't exist")
end if

 

[Sinan Tuzcu]

you can use

if(table_name.compareto(SQ.ExecQuerySingleResult("Select name From sqlite_master WHERE Type='table' AND name='"& table_name & "'"))==0)then
log("Table exist")
else
log("Table don't exist")
end if

Helo,

this code doesn't working

 

[madSac]

table_name is name of table .....

SQ.ExecQuerySingleResult("Select name From sqlite_master WHERE Type='table' AND name='"& table_name & "'")

this code returns table name if table exist otherwise it returns null.