Subject | Re: [IBO] Trigger and Indexs |
---|---|
Author | Fabian Mario Kruszelnicki |
Post date | 2014-05-29T10:47:12Z |
I have the system local with many master table, these with relations (indexes and triggers). The system receives the updated information from a server. Eventually the local system must receive full updates of master tables, this need first to disable indexes and triggers, then delete all, load the data from the server and reactivate indexes and triggers.
I tested with IB_RPL component and it worked, but I have encountered some problems, one of them is that I have total control of the update of the information, especially in the time.
I do not speak English, I hope you have understood.
thanks
Fabian
El día miércoles, 28 de mayo de 2014 19:09, "'IBO Support List' supportlist@... [IBObjects]" <IBObjects@yahoogroups.com> escribió:
I recommend doing a query of the system tables for exactly
what you are after.
You could also get some index information by looking at your
connection's SchemaCache property.
Perhaps you could tell us more details about what information
you are after.
Jason Wharton
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
Sent: Wednesday, May 28, 2014 3:07 PM
To: IBObjects@yahoogroups.com
Subject: [IBO] Trigger and Indexs
Hello:
I need know triggers and indexes of tables for later deactivate or
activate, what components I can solve this problem?
Thank you
Fabian Kruszelnicki