I still get an illegal select function (2511). Patti From: A. Razzak Memon <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Wednesday, June 19, 2013 3:19 PM Subject: [RBASE-L] - Re: I always have trouble with the update command
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! --
