[RESOLVED] delete a field contents

[Muddy]

Why does this delete the contents of all the fields in myTable instead of just the field myField???? How can I delete the contents of a single field using adodb.command??

Dim cmd As New ADODB.Command
cmd.CommandText = "DELETE myField FROM myTable"
cmd.Execute

Thanks for any help!!!

[Armbruster]

Delete is used to delete the entire record

I think you want something like:

cmd.CommandText = "UPDATE myTable SET myField =  ' '  "

[Static]

Delete can be used to delete all or a single row

single row:
DELETE FROM myTable WHERE MyField = 'whatever'

or

DELETE * FROM MyTable (This deletes all!!)

but if you want to just 'blank out' that field..then use Update

[Muddy]

Thanks all !