>From RBase Help. Note comment about PROJECT command
"FEEDBACK
Operating Condition
Syntax: SET FEEDBACK ON/OFF
Default: OFF
This setting displays processing results when either calculating or editing
rows. With this setting on, R:BASE displays the number of rows processed and
the elapsed time to completion in the status bar. Displays occur while in the
Data Browser, when printing reports and labels, and when using certain R:BASE
commands including:
1. ALTER TABLE
2. COMPUTE
3. CREATE INDEX
4. CROSSTAB
5. DELETE
6. INSERT
7. The data transfer for the JOIN of two tables
8. LOAD
9. The data transfer for a PROJECT command
10. SELECT
11. SORTing a huge record set
12. the data transfer for a SUBTRACT of two tables
13. TALLY
14. The R:BASE UNION command "
Jim Bentley
American Celiac Society
[EMAIL PROTECTED]
tel: 1-504-737-3293
--- On Fri, 7/18/08, Lawrence Lustig <[EMAIL PROTECTED]> wrote:
> From: Lawrence Lustig <[EMAIL PROTECTED]>
> Subject: [RBASE-L] - Re: Animated GIF object
> To: "RBASE-L Mailing List" <[email protected]>
> Date: Friday, July 18, 2008, 3:15 PM
> <<
>
> So based upon what I am hearing back... no moving visual
> feed back to a user during
> such a PROJECT command is currently available? (Cursors are
> not an option here)
> >>
> Well, there's always a solution to everything. . .
>
> If you really, really, really need the feedback you can use
> a stored procedure. Include the stored procedure in your
> PROJECT, either on a spare column or on some other column.
> In the Stored Procedure code update your UI (a progress bar,
> or whatever). If the SP is projected into a spare column it
> doesn't need to take params or return a value. If
> it's projected into a real column, it needs to accept
> the column data as an argument and return the same value
> unchanged as the return value.
>
> This will slow down your PROJECT considerably, but it will
> do what you want.
>
> An alternative would be to ask for an enhancement to all
> SQL command called WITH MESSAGE that will periodically
> update the UI, or a setting to do the same thing.
> --
> Larry
