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

[Bill Downall]

On Wed, Jun 19, 2013 at 3:29 PM, Patti Jakusz <trishjak...@yahoo.com> wrote:

> I still get an illegal select function (2511).
>
> Patti
>

Patti,

Create a temporary view for the MAX calculation:
CREATE TEMP VIEW MaxVisitDates (ClientID, MaxVisitDate) +
AS SELECT ClientID, MAX(VisitDate) +
FROM HomeVisit +
GROUP BY ClientID

UPDATE ClientMaster +
  SET LastHomeVist = MaxVisitDate +
FROM ClientMaster, HomeVisit h2 +
WHERE ClientMaster.ClientID = h2.ClientID

DROP VIEW MaxVisitDAtes

Bill