Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 4 of 4 total |
EDB Manager issues |
Fri, Aug 29 2008 5:52 AM | Permanent Link |
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. | |
Fri, Aug 29 2008 11:18 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Fri, Aug 29 2008 12:03 PM | Permanent Link |
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. | |
Tue, Sep 2 2008 11:55 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Sunday, May 5, 2024 at 10:18 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |