Re: Help with DELETE Statement
- From: "Mike" <Mike@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 16 Aug 2005 09:53:01 -0700
Perfect - Thanks for pointing me in the right direction.
"Paul Pedersen" wrote:
> That BETWEEN structure can be used with SQL statements, but not with DELETE
> FOR. Use BETWEEN() instead.
>
>
>
> "Mike" <Mike@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:73007EB4-DD2B-4844-B6C9-6D01FC6341CB@xxxxxxxxxxxxxxxx
> > When I run the below DELETE statement I receive the error message "Command
> > contains unrecognized phrase/keyword." Can someone please tell me how I'm
> > formatting this incorrectly? This statement should delete only records
> > where
> > the FOR statement and WHILE statement are .T. Thanks.
> >
> > DELETE FOR md_loc_id = 'CF16' WHILE md_mo_seq BETWEEN '555' AND '560'
>
>
>
.
- Follow-Ups:
- Re: Help with DELETE Statement
- From: Cindy Winegarden
- Re: Help with DELETE Statement
- References:
- Help with DELETE Statement
- From: Mike
- Re: Help with DELETE Statement
- From: Paul Pedersen
- Help with DELETE Statement
- Prev by Date: Re: Help with DELETE Statement
- Next by Date: Re: I have a very simple question...
- Previous by thread: Re: Help with DELETE Statement
- Next by thread: Re: Help with DELETE Statement
- Index(es):
Relevant Pages
|
