Web forum is in read-only mode. Login as active registered customer for write access
  Forum Search   New Posts New Posts

Query builder component?

 Post Reply Post Reply
Author
Kovacevic Zeljko View Drop Down
Senior Member
Senior Member
Avatar

Joined: 28 May 2010
Posts: 288
Post Options Post Options   Quote Kovacevic Zeljko Quote  Post ReplyReply Direct Link To This Post Topic: Query builder component?
    Posted: 29 Oct 2015 at 8:12pm
Do you already have it?
Back to Top
Bruno Fierens View Drop Down
TMS Support
TMS Support
Avatar

Joined: 11 May 2010
Posts: 7969
Post Options Post Options   Quote Bruno Fierens Quote  Post ReplyReply Direct Link To This Post Posted: 29 Oct 2015 at 8:16pm
See:
http://www.tmssoftware.com/site/qs.asp
http://www.tmssoftware.com/site/tmsiwqs.asp
Back to Top
Kovacevic Zeljko View Drop Down
Senior Member
Senior Member
Avatar

Joined: 28 May 2010
Posts: 288
Post Options Post Options   Quote Kovacevic Zeljko Quote  Post ReplyReply Direct Link To This Post Posted: 29 Oct 2015 at 8:27pm
I'm not sure if this is what I need.. More pictures would be helpful though.

For example, my database contains over 170 tables and the biggest problem is how to join them when writing sql query. My users must be able to have the option to choose tables, graphically join 10 or more tables (thus, automatically generating sql in the background), choosing result fields (group, sum etc..).
Back to Top
Bruno Fierens View Drop Down
TMS Support
TMS Support
Avatar

Joined: 11 May 2010
Posts: 7969
Post Options Post Options   Quote Bruno Fierens Quote  Post ReplyReply Direct Link To This Post Posted: 31 Oct 2015 at 9:46am
Our Query builder products use a tree to define tables and joins and tries to represent tables/joins/filters/groups in a natural language form. Not sure what exactly you are visually after, but the focus of our Query builder products is the natural language representation / entry for complex queries.
Back to Top
Kovacevic Zeljko View Drop Down
Senior Member
Senior Member
Avatar

Joined: 28 May 2010
Posts: 288
Post Options Post Options   Quote Kovacevic Zeljko Quote  Post ReplyReply Direct Link To This Post Posted: 31 Oct 2015 at 10:59am
I don't have time to investigate each and every component. I asked nicely for additional pictures that show component's key features but I see it's not gonna happen :)



In short, this is what I need. A classical "view creator" like in sql server management studio.
Back to Top
Kovacevic Zeljko View Drop Down
Senior Member
Senior Member
Avatar

Joined: 28 May 2010
Posts: 288
Post Options Post Options   Quote Kovacevic Zeljko Quote  Post ReplyReply Direct Link To This Post Posted: 31 Oct 2015 at 11:00am
http://i.ytimg.com/vi/NkbCz8g7jsg/maxresdefault.jpg
Back to Top
Bruno Fierens View Drop Down
TMS Support
TMS Support
Avatar

Joined: 11 May 2010
Posts: 7969
Post Options Post Options   Quote Bruno Fierens Quote  Post ReplyReply Direct Link To This Post Posted: 31 Oct 2015 at 1:04pm
As I explained, our Query builder provides a natural language interface, not a visual / graph based interface.
Back to Top
Kovacevic Zeljko View Drop Down
Senior Member
Senior Member
Avatar

Joined: 28 May 2010
Posts: 288
Post Options Post Options   Quote Kovacevic Zeljko Quote  Post ReplyReply Direct Link To This Post Posted: 31 Oct 2015 at 1:09pm
Thanks. I'll look elsewhere.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down