Re: Questions

[Ray Ontko <rayo@ONTKO.COM>]

Pavan,

1) A begin-select IS a cursor.

2) Use an if statement.

3) There are not functions, but there are procedures.  See begin-procedure
   in the manual.

4) You can't nest begin-select, but you can call a procedure from a
   begin-select using "do".  The procedure you call can have begin-select
   statements in it.

There are lots of sample programs in the manual.  The list serv
has an archive where you may find some useful examples:

   http://www.sqrug.com/sqr-users/

You may also wish to visit our site:

   http://www.ontko.com/sqr/

Ray

> Hi,
>
> I have a few of questions that I would like to ask.....I just started using
> BrioReport Builder 6.1.3(Build 90) with Oracle 8i as the database and I
> have run into the following issues :
>
> 1) Is there a way that we could use cursors in an SQR program. Could
> someone explain with some examples ?
> 2) The report that I creating has about 8 columns. The records are a part
> of this report only if the value of a a certain column within the database
> is more than a pre specified value and this is something which I have
> already done. The second part to this is that we need to display the value
> of the same field above as on the previous business day and two business
> days prior to the current report generation date. Is there a way I can do
> this ?
> 3) How can I use functions within SQR ? Can someone explain with examples ?
> 4) Can I have nested Begin-Selects ?
>
> Any help on the above questions would be really appreciated.
>
> Thanks and regards,
> Pavan
>

----------------------------------------------------------------------
Ray Ontko   rayo@ontko.com   Phone 1.765.935.4283   Fax 1.765.962.9788
Ray Ontko & Co.   Software Consulting Services   http://www.ontko.com/