| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> borland.public.delphi.oodesign
If someone wants to see something about the state of the data
management theory knowledge in the OO coders community you might be
interested in taking a look at this group.
Perhaps you will be as amazed as I was.
For instance:
update employees set salary = salary * 1.05 where (country = 'Spain' or country = 'Brazil') and hiredate < ToDate('1/1/2003');
Is a very bad approach because it is not encapsulated, and you must do things like this in your application code:
equal1.AddOrCriteria(equal2);
lessthan := LessThanCriteria.Create('hiredate', '1/1/2003');
updateCriteria.ForClass('Employee');
updateCriteria.AddAttribute(salary, salary * 1.05);
updateCriteria.AddSelectEqualTo(equal1); updateCriteria.AddSelectLessThan(lessthan);
updateCriteria.Perform;
But if you are depressed don't look at this group :-)
The really sad thing is that a lot of newcomers are "learning" the "new" approach on that group.
Regards
Alfredo
Received on Sun May 25 2003 - 19:00:50 CDT
![]() |
![]() |