SQL DELETE statement problem

[VRIT]

Dear all,

I am having a problem with a DELETE statement:

The Table is called EngineerName
The Column\Field I want to delete from is called Engineer Name

The statement which has a problem is:

ED = "DELETE EngineerName WHERE [Engineer Name] = '" & LstEngineers.Text & "'"

I think the error is with the [Engineer Name] but I dont know how to correc it.

Many thanks in advance

VRIT

 

[sjn78]

Not sure about SQL but maybe this

ED = "DELETE FROM EngineerName WHERE [Engineer Name] = '" & LstEngineers.Text & "'"

 

[VRIT]

Thats for that but it still does not work. I am sure it is to do with the field Engineer Name. It is the only one I have trouble with and its the only one which has a double name(ie Engineer Name) all the others are single names (i.e Location).

Any further ideas welcome.

Thanks

VRIT

 

[woyler]

what does the SQL statment look like after the LstEngineers.Text value has been resolved? (Break on it in debug after the SQL and type ? ED)

 

[VRIT]

Gentlemen,

Thanks for your help. I recreated the Engineer table and instead of having 'Engineer Name' as a field I used 'Engineer_Name', that seemed to solve it, so it was something to do with the way [Engineer Name] was entered into the statement.

Thanks anyway.

VRIT