SQL calculations in RAP

rbuser

Hi,

I'm new in developing in RAP, but I need to make some advanced SQL queries
within the report. I need to create a new query against the SQL server where
some of the parameters comes from the output of the report

Ex.
I have a group total in my report that gives a result of 50 then I need to
make a query like

SELECT SUM(TotalTime) FROM Table1 WHERE Time >= 50 AND Time <= 100

and then put the result into a Label.Caption

How can I do this completely in RAP

regards,

Poul
adm4you

nardmoseley

You can use Delphi to code RAP pass-through functions that are registered
with the Code Toolbox and can be called from RAP code. See the article
below.


--------------------------------------------------
Article: Extending RAP
---------------------------------------------------

There are two very simple and powerful techniques to extend the capabilities
of RAP infinitely. These are summarized below and covered in more detail in
the RAP.hlp online help. Demos and tutorials are installed to
RBuilder\Demos\RAP. The tutorial text is located in RAP.hlp.


1. RAP Pass-Through Functions

These are functions that appear in the Language tab of RAP's Code Toolbox.
These functions are written in Delphi and can be called from RAP. RAP's
pass-through function architecture enable's developers to add new built-in
functions to RAP's code toolbox.

2. Extend RAP's RTTI

RAP's Run-time Type information defines what classes and properties can be
accessed via RAP. By default the published properties of any class that is
registered with Delphi's RegisterClass procedure is recognized by RAP. In
addition many of the public properties and methods of ReportBuilder classes
are exposed.







--
Tech Support mailto:support@digital-metaphors.com
Digital Metaphors http://www.digital-metaphors.com



--
Nard Moseley
Digital Metaphors
http://www.digital-metaphors.com