Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Enhancement Requests and Suggestions » View Thread |
Messages 1 to 3 of 3 total |
Any chance of a SQL editor in the EDBMgr? |
Wed, May 25 2011 1:32 PM | Permanent 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 AM | Permanent Link |
Roy Lambert NLH Associates 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 |
This web page was last updated on Thursday, March 28, 2024 at 08:36 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |