Page 1 of 1

Query Builder Questions

PostPosted: Fri Oct 23, 2020 5:57 am
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

PostPosted: Fri Oct 23, 2020 4:11 pm
by kev1n
1. Add it in the Clause field:

where_or.png
where_or.png (15.87 KiB) Viewed 292 times


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

PostPosted: Sat Oct 24, 2020 6:41 am
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

PostPosted: Sat Oct 24, 2020 2:05 pm
by kev1n
Double-clicking on a popup header will maximize the window.

Re: Query Builder Questions

PostPosted: Sun Oct 25, 2020 5:32 pm
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

PostPosted: Tue Oct 27, 2020 5:22 am
by treed
kev1n wrote:Double-clicking on a popup header will maximize the window.

That works. Thanks.