Member Avatar for lps

Good day,

I having a problem where creating my setting table as condition below

column User_id setting effective_date effective_end_date
Row 1: 1 ABC 2017-03-01 2018-02-28
Row 2: 1 DEF 2018-03-01 2019-03-01

I wish to add a constraint to block if same user add in a setting with the effective_date or effective_end_date between existing setting. Is that posible?
I had searching and trying for a few days now without succeed to archive what I trying to do. Please kindly guide me through this. Thanks in advance.

Edited by lps
  • 1 Contributor
  • 1 Reply
  • 297 Views
  • 3 Hours Discussion Span
  • Latest Post Latest Post by lps
Member Avatar for lps

Ok, found a work around. I am using trigger instead.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.