The Query is run from code; no forms involved. “Execute Query by Formula on
Server” is Off (the same problem happens when it is On). I also tried using SQL
joins for Query By Formula but it made no difference.
Interestingly, this bug goes back to at least 4D v13 yet no one else seems to
have
thank you for the correction and clarification!
incidentally, is the query executed from a UI (i.e. running the query on a
table form)?
what is the status of the "execute formula on server" compatibility setting?
2018/08/03 2:47、Richard Wright via 4D_Tech
The selection of One records is not changed based on the Many records, the
selection is lost.
Further in the documentation it states:
> Some of the commands listed in the previous table (such as the query
> commands) load a current record after the task is completed. In this case,
> the
I missed that part...
On Thu, 02 Aug 2018 10:14:33 -0500, Tim Nevels via 4D_Tech wrote:
>
> So would you expect it to work the same in single-user and client/server?
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing
On Aug 2, 2018, at 9:12 AM, Chip Scheide wrote:
> with the auto many to one
> I would *expect* the selection in the one table to be changed, after
> running a query on the many table. I would also expect that the one
> table record would be the one (in the one to many) of the first record
>
On Aug 2, 2018, at 9:12 AM, Richard Wright wrote:
> I just ran into a problem where running a Query By Formula bug in
> Client/Server that has apparently been around for a long time:
>
> Client/Server
> Two related tables and automatic many-to-one is turned on
>
> 1. Select a record in the
with the auto many to one
I would *expect* the selection in the one table to be changed, after
running a query on the many table. I would also expect that the one
table record would be the one (in the one to many) of the first record
in the many.
I am not sure as I do not use Query by formula
according to the documentation:
http://doc.4d.com/4Dv17/4D/17/About-Relations.300-3730102.en.html
QUERY BY FORMULA "will use existing automatic Many-to-One relations" and "will
use automatic One-to-Many relations"
so as soon as a record of the many table becomes current, it automatically
I just ran into a problem where running a Query By Formula bug in Client/Server
that has apparently been around for a long time:
Client/Server
Two related tables and automatic many-to-one is turned on
1. Select a record in the One table
2. Run a standard query to get the related records in
9 matches
Mail list logo
