Querying Journal Tables through Forms
From: <rhemanth_at_my-deja.com>
Date: Fri, 24 Mar 2000 20:15:14 GMT
Message-ID: <8bgic1$fip$1_at_nnrp1.deja.com>
Hi,
We have a request from our customer to have report and form that queries the journal table for all main tables.
We have created journal tables(using designer 2000) for all tables in the database. And these
Journal tables have all the historical data for each record in the main table.
Example: Say we have 3 tables T1,T2,T3. Each of these have T1_JN, T2_JN, T3_JN journal tables (generated using designer 2000) which holds the history(Insert,updates,delete) of each record in the main tables respectively. We have to create forms that queries these Journal tables T1_JN etc. This form should display the parent table (say T1_JN) journal table data also child tables journal table information. This is easy for few tables but we have to do for all the tables in our database.
So my question is has any body done this? If so what approach did they take? Also is there any tool (Standard package..) that can be used to do this. If anybody has come accross such a problem please reply with there ideas, Thanks in advance.
Bye
Roopa
Date: Fri, 24 Mar 2000 20:15:14 GMT
Message-ID: <8bgic1$fip$1_at_nnrp1.deja.com>
Hi,
We have a request from our customer to have report and form that queries the journal table for all main tables.
We have created journal tables(using designer 2000) for all tables in the database. And these
Journal tables have all the historical data for each record in the main table.
Example: Say we have 3 tables T1,T2,T3. Each of these have T1_JN, T2_JN, T3_JN journal tables (generated using designer 2000) which holds the history(Insert,updates,delete) of each record in the main tables respectively. We have to create forms that queries these Journal tables T1_JN etc. This form should display the parent table (say T1_JN) journal table data also child tables journal table information. This is easy for few tables but we have to do for all the tables in our database.
So my question is has any body done this? If so what approach did they take? Also is there any tool (Standard package..) that can be used to do this. If anybody has come accross such a problem please reply with there ideas, Thanks in advance.
Bye
Roopa
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Mar 24 2000 - 21:15:14 CET