Subject | Re: How To: Write a Store Proc. for the following |
---|---|
Author | Dorin Vasilescu |
Post date | 2004-04-19T07:05:55Z |
I know, but he wants to use Report Manager and to define a dataset in
a report consisting just in a SQL select from a selectable stored
procedure which do all the work, including expression evaluation, if I
understand correctly.
So he need this in this stored procedure:
-retrieve a row with some columns, based on a parameter
-retrieve a child row, with a template column
-merge values from first query columns using the template from second
query and return the result
and all these in a SP.
at client side he can do the last step in just one line of code, but
he needs to be done in a SP
Is this correct?
a report consisting just in a SQL select from a selectable stored
procedure which do all the work, including expression evaluation, if I
understand correctly.
So he need this in this stored procedure:
-retrieve a row with some columns, based on a parameter
-retrieve a child row, with a template column
-merge values from first query columns using the template from second
query and return the result
and all these in a SP.
at client side he can do the last step in just one line of code, but
he needs to be done in a SP
Is this correct?
--- In firebird-support@yahoogroups.com, Tim Ledgerwood <tim@s...> wrote:
> That's because Firebird is the actual server that you run the SQL
against.
> Using APIs, I can do exactly the same thing in Delphi; and using the
C pre
> compiler, I can do even more than you can in VFP with Firebird.
>
> But using the API, I can also do the same using Delphi and MS SQL
Server;
> and using the pre compiler, I can do more than you can with VFP
against SQL
> Server .... and so on and so forth. The point is that this has
nothing to
> do with Firebird.
>
> Regards
>
> Tim
>
> At 08:15 AM 19/04/2004, you wrote:
>
> >Hi
> >Firebird hasn't so many programming features as VFP
> >What you can do is to get what you need and do the
> >evaluation/parsing/textmerge at client side
> <snip>
>
>
> [Non-text portions of this message have been removed]