Hello Tim,

Thanks for clearing that up for me. Sometimes I'm pretty thick!

I really like the ability to copy actual fields from line 1 to line 2!

This option seems to be available in the standard query window, so there
seems to be no reason to have a separate menu item for query by formula?

Thanks,
Alan

On Thu, Jan 17, 2019 at 3:14 PM Tim Nevels via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> On Jan 17, 2019, at 1:57 PM, Alan Tilson wrote:
>
> > I'm not sure what you mean. The window had 2 or 3 boxes per line. The
> first
> > one seems only to allow fields to be entered. The 2nd for non-boolean
> > fields is the comparison box, equals, is different from, etc. The 3rd is
> a
> > value.
> >
> > This is the default query window created from this code: QUERY SELECTION
> BY
> > FORMULA([Table]). It appears to be exactly the same query window as QUERY
> > SELECTION([Table]).
> >
> > If you have something that works please let me know what steps to go
> > through to do it!
> >
> > Ps My understanding is that we cannot send images here. Is that still
> true?
>
> To access the query by formula option in the new query editor you need to
> option-click on the “+” button at the far right of a line. When you do
> that, you get a new query line that allows you to enter a formula. You can
> delete the first line in the query editor with the “-“ button.
>
> An interesting and hidden feature of the new query editor is that you can
> mix field lines and formula lines into a single query.
>
> And no, you cannot send images to this message board. You have to pass a
> link to something like this:
>
>
> https://www.dropbox.com/s/aerxv021dfzllxz/Screen%20Shot%202019-01-17%20at%202.09.45%20PM.PNG?dl=0
>
> Tim
>
> *****************************************
> Tim Nevels
> Innovative Solutions
> 785-749-3444
> timnev...@mac.com
> *****************************************
>
> **********************************************************************
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **********************************************************************
**********************************************************************
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**********************************************************************

Reply via email to