A few times I have executed SQL statements in EDBMgr that seems to last forever (sometimes my fault). For some reason the Cancel button may not be enabled while the SQL is executing so I have to terminate EDBMgr. It doesn't happen that often but when it does, I usually end up losing a complex SQL statement I've been working on. I'd like EDBMgr to temporarily write the SQL statement to a text file (like EDBTemp.Sql) just prior to executing it, so I can retrieve it should EDBMgr terminates. (I don't always remember to save the SQL statement prior to executing it.) When EDBMgr closes down normally, it can delete this EDBTemp.Sql file. The next time EDBMgr runs, if it finds EDBTemp.Sql (because the last EDBMgr session aborted) it can ask the user if he wants to open the file in an SQL window.

Thanks
Barry

I agree that this would be a good feature & wouldn't need to be complicated: On re-opening EDB Manager the "lost" SQL could just be displayed (="restored") of course it would need to be stored somewhere as suggested, but the exact location & name of the file would be less important if the restore process was automatic, users would just know it would be present on re-start and could edit / save it at that point.

Barry,

+1

Uli

Barry


If this is truly a major annoyance then whilst waiting for Tim why not do your own mod? - Open edbmgr.dpr in the IDE, find

procedure TMainForm.ExecuteButtonClick(Sender: TObject);


and modify to suite your needs.

Just make sure you install the needed components before starting

Roy Lambert

>Just make sure you install the needed components before starting<

Does Tim use 3rd party components? Do you know which ones?

TIA
Barry

Never mind. I got it working.

Barry

On 6/12/2015 12:55 PM, Barry wrote:
>> Just make sure you install the needed components before starting<
>
> Does Tim use 3rd party components? Do you know which ones?

No - there are some custom EDB components (TEDBListView, etc ). They are
part of EDB additional package but you still need to compile and install
them.

Package is in EDB\ElevateDB 2 ADD\utilcomps folder and you should get a
whole bunch of components under "Elevate DB Utilities" pane in tool
palette once installed.

Then open and compile edbmanager.

Raul