>SELECT * FROM auth ; > WHERE auth.organization = org.organization AND ; > (auth.end > DATE() OR EMPTY(auth.end))>
>>>>UPDATE auth SET end = DATE(), ; >>>> uplog = ALLTRIM(GETENV("USR")) ; >>>>WHERE auth.organization = org.organization AND ; >>>> (auth.end > DATE() OR EMPTY(auth.end))>>>>>
REPLACE auth.end WITH DATE(), ; >>>>> auth.uplog WITH ALLTRIM(GETENV("USR")) FOR ; >>>>> auth.organization = org.organization AND ; >>>>> (auth.end > DATE() OR EMPTY(auth.end)) ; >>>>> IN auth