Query Builder Questions

Questions related to using nuBuilder Forte.

Query Builder Questions

Unread 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: 95
Joined: Mon May 18, 2020 7:32 am

Re: Query Builder Questions

Unread 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 488 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)
kev1n
nuBuilder Team
 
Posts: 1718
Joined: Mon Oct 15, 2018 2:13 am
nuBuilder Version: 4.5

Re: Query Builder Questions

Unread 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: 95
Joined: Mon May 18, 2020 7:32 am

Re: Query Builder Questions

Unread postby kev1n » Sat Oct 24, 2020 2:05 pm

Double-clicking on a popup header will maximize the window.
kev1n
nuBuilder Team
 
Posts: 1718
Joined: Mon Oct 15, 2018 2:13 am
nuBuilder Version: 4.5

Re: Query Builder Questions

Unread 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)
kev1n
nuBuilder Team
 
Posts: 1718
Joined: Mon Oct 15, 2018 2:13 am
nuBuilder Version: 4.5

Re: Query Builder Questions

Unread 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: 95
Joined: Mon May 18, 2020 7:32 am


Return to General

Who is online

Users browsing this forum: No registered users and 18 guests

cron