« Return to Thread: Filter an Sort performances

Re: Filter an Sort performances

by Frank Schoenheit, Sun Microsystems Germany :: Rate this Message:

Reply to Author | View in Thread

Hi Drew,

> Excellent...hmmm, that old saying comes to mind...Trust but Verify.
>
> This would be a good point to interject - Base supports, at least for
> JDBC connectors, a logging mechanism that could be employed here for
> profiling purposes..I think. Specifics of using this are on the wiki.
> http://wiki.services.openoffice.org/wiki/Logging_JDBC_Activity

Please do ... hope I didn't promise too much :)

>> The XRowSetApproveListener might come handy here: It's called before the
>> actual execution of the RowSet/Form happens, and it should be possible
>> to modify the statement/filter/order/other in this callback.
>
> Again, Excellent...now if we could do that with Sun Report Builder
> generated reports that would just be supper.. or can we? (didn't see
> that one coming did you...)

no, the SRB doesn't allow for this ATM.

However, I am not sure that callbacks are the best way here. Depends on
the scenario, of course.
My idea with reports and forms would be to pass Filter/Order/etc. at
time of opening the document. Finally, I suppose you do not want to
programmatically open the report designer and execute the report, but
you want to open the report document, each time with a different
filter/sort. Yes?

Ciao
Frank

--
- Frank Schönheit, Software Engineer         frank.schoenheit@... -
- Sun Microsystems                      http://www.sun.com/staroffice -
- OpenOffice.org Base                       http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

 « Return to Thread: Filter an Sort performances