Subject Re: OODML... querry and help From Akshat Kapoor <akshat.kapoor@kapoorsons.in> Date Sat, 2 Nov 2019 14:20:04 +0530 Newsgroups dbase.getting-started Attachment(s) Printing _UPDATE statement.pdf On 02/11/2019 08:44, Alex Safian wrote: > Hi Prem: > Ken's article "XBase to dBASE's Object Oriented Database Manipulation Language (OODML)" is probably the best treatment of the translation from xbase to the new language -- http://www.dbase.com/Knowledgebase/INT/xb2vdb7oodml/x2oodml.htm > > At the top of the article there is a link to examples. > > For replace all there is no direct equivalent -- you just do a loop with ...rowset.next() to enforce the skip. I would say you are 50% correct. There is no direct equivalent but with local sql you can achieve the desired result by a single command. I have attached the local sql help for the concerned Using sql is the fastest way of updating a table. A word of warning, The table will get updated but the rowset already in memory will NOT be updated till a requery() is executed. Regards Akshat