I'm not a hardcore SQL guru so like to have my hand held when generating queries

Are there any graphical query building utilities anyone can recommend for ElevateDB? The nearest thing I have found is Flyspeed from "Active
Database software" but it doesn't support ElevateDB (yet?)

Other than that, it looks like I'll have to buy their "Active Query Builder" component that does support ElevateDB and write my own utility, but that
seems a bit expensive and some work just for what I want  

Thanks for any guidance
IanH

I haven't see much Ian other than Active Query Builder.

TMS does have a Query Builder, but doesn't have EDB support yet and I don't
know if they will get around to it.

Lance


"IanH" <ian@ian-hunter.net> wrote in message
news:C7FEAA63-146D-48EB-8C0B-F65897C0095C@news.elevatesoft.com...
> I'm not a hardcore SQL guru so like to have my hand held when generating
> queries
>
> Are there any graphical query building utilities anyone can recommend for
> ElevateDB? The nearest thing I have found is Flyspeed from "Active
> Database software" but it doesn't support ElevateDB (yet?)
>
> Other than that, it looks like I'll have to buy their "Active Query
> Builder" component that does support ElevateDB and write my own utility,
> but that
> seems a bit expensive and some work just for what I want  
>
> Thanks for any guidance
> IanH
>

Hi,

You can look at http://devtools.korzh.com/eq/vcl/,
http://www.activequerybuilder.com/,
http://fast-report.com/en/products/visual-query-builder.html

I have not tried any of these yet with EDB.

Regards
Trevor Keegan

I haven't played much with Fast Report's Visual Query Builder.  What I was
going to do was try and get it to work with EDB to see how it plays well.

Lance


"Trevor Keegan" <tkeegan@ealink.com> wrote in message
news:43D67DDB-5A2F-4A15-9B2B-991A48E960A5@news.elevatesoft.com...
> Hi,
>
> You can look at http://devtools.korzh.com/eq/vcl/,
> http://www.activequerybuilder.com/,
> http://fast-report.com/en/products/visual-query-builder.html
>
> I have not tried any of these yet with EDB.
>
> Regards
> Trevor Keegan
>

One of the problems I have with all of the query builders I looked at years ago was that they are more targeted at developers than end users so I rolled my own for DBISAM and have upgraded it to ElevateDB and incorporated the TMS components so it looks prettier.

It simple, only permits SELECT type queries and is based on a stringgrid so to the end user it looks a bit like a spreadsheet. It doesn't do any of the clever things like HAVING or even GROUP BY but it does produce nice queries, single and multi table and is easy to set up and manage.

Anyone wanting a copy of the code is welcome, but you'll need ElevateDB and TMS.

Roy Lambert

Hello Roy,

I have tried KORZH and FR Query Builder with EDB but unsuccessful. With DBISAM works the KORZH Quuery Builder perfect.

Now I have EDB and TMS. Would you be so kind and send me a copy of your code?

TIA
Dieter Nagy



Roy Lambert [Team Elevate] wrote:

One of the problems I have with all of the query builders I looked at years ago was that they are more targeted at developers than end users so I
rolled my own for DBISAM and have upgraded it to ElevateDB and incorporated the TMS components so it looks prettier.

It simple, only permits SELECT type queries and is based on a stringgrid so to the end user it looks a bit like a spreadsheet. It doesn't do any of
the clever things like HAVING or even GROUP BY but it does produce nice queries, single and multi table and is easy to set up and manage.

Anyone wanting a copy of the code is welcome, but you'll need ElevateDB and TMS.

Roy Lambert

Dieter


I'll post the code to the binaries. Since its homebrew there will probably be some bits missing. If you let me know what thay are I'll add them to the post. Also if you find any bugs I'll try and fix them. Feature requests are yours to worry about since it does what I want.


Roy Lambert

Thanks Roy!

Dieter Nagy




Roy Lambert wrote:

Dieter


I'll post the code to the binaries. Since its homebrew there will probably be some bits missing. If you let me know what thay are I'll add them to
the post. Also if you find any bugs I'll try and fix them. Feature requests are yours to worry about since it does what I want.


Roy Lambert

If you are using MS Visual Studio, why not use that for your QBE work? VS2008 rewrites
selects with inner joins which stinks but Tim's next release addresses the rewrites. There
was something about VS using ODBC style joins... considering I've never done any ODBC work
of significance I can't really elaborate with any value. Sorry.

If Tim's next release keeps inner joins as inner joins, VS's built in query work is pretty
cool.


jr