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. Just my 2¢ worth... -- Regards, - Graeme - _______________________________________________ fpGUI - a cross-platform Free Pascal GUI toolkit http://fpgui.sourceforge.net -- _______________________________________________ Lazarus mailing list [email protected] http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
