Paradox Community

Items in pnews.paradox-dos

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


Copyright © 2004 thedbcommunity.com