[RBASE-L] - Re: I always have trouble with the update command

[A. Razzak Memon]

At 03:07 PM 6/19/2013, Patti Jakusz wrote:

I usually end up writing a small routine to do what I could do with one update statement.

I have a Client table and an HomeVisit table. I want to update the Client table with the

latest HomeVisit date, so I try to write my command like this:

update ClientMaster set LastHomeVisit = (max(t1.VisitDate)) from HomeVisit t1, Client t2

where t1.ClientID=t2.ClientID

I get a message like 'Illegal Select Function'

I know this can be done simply, I just never know how. Can someone tell me what the

correct syntax is?

Patti,

Here's an example of Correlational Update Command ...

   UPDATE ClientMaster SET LastHomeVisit = (MAX(VisitDate)) +
   FROM HomeVisit,ClientMaster +
   WHERE ClientMaster.ClientID = HomeVisit.ClientID

Very Best R:egards,

Razzak.

www.rbase.com
www.facebook.com/rbase
--
30+ years of continuous innovation!
15 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
--