Thank you. I will try this tonight. I am leaving work shortly. Patti From: A. Razzak Memon <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Wednesday, June 19, 2013 4:07 PM Subject: [RBASE-L] - Re: I always have trouble with the updatecommand
At 03:29 PM 6/19/2013, Patti Jakusz wrote: >I still get an illegal select function (2511). That is the result of updating a "unique row" table column with "many values" table. Based on Bill Downall's example, here's a routine which you can run on demand. -- Update Last Home Visit Date in ClientMaster CLS PAUSE 3 USING 'Updating Last Home Visit Date ...' + CAPTION 'Last Home Visits' ICON INFO + OPTION MESSAGE_FONT_NAME Tahoma + |MESSAGE_FONT_COLOR NAVY + |MESSAGE_FONT_SIZE 11 + |THEMENAME Longhorn -- Define Last Visit by ClientID SET ERROR MESSAGE 677 OFF DROP VIEW tLastVistDates SET ERROR MESSAGE 677 ON CREATE TEMPORARTY VIEW tLastVistDates + (ClientID, LastVisitDate) AS SELECT + ClientID, (MAX(VisitDate)) + FROM HomeVisit GROUP BY ClientID -- Now Update the LastHomeVisit Column in ClientMaster UPDATE ClientMaster SET LastHomeVisit = LastVisitDate + FROM tLastVistDates,ClientMaster + WHERE ClientMaster.ClientID = tLastVistDates.ClientID CLS RETURN Save this routine as a command file and re-cycle as you wish! Very Best R:egards, Razzak.
