Hi to all:

One of the most used programs for me is dbsys. In v4.26 is very handy.

Now, starting to use EDB Manager (EdbM), there are my impressions,
complaints and suggestions:

1. Editor. CTRL+F4 should close tabs, it's an standard
2. Altering procedures, functions. When you have a related table or
query opened, EdbM raise you cannot exclusive access until you press
ok. Now just can copy your changes, cancel, unprepare query, alter
again and paste your saved work. EdbM should inform on the first
keypress you will not save your work.
3. Misc. When inserting a row in an opened table, always is active the
"copy on append" feature. BTW, how set/unset this feature in EdbM?



Tiago Ameller
tiago put_an-a-_in_a_circle sistemasc.net
Sistema, S.C.

Tiago,

<< 1. Editor. CTRL+F4 should close tabs, it's an standard >>

I'll add that keystroke combination for the next build.

<< 2. Altering procedures, functions. When you have a related table or query
opened, EdbM raise you cannot exclusive access until you press ok. Now just
can copy your changes, cancel, unprepare query, alter again and paste your
saved work. EdbM should inform on the first keypress you will not save your
work. >>

Are you referring to altering these objects in the dialogs, or via an SQL
statement window ?

<< 3. Misc. When inserting a row in an opened table, always is active the
"copy on append" feature. BTW, how set/unset this feature in EdbM? >>

I'm not seeing that here at all.  There is a Copy On Append setting for
datasets in the EDB Manager .ini, but it isn't surfaced in the application
and is always defaulted to False.  You can change this setting in the
edbmgr.ini here:

C:\Documents and Settings\<UserName>\Local Settings\Application Data\Elevate
Software\ElevateDB Manager\edbmgr.ini

in the section:

[<Database>.<Table>]

where Database is the database name that you're accessing and Table is the
table name that you're accessing.  There should be a value called Copy On
Append, and it should be set to 0.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

>I'll add that keystroke combination for the next build.
Thanks.

><< 2. Altering procedures, functions. When you have a related table or query
>opened, EdbM raise you cannot exclusive access until you press ok. Now just
>can copy your changes, cancel, unprepare query, alter again and paste your
>saved work. EdbM should inform on the first keypress you will not save your
>work. >>
>
>Are you referring to altering these objects in the dialogs, or via an SQL
>statement window ?
1.Launch a query using function X. Leave query result opened.
2.Go to alter function X, via dialogs.
3.Once changes are made, pressing ok raises cannot exclusive access.
4.Only way to save changes in code is copy to clipboard and discard
changes.
5. Unprepare query
6. Edit function X again
7. Paste changes
8. Save them

I think EdbM should warn user that function code is not modificable
before let to make changes.

>
><< 3. Misc. When inserting a row in an opened table, always is active the
>"copy on append" feature. BTW, how set/unset this feature in EdbM? >>
>
>I'm not seeing that here at all.  
It's very strange! Ini file is "factory default"
Open EdbM and now appening a row doesn't copyonappend. But after
running some queries, importing database, altering, etc. copyonappend
is on for all tables and all databases. ??? I'll try again to report
how to reproduce it.


Tiago Ameller
tiago put_an-a-_in_a_circle sistemasc.net
Sistema, S.C.

Tiago,

<< I think EdbM should warn user that function code is not modificable
before let to make changes. >>

Unfortunately, there's really no way for the EDB Manager to get this
information at this time (it can get lock information for the current
session, but not for other sessions, with local connections).

<< Open EdbM and now appening a row doesn't copyonappend. But after running
some queries, importing database, altering, etc. copyonappend is on for all
tables and all databases. ??? I'll try again to report how to reproduce it.
>>

Okay, thanks.

--
Tim Young
Elevate Software
www.elevatesoft.com