>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 authI am still not able to get this working??? All the tables are opened SHARED and I could understand the REPLACE may not work (even if it did worked before in SHARED), but the UPDATE does not work? I am using buffer=5 (with =TableUpdate(.T.) later on the same code page). I read the Language Referances carefully.