Error 5 in SQL-Statement

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
Elei

Error 5 in SQL-Statement

Post by Elei » Fri 07 Jan 2005 08:46

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()

Elei

Error

Post by Elei » Fri 07 Jan 2005 09:03

Hi everybody,


I found the problem. There are differences between Access and MySQL-Statements


Elmar

Post Reply