This cares for the existing information. Good. In the form then with the WHERE clause I just limit it to the specific employee for that date. Thanks. I believe this will do the job.
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 11:01 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: auto caps update Yes. You could add a "where" clause if you only wanted certain rows to be updated 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: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]<mailto:[email protected]>] From: [email protected]<mailto:[email protected]> [mailto:[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]><mailto:[email protected]<mailto:[email protected]?>>> To: RBASE-L Mailing List <[email protected]<mailto:[email protected]><mailto:[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]><mailto:[email protected]<mailto:[email protected]?>>]
