We have a distributed desktop app.... and we sometimes need to restructure the db.

Problem is: This can be slow on a large db, and sometimes users think we are hung, and they terminate our app, which trashes the db....

Specifically, we want to be able to show status, and process messages during a call like this (where BAR is currently char(30)):

ExecuteSQL( 'alter table FOO redefine BAR char(50)' );

How to do this and get callbacks?

Thanks!!

samjones

I'm well out of date but the newer version of DBISAM have

property OnAlterProgress: TProgressEvent

Description
The OnAlterProgress event is fired when the structure of a table is altered by executing an ALTER TABLE SQL statement using the ExecSQL or Open method.  Use the PercentDone parameter to display progress information in your application while the table's structure is being altered.
Note
The number of times that this event is fired is controlled by the TDBISAMSession ProgressSteps property.

Roy Lambert [Team Elevate]