Delete SQL statement

[Jeong]

There occurs in delete sql.
sql statement is like following.
--------------------------------------------------
cmd.CommandText = "Delete * from sampletbl WHERE (Id='" & vId & "' AND date = '" & vDate & "' AND seq = '" & vSeq & "')"
--------------------------------------------------
vId, vDate, vSeq are variables.
I don't know what's the problem.
Could anyone who know about SQL let me know?
I'm sorry I might asked so basic question.

Programmer.
Multimedia/Image Processing/FA/CADCAM
C,V/B,V/C++

[michi]

Change 'Delete * from ' to 'Delete from'

Regards,

Michi

[Boumxyz2]

When you use a date field don't use it as a string if it is of type date in your database.

' AND date = '" & vDate & "' this won't work

Use # instead of '

"' AND date =#" & vDate &"#

this should work