DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: List Item

  1. #1
    Join Date
    Jun 2001
    Posts
    109

    Question

    How do you check that the value in the list item is selected once on a given date.
    I have a list item values like "10000-2430-22111",
    10000-2430-27131
    10000-2430-27132
    10000-2430-27133
    10000-2430-27134
    40001-6450-27112-54
    53000-3420-24806
    72013-2430-5230


    for these values a user can select only once the 10,000 value, only once 40001 value, only once the 72000 value etc on any given day....So how do I check this condition.

    How do you check that the value in the list item is selected once on a given date.

    Can anyone please answer my doubt.

    Thanks
    saritha.


  2. #2
    Join Date
    Aug 2000
    Posts
    462
    Write a function which queries the table where that value is stored, or create a unique index on the concatenated "10000" and date.
    Oracle DBA and Developer

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width