TIM - what is your current status on including a visual query builder
in EDB v2?

Unfortunately, I'm still stuck in SQL Kindergarten. It's evident,
though, I'll need to do some serious studying up since you've made EDB
alot more SQL-dependent, but nevertheless, a query builder would indeed
be a tremendous help and to also learn from esp. for us novices.

Anyway, I did a search for any comments on one and the last post I
could find where you mentioned something about it was on June 27, 2008:


"From: "Tim Young [Elevate Software]" <timyoung@elevatesoft.com>
Subject: Re: ElevateDB on Compact Framework
Date: Fri, 27 Jun 2008 17:45:14 -0400
Message-ID: <F33678EA-36A9-40D3-9D2D-D14222F509F6@news.elevatesoft.com>
Lines: 29

Isaac,

....

<< - Query Builder  >>

This on the list, but not a high-priority item.

...."


Cheers,
Fred

Fred


If you have TMS controls as well as ElevateDB I loaded my simple query builder into the binaries - it only does selects.

Roy Lambert

Fred,

<< TIM - what is your current status on including a visual query builder in
EDB v2? >>

Same situation, on the list but not high on the list.

<< Unfortunately, I'm still stuck in SQL Kindergarten. It's evident,
though, I'll need to do some serious studying up since you've made EDB alot
more SQL-dependent, but nevertheless, a query builder would indeed be a
tremendous help and to also learn from esp. for us novices. >>

The only difference between DBISAM and EDB in terms of the necessity of SQL
is with the DDL and administrative statements.  You don't need to use SQL
for selection or inserts, updates, or deletes unless you want to.  Also, the
DDL statements that EDB executes when you take actions in the manager are
logged in the SQL History under Explorer..SQL History, so you can do
something in the manager and immediately copy the generated SQL used by the
EDB Manager into your application.

--
Tim Young
Elevate Software
www.elevatesoft.com

yep, I see your upload in the Binaries, Roy, but unfortunately won't be
able to check out your source since I don't have any of the TMS stuff.
I have DevExpress stuff, but not TMS.

Can you upload a zipped compiled version of it, though?  I would still
like to have a lookie at your app anyway.

Thanks,
Fred

--



Roy Lambert wrote:

> Fred
>
>
> If you have TMS controls as well as ElevateDB I loaded my simple
> query builder into the binaries - it only does selects.
>
> Roy Lambert

> << TIM - what is your current status on including a visual query
> builder in EDB v2? >>
>
> Same situation, on the list but not high on the list.

ok cool, but for whatever it's worth though.... + 10 on this feature
from me. =D

> << Unfortunately, I'm still stuck in SQL Kindergarten. It's
> evident, though, I'll need to do some serious studying up since
> you've made EDB alot more SQL-dependent, but nevertheless, a query
> builder would indeed be a tremendous help and to also learn from esp.
> for us novices. >>
>
> The only difference between DBISAM and EDB in terms of the necessity
> of SQL is with the DDL and administrative statements.  You don't need
> to use SQL for selection or inserts, updates, or deletes unless you
> want to.  Also, the DDL statements that EDB executes when you take
> actions in the manager are logged in the SQL History under
> Explorer..SQL History, so you can do something in the manager and
> immediately copy the generated SQL used by the EDB Manager into your
> application.

For my case...I need it more for helping to create (read only) queries
(views?) to present on a grid or for a report.  It's just alot easier
doing it graphically than trying to code it by hand, which I've done
before, but it's time consuming for me since I'm not a SQL guru and
have to do alot of back and forth referencing and trial and error.  I
guess I'm spoiled by my days of using MS Access; I used their Query
Builder all the time and was extremely helpful in whipping out quick
Queries.

With the new Views, Triggers and Procedures stuff in EDB, though...I
need to learn about those and how I can use them in my database apps.

Thanks,
Fred

"Fred H." <blue@dhfvr.com> wrote in message
news:3438E4B0-06A6-403B-B3FE-320F2E0A8E0A@news.elevatesoft.com...
> Can you upload a zipped compiled version of it, though?  I would still
> like to have a lookie at your app anyway.
>

Hi Fred there is a couple of freeware QB's on Torry with code.
HTH
Rita

Fred

>Can you upload a zipped compiled version of it, though? I would still
>like to have a lookie at your app anyway.

Not really since it isn't an app, its just code I use in apps to provide an end user query tool.

Roy Lambert

Fred
I'll stuff a simple app I wrote to test out EDB into the binaries - the query builder is part of it.

Roy Lambert