Hi everybody
I get the error: You have an error in your SQL syntax near '* from tboknt' at line 1
Can you please help me?
Thank you
Elmar
Statements:
glcon = New MySqlConnection("User ID=Elei;Password=xxxx;Host=localhost;Port=3306;Database=dbaddr;Direct=true;Protocol=TCP;Compress=false;Pooling=true;Min Pool Size=0;Max Pool Size=100;Connection Lifetime=0")
glcon.Open()
wksqls = "DELETE * FROM tboknt;"
glcom = Nothing
glcom = New MySqlCommand(wksqls, glcon)
glcom.CommandType = CommandType.Text
glcom.ExecuteNonQuery()
glcom.Dispose()