Subject: | Re: Multi-Line queries
| Date: | Tue, 12 Jun 2018 15:07:55 -0400
| From: | "Steven Green" <greens@diamondsg.com>
| Newsgroups: | pnews.paradox-dos
|
to simplify part of that.. multi-row queries must have the same structure on
each row (the same checked fields)
--
Steven Green
Myrtle Beach, South Carolina, USA
http://www.OasisTradingPost.com
Collectibles and Memorabilia
Vintage Lego Sets and Parts
- and Paradox support, too
"Bernie van't Hof" wrote in message
news:5b1fddff$1@pnews.thedbcommunity.com...
I've been going around in circles a bit due to lack of rules for handling
self-joins and also multi-row queries.
Does the below make sense and seem reasonable without being too restrictive?
/**
* a table in a query:
* must have at least one row. Each row is TYPE_INSERT, TYPE_DELETE,
TYPE_DISPLAY, TYPE_UPDATE or TYPE_NONE
* has zero or more rows of TYPE_NONE
* has zero or more rows of one only type other than TYPE_NONE
* containing TYPE_NONE and another type is a self-join
* within a table:
* rows of same type must have join links in the same columns
* TYPE_DISPLAY rows must have checks in the same columns
* TYPE_INSERT and TYPE_UPDATE rows must use the same destination columns
*/
On 12/6/18 9:11 am, Michael Kennedy wrote:
> On 11/06/2018 19:55, Bernie van't Hof wrote:
>> Just to let you know I havn't gone away. This discussion prompted a lot
>> of rethink. Still plugging away.
>
> Good!!
>
> Sounds like some real nasty ones are... gestating... ;-)
>
|