writing query builder

Question

writing query builder

sqlpro

Hall of Fame

Points: 3859
More actions
November 30, 2005 at 7:58 pm

#89984

Hi friends
am writing a tool for our application that allows user write their own queries ofcourse they dont know sql but we need provide some sql server type "query designer" type functionality where users can select fields/tables and as u know sql server builds query as we go.
i heard that sql server that functionaly thru some objects (i think its SMO) and my question is does any one has some examples or links and any advise ?
Thanks for your help

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

vadba SSChampion Points: 11133 More actions · Answer 1

You're probably referring to SQL-DMO (SQL Distributed Management Objects). Look this up in SQL Server Books Online (BOL) - there is a lot reference material there. Although, SQL-DMO is primarily for administration tasks.

Or, maybe you mean ADO, which you would use with VB, for example.

Rudyx - the Doctor SSC-Forever Points: 43695 More actions · Answer 2

SQL-DMO --> SQL 2000, SQL v7.0

SQL-SMO --> SQL 2005

RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

sqlpro Hall of Fame Points: 3859 More actions · Answer 3

Thanks for your posts Rudy and mkeast.

actually I need some ideas how to design/write a query builder .

it can be SMO ,DMO or whatever but need starting point how one can start building it.

Thanks for you advise .

philcart SSC-Forever Points: 47794 More actions · Answer 4

Why build what has already been built?

Check the websites like http://www.componentsource.com

--------------------
Colt 45 - the original point and click interface

sqlpro Hall of Fame Points: 3859 More actions · Answer 5

Thanks for the link Phill. I gone thru site but did not find any product that related my requirement.they've huge list of products!!

Anyway my boss would not like to buy any 3rd party component as we r already over the budget.

and we dont need any of the complex functionality that 3rd party products so we wanted write our own.

Any ideas on where to start is much appreciated

Thanks .

Aman Soni Old Hand Points: 342 More actions · Answer 6

Are you using 200 or 2005. SQL Reporting Services has the Report Builder which sounds like just what you're looking for. Check out http://www.microsoft.com/technet/prodtechnol/sql/2005/2005ssrs.mspx

Aman Soni Old Hand Points: 342 More actions · Answer 7

If you're on SQL 2000 try the sample from MSDN, had downloaded a sample earlier, but cant find the link now.

sqlpro Hall of Fame Points: 3859 More actions · Answer 8

Hi Aman

whats the sample name i should be looking for.?

at the moment we are not yet confirmed which version we'll be using (2000 or 2005) but i'll look at both ur suggestions.

Aman Soni Old Hand Points: 342 More actions · Answer 9

Sorry it was actually a walk through. Did post the comment that there should have been a solution download.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/AdHocRepSr.asp

sqlpro Hall of Fame Points: 3859 More actions · Answer 10

Thanks for that Aman.

at the moment am looking Report builder utility (sql server 2005) and it looks promising from our initial research.

am just wondering if anyone knows how to link 2 views when creating report model. Seems we can use UDM to achieve this but cant find how to do that.

Any ideas much appreciated.

Thanks for your help.