Welcome to the nuBuilder Forums!

Register and log in to access exclusive forums and content available only to registered users.

Query Builder Questions

Questions related to using nuBuilder Forte.
Post Reply
treed
Posts: 205
Joined: Mon May 18, 2020 12:02 am
Been thanked: 2 times
Contact:

Query Builder Questions

Unread post 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!
kev1n
nuBuilder Team
Posts: 4307
Joined: Sun Oct 14, 2018 6:43 pm
Has thanked: 71 times
Been thanked: 448 times
Contact:

Re: Query Builder Questions

Unread post 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)
You do not have the required permissions to view the files attached to this post.
treed
Posts: 205
Joined: Mon May 18, 2020 12:02 am
Been thanked: 2 times
Contact:

Re: Query Builder Questions

Unread post 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?
kev1n
nuBuilder Team
Posts: 4307
Joined: Sun Oct 14, 2018 6:43 pm
Has thanked: 71 times
Been thanked: 448 times
Contact:

Re: Query Builder Questions

Unread post by kev1n »

Double-clicking on a popup header will maximize the window.
kev1n
nuBuilder Team
Posts: 4307
Joined: Sun Oct 14, 2018 6:43 pm
Has thanked: 71 times
Been thanked: 448 times
Contact:

Re: Query Builder Questions

Unread post 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)
treed
Posts: 205
Joined: Mon May 18, 2020 12:02 am
Been thanked: 2 times
Contact:

Re: Query Builder Questions

Unread post by treed »

kev1n wrote:Double-clicking on a popup header will maximize the window.
That works. Thanks.
Post Reply