2011/1/20 Graeme Geldenhuys <[email protected]> > On 20 January 2011 20:28, Bo Berglund <[email protected]> wrote: > >> > >>Use query.ExecSQL instead of query.Open even in Delphi! > > > > Not if the stored procedure returns a recordset.... > > And with this whole mess I would end by saying: And that is why you > will not see me ever use a Stored Procedure! 99.99% of the time they > contain business logic, which doesn't belong in the data layer of your > application in any case - you can't unit test that business logic. >
Why can't that business logic be unit tested ? I did it myself many times. It results into a more maintenable code(Object Pascal and SQL) and a high perfoming applications. Stored Procedures have their uses, just do not abuse them, as with other technologies/features. -- Inoussa O.
-- _______________________________________________ Lazarus mailing list [email protected] http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
