||Re: OODML... querry and help
Akshat Kapoor <firstname.lastname@example.org>
||Sun, 3 Nov 2019 14:14:46 +0530
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