> From: Juan Pablo Garcia <[EMAIL PROTECTED]>
> Date: Thu, 21 Sep 2006 08:06:53 +0200
>
> Hi:
>
> I have a Real SQL Database and I want to set a boolean column on a
> record to true, and doing so setting the same column in the rest of
> records to false. Kind of a radiobutton function. It is as if I have
> a musicians database and can be one and only "lead guitar" in a band.
Hi Juan,
I do not see reason why you cannot do simply:
UPDATE T SET f = false // for all records
UPDATE T SET f = true WHERE id = v // one record.
--
Best regards,
Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc
Valentina - Joining Worlds of Information
http://www.paradigmasoft.com
[I feel the need: the need for speed]
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
