Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 10 of 10 total
Thread DbSys Suggestion
Tue, Jul 10 2007 6:02 PMPermanent Link

Dave Harrison
It would be nice if when displaying a table in dbSys, the user could use
also a combo box on the Browse Data window (right beside "Select Visible
Fields...") and choose another table from the same directory. This
eliminates the user having to close this browse data window, select the
"^" icon, and select a table from the "Select table(s) to Open" dialog
window. If we could do all this from the same window it would require
fewer keystrokes. The combo box items could also be divided in two, with
 the 5 most frequent selected tables listed at the top of the pull down
list.

Dave
Tue, Jul 10 2007 6:42 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Dave,

<< It would be nice if when displaying a table in dbSys, the user could use
also a combo box on the Browse Data window (right beside "Select Visible
Fields...") and choose another table from the same directory. This
eliminates the user having to close this browse data window, select the "^"
icon, and select a table from the "Select table(s) to Open" dialog window.
If we could do all this from the same window it would require fewer
keystrokes. The combo box items could also be divided in two, with  the 5
most frequent selected tables listed at the top of the pull down
list. >>

Noted.  However, I have to be honest and say that I'm not sure many
improvements to DBSYS are going to be made in the coming year.

--
Tim Young
Elevate Software
www.elevatesoft.com

Wed, Jul 11 2007 4:13 PMPermanent Link

Dave Harrison
Tim Young [Elevate Software] wrote:

> Dave,
>
> << It would be nice if when displaying a table in dbSys, the user could use
> also a combo box on the Browse Data window (right beside "Select Visible
> Fields...") and choose another table from the same directory. This
> eliminates the user having to close this browse data window, select the "^"
> icon, and select a table from the "Select table(s) to Open" dialog window.
> If we could do all this from the same window it would require fewer
> keystrokes. The combo box items could also be divided in two, with  the 5
> most frequent selected tables listed at the top of the pull down
>  list. >>
>
> Noted.  However, I have to be honest and say that I'm not sure many
> improvements to DBSYS are going to be made in the coming year.
>

1) I just thought I'd mention it in case you've got the hood open
tweaking something else you might as well add it in.

ElevateDb Suggestions:
2) Under the ElevateDb Manager tree, if the user double clicks on a
session it should be the same as clicking on "Connect Session".

3) If the user double clicks on a database in the tree, it should open
the database.

4) I'm not sure why you keep hiding the Sql tab when the user selects
anything underneath the database node. It took me a while to figure out
I have to have the Database selected before the SQL tab shows up. I
would prefer to see the SQL table visible whenever any node under the
database is selected. I don't want to have to continually go back to the
database name to make the SQL tab to appear. SQL is vitally important
and should be accessible at all times.

5) How do you execute the SQL with a single keystroke? I enter the SQL
and then I have to grab the mouse to click on "Execute SQL" which makes
it a real pane to execute. It would be much easier if the user could
press F9 or some other control key. Also have control keys for the other
SQL tasks too and label them in the window like "New SQL (Ctrl-N)",
"Load SQL (Ctrl-L). People who can type, like me, would rather do
everything with the keyboard because it's more productive. We don't like
going from the keyboard to the mouse, hunt around for something to
click, then drop the mouse and go back to the keyboard. Any application
should be able to work without using the mouse. So start up EDbMgr and
put the mouse in the draw and see how far you get. Smile

These are all minor annoyances and are easily fixed. Keep up the good
work. Smile

Dave
Wed, Jul 11 2007 7:50 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Dave,

<< 1) I just thought I'd mention it in case you've got the hood open
tweaking something else you might as well add it in. >>

Yep, I've got it in my DBISAM "cubby hole", so it will get picked up in any
round of improvements for a minor release.  I operate like it's still 1988
and print out every suggestion or enhancement request and file it in the
DBISAM or ElevateDB "cubby hole". Smiley

<< 2) Under the ElevateDb Manager tree, if the user double clicks on a
session it should be the same as clicking on "Connect Session". >>

Yep, I've got this one on the list already - it drives me nuts sometimes
because it's just natural to double-click on the session and expect it to
connect.

<<  3) If the user double clicks on a database in the tree, it should open
the database. >>

Yep.

<< 4) I'm not sure why you keep hiding the Sql tab when the user selects
anything underneath the database node. It took me a while to figure out I
have to have the Database selected before the SQL tab shows up. I would
prefer to see the SQL table visible whenever any node under the database is
selected. I don't want to have to continually go back to the database name
to make the SQL tab to appear. SQL is vitally important and should be
accessible at all times. >>

This is because I wanted to make sure that the understanding is there that
the SQL is not being run against the current object, but rather the entire
database.  It may be that it was never confusing to begin with and I was
just being paranoid. Smiley

<< 5) How do you execute the SQL with a single keystroke? I enter the SQL
and then I have to grab the mouse to click on "Execute SQL" which makes it a
real pane to execute. It would be much easier if the user could press F9 or
some other control key. Also have control keys for the other SQL tasks too
and label them in the window like "New SQL (Ctrl-N)", "Load SQL (Ctrl-L).
People who can type, like me, would rather do everything with the keyboard
because it's more productive. We don't like going from the keyboard to the
mouse, hunt around for something to
> click, then drop the mouse and go back to the keyboard. Any application
> should be able to work without using the mouse. So start up EDbMgr and put
> the mouse in the draw and see how far you get. Smile>>

This is on the list already also.  All of these types of improvements are
slated for the next minor release.

Thanks,

--
Tim Young
Elevate Software
www.elevatesoft.com

Thu, Jul 12 2007 12:16 PMPermanent Link

Dave Harrison
Tim Young [Elevate Software] wrote:
> Dave,
>
> << 1) I just thought I'd mention it in case you've got the hood open
> tweaking something else you might as well add it in. >>
>
> Yep, I've got it in my DBISAM "cubby hole", so it will get picked up in any
> round of improvements for a minor release.  I operate like it's still 1988
> and print out every suggestion or enhancement request and file it in the
> DBISAM or ElevateDB "cubby hole". Smiley
>
> << 2) Under the ElevateDb Manager tree, if the user double clicks on a
> session it should be the same as clicking on "Connect Session". >>
>
> Yep, I've got this one on the list already - it drives me nuts sometimes
> because it's just natural to double-click on the session and expect it to
> connect.
>
> <<  3) If the user double clicks on a database in the tree, it should open
> the database. >>
>
> Yep.
>
> << 4) I'm not sure why you keep hiding the Sql tab when the user selects
> anything underneath the database node. It took me a while to figure out I
> have to have the Database selected before the SQL tab shows up. I would
> prefer to see the SQL table visible whenever any node under the database is
> selected. I don't want to have to continually go back to the database name
> to make the SQL tab to appear. SQL is vitally important and should be
> accessible at all times. >>
>
> This is because I wanted to make sure that the understanding is there that
> the SQL is not being run against the current object, but rather the entire
> database.  It may be that it was never confusing to begin with and I was
> just being paranoid. Smiley
>
> << 5) How do you execute the SQL with a single keystroke? I enter the SQL
> and then I have to grab the mouse to click on "Execute SQL" which makes it a
> real pane to execute. It would be much easier if the user could press F9 or
> some other control key. Also have control keys for the other SQL tasks too
> and label them in the window like "New SQL (Ctrl-N)", "Load SQL (Ctrl-L).
> People who can type, like me, would rather do everything with the keyboard
> because it's more productive. We don't like going from the keyboard to the
> mouse, hunt around for something to
>
>>click, then drop the mouse and go back to the keyboard. Any application
>>should be able to work without using the mouse. So start up EDbMgr and put
>>the mouse in the draw and see how far you get. Smile>>
>
>
> This is on the list already also.  All of these types of improvements are
> slated for the next minor release.
>

Tim,
   I see you're still a couple steps ahead of me. Smile

Ok, one thing you don't have is the ability to copy the structure of a
table only, without the data. In your DbSys Copy Table window you could
have a checkbox that says "Copy Data" and if it is not checked, then it
copies the table structure only (with indexes). Also with ElevateDb Mgr,
if you right click on a table you don't have a Copy Table menu item,
which I think needs to be added.

Dave
Thu, Jul 12 2007 2:14 PMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Dave


>Ok, one thing you don't have is the ability to copy the structure of a
>table only, without the data.

WRONG Smiley

Click Create Table, Borrow Structure and there you go.

Roy Lambert
Thu, Jul 12 2007 4:32 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Dave,

<< Ok, one thing you don't have is the ability to copy the structure of a
table only, without the data. In your DbSys Copy Table window you could have
a checkbox that says "Copy Data" and if it is not checked, then it copies
the table structure only (with indexes). Also with ElevateDb Mgr, if you
right click on a table you don't have a Copy Table menu item, which I think
needs to be added. >>

Noted, with Roy's comments regarding DBSYS taken into consideration.

--
Tim Young
Elevate Software
www.elevatesoft.com

Sat, Jul 14 2007 1:23 AMPermanent Link

Dave Harrison
Roy Lambert wrote:
> Dave
>
>
>
>>Ok, one thing you don't have is the ability to copy the structure of a
>>table only, without the data.
>
>
> WRONG Smiley
>
> Click Create Table, Borrow Structure and there you go.
>
> Roy Lambert

So that's where it's hiding. Smile

 I would have thought to look for it in Copy Table since that's what
I'm doing, copying a table but without the data. You say "tomato" and I
say "tomAto". At least now I know where it is. Thanks.

Dave
Fri, Aug 31 2007 7:57 AMPermanent Link

"Mark A. Andrews"
Dave Harrison wrote:
> It would be nice if when displaying a table in dbSys, the user could use ....


You have the source. You could implement them yourself, submit them back
to Tim and free him to fix database stuff. You get your changes and Tim
would be eternally grateful (I'm sure).

Mark
Fri, Aug 31 2007 10:27 AMPermanent Link

"Jose Eduardo Helminsky"
Dave

I would suggest you use DBM (see binaries). It does almost everything what
DBSYS do with a lot of other features.

Eduardo

Image