On Sep 23, 2006, at 1:19 AM, Ruslan Zasukhin wrote:
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.
No reason he couldn't
He did just ask for a single update that would do that and we gave
him one
_______________________________________________
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>
