Yes. You could add a "where" clause if you only wanted certain rows to be updated
Karen -----Original Message----- From: Jim Belisle <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Wed, Mar 4, 2015 10:56 am Subject: [RBASE-L] - Re: auto caps update Karen, This would update ALL the entries in the table for a specific column, correct? James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]] From: [email protected] [mailto:[email protected]] On Behalf Of Karen Tellef Sent: Wednesday, March 04, 2015 10:53 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: auto caps update Are you looking for code? UPDATE tablename SET column = (LUC(column)) Karen -----Original Message----- From: Jim Belisle <[email protected]<mailto:[email protected]>> To: RBASE-L Mailing List <[email protected]<mailto:[email protected]>> Sent: Wed, Mar 4, 2015 10:25 am Subject: [RBASE-L] - auto caps update We import information from an ACCESS DB. Often the entries are in lower case. What I want to be able to do is update to caps on these entries. My preference would be that when the form comes up to edit this info, the update would either be automatic or with a button EEP. James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]<mailto:[email protected]>]
