Re: sql query which has got 3 dynamic parameters

Vic wrote:

There are many databases like TestData6061, TestData606, TestData607

Okay, you referred to these as tables earlier; I assume you're right
now, and were wrong then.

under which there are tables like 'accounting', 'fundstructures',
'transaction' etc and each of these tables will have 'New', 'Update'
and 'Delete' as the record action. So basically idea is to find out
the coverage for 'accounting' -> 'AccountingParameters' for 'New',
'Update' and 'Delete' by mapping TestData6061/accounting with
accounting and AccountingParamter related rows in SchemaFields

Again, are you intending to keep unclean data out of the database, or
allow it into the database so that you can subsequently figure out how
you want to clean it up? If the former, then you're re-inventing a
square wheel (table constraints).

What does the full structure of 'accounting', 'fundstructures', etc.
look like? Do they contain a current set of entities, or a list of
changes to that set? (Your description of "record action" suggests
the latter.) Would it be possible to merge these into a single table
with 'accounting', 'fundstructures', etc. as values in an additional
column? If not, then how does your per-table logic adjust to account
for the different set of columns in each table?
.

Relevant Pages

  • Re: Database Design
    ... In practice I know of working, real-life Access databases with 20,000,000 rows ... Oracle or DB2 database containing terabytes of data. ... Many to Many if it is for accounting software? ... containing money, and Creditors who get money, there will be a many to many ...
    (microsoft.public.access.modulesdaovba)
  • RE: database with yearly split data
    ... i am designing a database for a firm that has annual period of the accounting. ... balances of the suppliers and customers accountings ... as the first records in the new database accounting tables and stock tables. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Looking for inventory management and invoicing programs
    ... > Good point Rick, but I think most of the problematic issue with Y2K related ... Accounting program used 4 digits for data in the year ... Database program generated "automatic dates" using Julian ... It simply went nuts trying to report dates after 12/31/1999. ...
    (comp.sys.tandy)
  • Re: Database Design
    ... Thanks John for your extensive explanation. ... Oracle or DB2 database containing terabytes of data. ... Many to Many if it is for accounting software? ... containing money, and Creditors who get money, there will be a many to many ...
    (microsoft.public.access.modulesdaovba)
  • Re: Simply Accounting
    ... It actually turns out that simply accounting uses ms-access files (and the ... counting uses the same database format as ms-access. ... also, and if you don't join that workgroup file, then you'll not be all to ... Dim strTables As String ...
    (microsoft.public.access.modulesdaovba)