Well the are always 100 solutions or more available in Rbase. This one of them and most probably there are better ways of doing it.
BTW I think you have to make use of the clientID matching the table and the view Tony From: [email protected] [mailto:[email protected]] On Behalf Of Patti Jakusz Sent: maandag 5 oktober 2015 20:28 To: [email protected] Subject: [RBASE-L] - RE: update command help So I have to create a view and then do: update CLIENTTAB set MyColumn=(count(CASENUM)) from CLIENTTAB t1, VIEW t2 where t1.CASENUM=t2.CASENUM I'm suspicious that it would work with a view name when it wouldn't work with a table name. Is there no way to do it without creating the view? Patti _____ From: Tony IJntema <[email protected]> To: [email protected] Sent: Monday, October 5, 2015 2:05 PM Subject: [RBASE-L] - RE: update command help Normally I am creating a view using the ‘group by’ clause. Then you are able to update corresponding column in clienttab, where the view is table t2. Tony From: [email protected] [mailto:[email protected]] On Behalf Of Patti Jakusz Sent: maandag 5 oktober 2015 16:33 To: [email protected] Subject: [RBASE-L] - update command help I have a table of client records and a table of activity records. Occasionally, I want to count the number of certain types of activity records for a client and plug that number into the client table. It should be a simple command, but I can't get it to work. Here are some of my attempts: update CLIENTTAB set MyColumn=(count(*)) from ACTIVITY where CASENUM=CASENUM update CLIENTTAB set MyColumn=(count(CASENUM)) from ACTIVITY where CASENUM=CASENUM update CLIENTTAB set MyColumn=(count(CASENUM)) from CLIENTTAB t1, ACTIVITY t2 where t1.CASENUM=t2.CASENUM update CLIENTTAB set MyColumn=(select(count(CASENUM)) from ACTIVITY where CASENUM=CASENUM) I know there has to be a simple command and I'm just not getting it. Can someone help? Thanks, Patti
