I want to implement backup procedure into my application. It appears that Backup() method
requires list of table names. What is the easiest way to get list of tables from a given
database? Passing nil does not work.

Same with restore - if I want to restore all tables from backup - how do I do that?

Thank you

Alex

On Thu, 4 Oct 2007 12:18:09 -0500, alexu <alex@zfirmllc.com> wrote:

>I want to implement backup procedure into my application. It appears that Backup() method
>requires list of table names. What is the easiest way to get list of tables from a given
>database? Passing nil does not work.

Provided each table has a TDBISAMTable component in a Datamodule, you
could cycle though each component of the DataModule adding only the
table names into a TStrings. Something like this:

 for i:= 0 to DM.ComponentCount-1 do
   if (DM.Components[i] is TDBISAMTable) then
     lbTables.Items.Add(TDBISAMTable(DM.Components[i]).TableName);

>Same with restore - if I want to restore all tables from backup - how do I do that?
>
>Thank you
>
>Alex

Michael Fullerton <fullerm@spamkiller-remove-cybermatrix.com> wrote:

>Provided each table has a TDBISAMTable component in a Datamodule, you
>could cycle though each component of the DataModule adding only the

thank you for suggestion but I use TQuery, so I do not have TTable component for each table...

alexu,

> I want to implement backup procedure into my application. It appears that Backup() method
> requires list of table names. What is the easiest way to get list of tables from a given
> database? Passing nil does not work.

Session.GetTableNames

> Same with restore - if I want to restore all tables from backup - how do I do that?

Database.BackUpInfo

Eryk

Thank you. GetTableNames worked! Have not tested restore yet

I think something like

   session.GetTableNames(gDatabaseName, lStr);

might be what you want.

JonD

alexu wrote:
> I want to implement backup procedure into my application. It appears that Backup() method
> requires list of table names. What is the easiest way to get list of tables from a given
> database? Passing nil does not work.
>
> Same with restore - if I want to restore all tables from backup - how do I do that?
>
> Thank you
>
> Alex
>