Subject Re: [IBO] stored procedures versus queries
It seems to me that a big advantage of stored procedures is that it
insulates changes in the design of the server side code from the
client. So long as the externally visible part of the sp remains the
same, you can re-implement it any way you want, without having to
distribute a new client exe to your end users.


> At 12:13 AM 10-05-02 +0000, jon freedman wrote:
> >should i, if i am responsible for developing both the server database
> >and the user interface, used stored procedures to select data for
> >viewing, update data, and otherwise control all the transmission of
> >data from the server to the client, and call them thru stored
> >procedure objects instead of query objects?
> In short, no. You lose most of the benefits of the IBO "live dataset"
> model that way. A dataset that is output from a dynamic query knows how to
> insert into, delete rows from, and update itself. It knows how to search
> and filter its underlying tables and so on. If there are no underlying
> tables, it capabilities are limited.