Paradox Community

Items in pnews.paradox-dos

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 


Copyright © 2004 thedbcommunity.com