Ensuring only one record selected

Question

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Michael Du Bois SSCertifiable Points: 5163 More actions · Answer 1

Phil what criteria are you using to set the value of Field3? Is it possible for Field3 to be 0 for all rows or must 1 row always have Field3 = 1?

Mike

philcart SSC-Forever Points: 47794 More actions · Answer 2

Only one record in the whole table can be set to 1, all other records must be 0.

At present the field could be edited/updated via Query Analyzer, possibly in the future a ASP.Net webapp.

--------------------
Colt 45 - the original point and click interface

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 3

See this old thread where I provided a solution for the same problem.

philcart SSC-Forever Points: 47794 More actions · Answer 4

Cool, thanks Chris always love ways to avoid triggers and such

--------------------
Colt 45 - the original point and click interface

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 5

Yes, I am always looking to have declarative constraints, so I think this solution is quite nice but unorthodox I guess.

Merrill Aldrich SSCrazy Points: 2358 More actions · Answer 6

Now THAT is clever. Wow.

I wonder what someone would do who came upon that device in an existing database, without knowing what it did :-). Quite a puzzle!