Subject: | Re: one I missed
| Date: | Fri, 20 Dec 2019 08:24:06 -0500
| From: | "Steven Green" <greens@diamondsg.com>
| Newsgroups: | pnews.paradox-dos
|
you can put insert, delete, or check in that first column.. insert requires
more detail in the fields, of course, but the other two work fine all by
themselves
--
Steven Green
Myrtle Beach, South Carolina, USA
http://www.OasisTradingPost.com
Collectibles and Memorabilia
Vintage Lego Sets and Parts
- and Paradox support, too
"Michael Kennedy" wrote in message
news:5dfbe696$1@pnews.thedbcommunity.com...
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
|