Paradox Community

Items in pnews.paradox-dos

Subject:Re: Multi-Line queries
Date:Wed, 13 Jun 2018 00:51:42 +1000
From:Bernie van't Hof <>
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
  *   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...  ;-)

Copyright © 2004