Subject Re: OODML... querry and help From Akshat Kapoor <akshat.kapoor@kapoorsons.in> Date Sun, 3 Nov 2019 14:14:46 +0530 Newsgroups dbase.getting-started On 03/11/2019 03:44, Alex Safian wrote: > Well I have to disagree too -- while I use sql as much as possible, in the case of sql UPDATE to really approximate REPLACE ALL you'd have to use a select subquery -- IOW, if you were replacing a field value with a field value from a different table, or an expression based on a field value from a different table, you'd have to get that other field from a subquery. > > And SELECT subqueries can get rather complicated. In my experience the do loop method in this situation is simpler and surprisingly fast. Lets Agree that we Disagree update through sql is one of the option but Which option to select depends on the end programmer's exact requirement Regards Akshat