Subject: | Re: one I missed
| Date: | Thu, 19 Dec 2019 21:07:33 +0000
| From: | Michael Kennedy <Info@KennedySoftware.ie>
| Newsgroups: | pnews.paradox-dos
|
On 19/12/2019 16:51, Bernie van't Hof wrote:
> Here's one I didn't prepare for:
>
> Query
> Tmp |
> delete |
> Endquery
> Do_It!
>
> Works just fine in pdoxDOS.
> Deletes the contents of Tmp (into Deleted)
Obviously, an Empty command should be used (for speed, etc), unless the
deleted records are still needed in the Deleted table?
I'd guess I've never used that syntax, but I have often used the
Delete-Query, to delete SOME of the records, and, of course, that might
sometimes result in deleting ALL the records, if they all matched the
selection parms.
- Michael
|