Welcome to the nuBuilder Forums!

Join our community by registering and logging in.
As a member, you'll get access to exclusive forums, resources, and content available only to registered users.

SQL Builder

Questions related to using nuBuilder Forte.
Locked
Timo
Posts: 221
Joined: Thu Mar 15, 2018 9:26 pm
Has thanked: 1 time

SQL Builder

Unread post by Timo »

Hi, I'd like to understand where a SQL statement created in the SQL Builder can be used. I created a sql statement ( Home -> SQL Builder ), entered a description and saved the record.
As you know, there is a button "SQL Builder" in the form properties. When I open the SQL Builder through this button, I don't see the sql statement that I saved. I couldn't figure out from the wiki entry how this should work either. Can someone explain that to me?
Thanks in advance.
Top
admin
Site Admin
Posts: 2829
Joined: Mon Jun 15, 2009 2:23 am
Been thanked: 30 times

Re: SQL Builder

Unread post by admin »

Timo,

They can be used when creating reports.

https://wiki.nubuilder.cloud/ ... orts#Table

Steven
Top
Timo
Posts: 221
Joined: Thu Mar 15, 2018 9:26 pm
Has thanked: 1 time

Re: SQL Builder

Unread post by Timo »

At the moment I have no idea how use a stored SQL code. Haven't found an example or instructions. I'll have to deal with it later when I get into reporting.
Top
admin
Site Admin
Posts: 2829
Joined: Mon Jun 15, 2009 2:23 am
Been thanked: 30 times

Re: SQL Builder

Unread post by admin »

Timo,

Does this make more sense?
report_data.PNG
Steven
You do not have the required permissions to view the files attached to this post.
Top
Timo
Posts: 221
Joined: Thu Mar 15, 2018 9:26 pm
Has thanked: 1 time

Re: SQL Builder

Unread post by Timo »

Thanks - got it. A picture says more than a thousand words.
Top
admin
Site Admin
Posts: 2829
Joined: Mon Jun 15, 2009 2:23 am
Been thanked: 30 times

Re: SQL Builder

Unread post by admin »

.
Top
Locked

Return to “General”