Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread Any chance of a SQL editor in the EDBMgr?
Wed, May 25 2011 1:32 PMPermanent Link

Adam Brett

Orixa Systems

I know it is a bit of a beginnerish thing, but I would find it useful to have a visual SQL creation tool to create basic SQL Statements in the form:

SELECT
 P.ID,
 P.CodeProduit,
 P.Nom as Produit,
 T1.Name as ProduitsType,
 P.Description,
 P.Ingredients,
 T.Name as TypeDeCertification,
 P.Prix,
 P.DateCreated,
 P.Current
FROM
   Produits P
   LEFT JOIN Types T ON (P.TypeDeCertificationID=T.ID)
   LEFT JOIN Types T1 ON (P.ProduitsTypeID=T1.ID)

... it would be a simple window the user opens, which lists Tables & Views & allows the user to link them & select the fields. There ought to be a pane to see the SQL which would result.

I actually have one of these in an application I used to use to manage DBISAM databases. I haven't redeveloped this tool to work with EDB, because so much of what it does is done better by EDBMgr. But this visual SQL tool is something that is missing.

I have the code for the visual SQL tool in my app ... so I could "slot" it into EDBMgr if that was OK?
Thu, May 26 2011 3:18 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Adam


One of the tings I'm hoping Tim will do is build an addon capability into EDBManager then loonies like us could provide some wonderful functionality (or destruction if that's the way your mind works - sound of mad evil laughter)


Roy Lambert
Tue, May 31 2011 3:20 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Adam,

<< I know it is a bit of a beginnerish thing, but I would find it useful to
have a visual SQL creation tool to create basic SQL Statements in the form:
>>

I'm thinking about adding one.  Until now, it's just been something that has
been "nice, but not necessary".

--
Tim Young
Elevate Software
www.elevatesoft.com
Image