473,320 Members | 1,804 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

3rd Pary Visual Query Builder?

Does anyone know of or have a favourite 3rd party Visual Query
Builder? We are looking for a very easy to use interface that
provides SQL code verification, table joins etc.

Thanks,

Dave

Oct 25 '07 #1
6 3933
On 25 Ott, 17:14, FrozenDude <dsal...@inco.comwrote:
Does anyone know of or have a favourite 3rd party Visual Query
Builder? We are looking for a very easy to use interface that
provides SQL code verification, table joins etc.

Thanks,

Dave
why not sql server management studio? with sql express it's free.

Oct 25 '07 #2
ciroteo wrote:
On 25 Ott, 17:14, FrozenDude <dsal...@inco.comwrote:
>Does anyone know of or have a favourite 3rd party Visual Query
Builder? We are looking for a very easy to use interface that
provides SQL code verification, table joins etc.

Thanks,

Dave

why not sql server management studio? with sql express it's free.
Better than what is built into Access?
Oct 25 '07 #3
Bob Alston <bo********@yahoo.comwrote in news:hL8Ui.84$Ob.66
@newsfe02.lga:
ciroteo wrote:
>On 25 Ott, 17:14, FrozenDude <dsal...@inco.comwrote:
>>Does anyone know of or have a favourite 3rd party Visual Query
Builder? We are looking for a very easy to use interface that
provides SQL code verification, table joins etc.

Thanks,

Dave

why not sql server management studio? with sql express it's free.
Better than what is built into Access?
Much better.

--
lyle fairfield
Oct 25 '07 #4

The *only* third party SQL tool I've ever heard of anyone (I trust)
use was called "WinSQL". I remember being told it was freeware,
although they wanted you to register.

I remember being shown the tool once, and it was visual (more like SQL
Enterprise Manager then Access), and I remember thinking it was pretty
cool, but I didn't have a need for it when it was being shown to me,
and I pretty much forgot about it until just now.

Personally, I've never really found a need for it, but.....

(I carry EiSQLw on my flash drive, and it works quite well for me, but
it isn't a "visual" tool.)

Search for "WinSQL" at your favorite search engine, and let us know if
you like it.
On Thu, 25 Oct 2007 08:14:39 -0700, FrozenDude <ds*****@inco.com>
wrote:
>Does anyone know of or have a favourite 3rd party Visual Query
Builder? We are looking for a very easy to use interface that
provides SQL code verification, table joins etc.

Thanks,

Dave
Please Post Any Replies To This Message Back To the Newsgroup.
There are "Lurkers" around who can benefit by our exchange!
Oct 25 '07 #5
"FrozenDude" <ds*****@inco.comwrote
Does anyone know of or have a favourite 3rd party
Visual Query Builder? We are looking for a very
easy to use interface that provides SQL code verifi-
cation, table joins etc.
What "flavor" of SQL? Everybody's got their own little nuances.

For Access, the Access Query Builder is peachy keen.

For Microsoft SQL Server, there's a very nice Enterprise Manager.

Several years ago, I did some work with Informix and don't recall that it
included a Visual Query Builder, nor that the prime contractor on that
project licensed a third-party one. The DBA, perhaps a little grudgingly,
allowed me to create some Views to force server-side processing on some
modestly complex queries for reports, and that was an exercise in "SQL
Masochism" because I just had to sit there with nothing but the equivalent
of notepad and my bare brain and write SQL _from scratch_.

He used a third-party data modeling system, ERWIN, to design, redesign, and
implement the tables and relationships -- I don't remember what it cost,
exactly, but I do remember it was NOT "cheap". There are quite a number of
others, too, and, from my observation, all are expensive, but even so, there
are tiers of pricing... ranging from "just plain expensive" to
"flabbergastingly outrageously expensive." But that isn't what you are
asking about, I think.

Larry Linson
Microsoft Access MVP
Oct 26 '07 #6
On 25 Ott, 17:14, FrozenDude <dsal...@inco.comwrote:
Does anyone know of or have a favourite 3rd party Visual Query
Builder? We are looking for a very easy to use interface that
provides SQL code verification, table joins etc.

Thanks,

Dave
Here (free):

http://www.datatime.eu/DataTimeUniversal.htm
http://www.datatime.eu/download.aspx

For problems/questions: http://groups.google.it/group/DataTime

-P

Oct 26 '07 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

15
by: Chris | last post by:
I am just beginning programming again and need a bit of advice. I have both Visual C++ 6.0 Standard Edition and Borland C++ Builder 6. Of these two which do you consider the best for programming...
2
by: Joe Del Medico | last post by:
I have two tables A & B and I want to delete all the records in A that are not in B. Can I do this in the query builder? It seems like a simple problem. I can easily find the records in A that...
1
by: MR | last post by:
Is there a limitation to the number of columns you can define in the Query Builder of a data adapter? it seems the limit is around 96. i know i can split the query into two parts, but then it would...
1
by: Bob | last post by:
Trying to use VBisual web developer express 2005 beta 2. Dragged an accessdatasource to the blank web page. Started to configure. Entered location of an access database. On next page, clicked...
2
by: MLH | last post by:
I invoked the combo-box wizard today, telling it to use a 4-table union query as a row-source for the combo-box it was assisting me in building. The error I got was without number and stated,...
0
by: sales | last post by:
I am glad to present to the community of this group the new version of our component intended for visual building of SQL queries via an intuitive interface - Active Query Builder...
1
by: Farshid | last post by:
Hi Is there any way to use Visual Studio Query Builder in Windows Forms applications. I think query builder dialog is in Micosoft.VSDesigner assembly but i dont know how to use it. Thank You...
13
by: john | last post by:
I have table User-App and table App Profile User-App App Profile IDuser IDApp IDApp 1 34 34 1 45 45 2 34 2 45 2 90 3 34
0
by: Goofy | last post by:
Ive been playing with these over the last few hours and Im quite impressed how useful they are. However, I was using the query builder to set up a new query for my adapter and found there was no...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.