Re: Error: Not the correct way to delete records.

[Phillip Ward]

You don't say which client tool you're using to write this statement.

Is there anything else before this in the "editor"?
If there is, then the tool might be trying to read the DELETE as a keyword to the preceding command, rather than a statement in its own right.

SELECT * 
FROM MyTable    <-- No semicolon to end the select
 
DELETE          <-- Delete doesn't "go" on the end of a "select". ERROR
FROM MyTable ...

Regards, Phill W.