The sqlPreview event is used to modify a datawindow's sql syntax. If the DW's
retieval is accomplished by an SP however, the DW's syntax is hidden in the SP so
isn't acccessible to the sqlPreview event.
You can configure DWs to retrieve via SPs but you thereby lose some DW power &
flexibility. We use SPs to implement custom database operations & business rules.
(Since many of us belong to multiple lists, it's best to post a question to one list
at a time.)
P.
-----------
Dario Schmidt wrote:
> Hello,
>
> I am to begin a project of great span. I need help regarding the use of
> stored procedures. In my previous projects I have used stored procedures to
> recover information of the database, while it lets that all the operations
> of maintenance are managed by the datawindow.
>
> I want to know which are the advantages and disadvantages of using stored
> procedures for the operations of maintenance.
>
> I think that the use of stored procedures possesses the following
> advantages:
> * Security. The permits are granted on the stored procedures and don't on
> the tables that these they maintain.
> * Logic: possibility to include business rules inside the stored procedures.
> * Performance.
>
> In the case that is convenient the use of stored procedures, my idea is to
> use the event sqlpreview to invoke to the stored corresponding procedure. Is
> this correct?
>
> The application will be developed with PB 6.5 and PFC. The databases will be
> Sybase ASE and ASA.
>
> Thank you
>
> -----------------------------
> Ing. Dario Schmidt
> CERIDE - Santa Fe
> Argentina
> ----------------------------
>
> > [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> > A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> > SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
