Page 1 of 1
Query Builder Questions
Posted: Thu Oct 22, 2020 10:27 pm
by treed
How would someone
1. Use the OR clause in a where
2. Remove a join
3. Make the window larger so everything can be seen
Inquiring minds what to know.
Thanks!
Re: Query Builder Questions
Posted: Fri Oct 23, 2020 8:41 am
by kev1n
1. Add it in the Clause field:
where_or.png
2. Good question. I did not find a way to do so.
3. Resize the (SQL) textarea via mouse dragging (works at least in chrome)
Re: Query Builder Questions
Posted: Fri Oct 23, 2020 11:11 pm
by treed
Yes the Text window is resizeable, however when the sql builder is opened from the browse tab of form properties, it opens in a rather small and unsizeable window which makes it rather hard to use. Can this window be made sizeable?
Re: Query Builder Questions
Posted: Sat Oct 24, 2020 6:35 am
by kev1n
Double-clicking on a popup header will maximize the window.
Re: Query Builder Questions
Posted: Sun Oct 25, 2020 9:02 am
by kev1n
treed wrote:How would someone
2. Remove a join
The only way I've found to remove a join is by removing a table. (Which can be added again afterwards)
Re: Query Builder Questions
Posted: Mon Oct 26, 2020 8:52 pm
by treed
kev1n wrote:Double-clicking on a popup header will maximize the window.
That works. Thanks.