Re: Error on DELETE

Your delete should look something like:
delete from main where name = 'M K'
....you're missing the quotes.

John

.

Relevant Pages

  • Re: XP Pro Upgrade or full version?
    ... Bruce Chambers wrote: ... > John wrote: ... >> something missing. ... Prev by Date: ...
    (microsoft.public.windowsxp.basics)
  • Help: Part numbers needed for Pinball Magic
    ... have the one from IPDB and it's missing two part numbers. ... John ... Prev by Date: ...
    (rec.games.pinball)
  • Re: Simple SQl question
    ... John ... > OK, I must have been doing somethign else wrong, because now it's ... Prev by Date: ...
    (comp.databases.ms-sqlserver)
  • Re: Fastcode CompareStr B&V 2.0
    ... > Table for the open challenge part is missing. ... Hi Dennis, ... John ... Prev by Date: ...
    (borland.public.delphi.language.basm)
  • Incrementing Days between two dates..
    ... Is there a way I can write a query which will return those two days and ... create further records for the missing days? ... John ... Prev by Date: ...
    (microsoft.public.access.queries)