Skip to Content
avatar image
Former Member

Create transparent table : overlap record

Hi all and happy Christmas !!

Well, i need to create a new transparent table, but his records do not have to overlap.

For example the following record c2 will not be recorded because of their date overlap with record C1.

CODE     BEGDA          ENDDA

C1           01.01.2014      31.12.2014

C2           01.05.2014      05.10.2014

But how can i do from a technical point of view ? I know the time dependent function in the Table Maintenance Generator but how it works ?

Thanks for your help.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Dec 26, 2014 at 10:18 AM

    Hi Eric,

    If you are providing the table Maintenance Generator to Update the Information.

    You can put a validation on event 01 / Before Saving the Data in Database table.

    you can use the IN BETWEEN method to validate the entered date is already overlapping

    with other entered or old records information.

    Regards.

    Praveer.

    Add comment
    10|10000 characters needed characters exceeded