Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread Request to add "EXCLUDE TABLES" to SAVE UPDATES command
Wed, Apr 18 2018 9:41 AMPermanent Link

Adam Brett

Orixa Systems

At present the following command is valid:

SAVE UPDATES FOR DATABASE "MyDatabase"
AS "MyUpdate" TO STORE "Updates"
TABLES "MyTable1", "MyTable2"

--

This is great, but if you have a database with 100 tables and you want to save updates for 99 of them it is pretty tedious.

As there are quite regularly a small number of tables to EXCLUDE from an update, could the syntax be extended:

SAVE UPDATES FOR DATABASE "MyDatabase"
AS "MyUpdate" TO STORE "Updates"
EXCLUDE TABLES "MyTable1", "MyTable2"

Meaning that updates for all tables except 1 and 2 would be saved.
Wed, Apr 18 2018 1:49 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Adam,

<< As there are quite regularly a small number of tables to EXCLUDE from an update, could the syntax be extended:

SAVE UPDATES FOR DATABASE "MyDatabase"
AS "MyUpdate" TO STORE "Updates"
EXCLUDE TABLES "MyTable1", "MyTable2"

Meaning that updates for all tables except 1 and 2 would be saved.
>>

I'll see what I can do.  In the meantime, you *can* use the EDB Manager to generate the SQL for you by using the Save Updates option and viewing the SQL history.

Tim Young
Elevate Software
www.elevatesoft.com
Image