Query Builder Questions

Questions related to using nuBuilder Forte.

Query Builder Questions

Postby treed » Fri Oct 23, 2020 5:57 am

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!
treed
 
Posts: 59
Joined: Mon May 18, 2020 7:32 am

Re: Query Builder Questions

Postby kev1n » Fri Oct 23, 2020 4:11 pm

1. Add it in the Clause field:

where_or.png
where_or.png (15.87 KiB) Viewed 187 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)
If you like nuBuilder, please leave a review on SourceForge

nuBuilder Code Library (82)
Installation Guides
Updating nuBuilder

Join Discord to talk about nuBuilder!
kev1n
 
Posts: 1084
Joined: Mon Oct 15, 2018 2:13 am

Re: Query Builder Questions

Postby treed » Sat Oct 24, 2020 6:41 am

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?
treed
 
Posts: 59
Joined: Mon May 18, 2020 7:32 am

Re: Query Builder Questions

Postby kev1n » Sat Oct 24, 2020 2:05 pm

Double-clicking on a popup header will maximize the window.
If you like nuBuilder, please leave a review on SourceForge

nuBuilder Code Library (82)
Installation Guides
Updating nuBuilder

Join Discord to talk about nuBuilder!
kev1n
 
Posts: 1084
Joined: Mon Oct 15, 2018 2:13 am

Re: Query Builder Questions

Postby kev1n » Sun Oct 25, 2020 5:32 pm

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)
If you like nuBuilder, please leave a review on SourceForge

nuBuilder Code Library (82)
Installation Guides
Updating nuBuilder

Join Discord to talk about nuBuilder!
kev1n
 
Posts: 1084
Joined: Mon Oct 15, 2018 2:13 am

Re: Query Builder Questions

Postby treed » Tue Oct 27, 2020 5:22 am

kev1n wrote:Double-clicking on a popup header will maximize the window.

That works. Thanks.
treed
 
Posts: 59
Joined: Mon May 18, 2020 7:32 am


Return to General