Initialize a Table

[Joel]

Hi,

I'd like to initialize a table.
This is the code:

With rstArtrprt
If .State = 1 Then .Close
.Open "Delete * From Artrprt", cnnOdbc, adOpenKeyset,
adLockOptimistic
End With

I get an Sql Syntax error. What should I do?

[Bill Karwin]

Joel wrote:

"Delete * From Artrprt"
I get an Sql Syntax error. What should I do?

There's no * syntax for the DELETE statement; there is no need for it,
since you can't delete individual columns, you can only delete whole
rows. You probably want "Delete From Artrprt".

Review the documentation for DELETE for more information:
http://dev.mysql.com/doc/mysql/en/DELETE.html

Tip: when deleting the entire contents of a table, if there are a lot of
data in the table, you might find it is quicker to use "DROP TABLE
Artrprt" and then recreate it with your original "CREATE TABLE". Either
way will work.

Regards,
Bill K.

[Joel]

Thank you Bill

"Bill Karwin" <bi**@karwin.com> wrote in message
news:cs*********@enews3.newsguy.com...

Joel wrote:

"Delete * From Artrprt"
I get an Sql Syntax error. What should I do?

There's no * syntax for the DELETE statement; there is no need for it,
since you can't delete individual columns, you can only delete whole
rows. You probably want "Delete From Artrprt".

Review the documentation for DELETE for more information:
http://dev.mysql.com/doc/mysql/en/DELETE.html

Tip: when deleting the entire contents of a table, if there are a lot of
data in the table, you might find it is quicker to use "DROP TABLE
Artrprt" and then recreate it with your original "CREATE TABLE". Either
way will work.

Regards,
Bill K.