Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General Discussion » View Thread |
Messages 1 to 5 of 5 total |
Query generator |
Tue, May 21 2013 8:07 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | I have begun work rewriting my query generator. It started life with DBISAM, was migrated over to ElevateDB and is now being totally rewritten as part of my TMS removal policy.
When its complete (I'm using Tim style timetables - it'll be done when its done - several months at least) if anyone's interested I'll post a copy to the binaries. It will remain, as it is now, fairly simple. It will generate only SELECT queries and where possible filters. It will handle JOINs, selecting the fields to be listed, GROUP BY and ORDER BY clauses. It will also allow for column transformations (eg CAST) and virtual fields. It will depend on the programmer creating a settings file / configuring a component (design time editor in progress) to limit what the use can do. The user interface will be spreadsheet stye where they can specify the WHERE clause linking bits together by AND/OR statements, list the columns they want and specify order and grouping. It will end up being highly specific to ElevateDB and will come with a range of inplace grid editors. I know there are a number of good commercial components out there but 1) my users like the spreadsheet style approach and 2) they always strike me as programmer orientated not end user tools. If anyone is interested please post here. If you think there's something a query generator really should do you can let me know here as well. If you have some great ideas about the user interface I'd like to hear them - I can always learn. Roy Lambert |
Fri, May 31 2013 4:25 AM | Permanent Link |
Adam H. | > I have begun work rewriting my query generator.
I'm always interested for a look in what you do Roy. :+) |
Fri, May 31 2013 5:19 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Adam
>> I have begun work rewriting my query generator. > >I'm always interested for a look in what you do Roy. :+) > Gawd - you'll be sending me apples next Roy |
Thu, Jun 6 2013 3:00 PM | Permanent Link |
Barry | >It started life with DBISAM, was migrated over to ElevateDB and is now being totally rewritten as part of my TMS removal policy.<
Roy, I've been meaning to ask you. Why do you have a "TMS removal policy"? Barry |
Fri, Jun 7 2013 4:34 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Barry
Send me an email and I'll respond off newsgroup Roy Lambert |
This web page was last updated on Saturday, May 4, 2024 at 12:54 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |