AW: DDS CHECKING...IS this possible?

Hi Tim,

shift the task to the DBMS:

Create a unique LF with the key field status with the selection omit status
<> '1'.

Thanks
Erich W. Schasse

> -----Ursprüngliche Nachricht-----
> Von: midrange-l-bounces@midrange.com
> [mailto:midrange-l-bounces@midrange.com]Im Auftrag von
> Hatzenbeler, Tim
> Gesendet: Mittwoch, 12. Februar 2003 01:36
> An: 'Midrange Systems Technical Discussion'
> Betreff: DDS CHECKING...IS this possible?
>
>
> I know I can place restraints on fields in my database...
>
> But can I create a field called status and in that field
> place a value of
> '1' in it...  '1' signifing your next to be processed...
> but, I don't want
> more than one row to have the value of '1' at one time...
> all the other
> rows must be blank or have a '2'  in it...  but only one row
> may have a '1'
> in it at any given time...
>
> I was thinking about a trigger, looking at a logical selecting '1' and
> seeing if there was more than one active record, and failing
> the write...
> but I don't even know if that would work, or if it's the best way...
>
> thanks, tim
> This e-mail message, including any attachments, is for the
> sole use of the
> intended recipient(s) and may contain confidential or privileged
> information.  Any unauthorized review, use, disclosure or
> distribution is
> prohibited.  If you are not the intended recipient, please contact the
> sender by reply e-mail and destroy the message.
> _______________________________________________
> This is the Midrange Systems Technical Discussion
> (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>