[dba-dev] Re: How to refresh DataSourceBrowser in a FrameControl

[Frank Schönheit]

Hi Fernand,

> I am afraid that the "parameter" stuff is not working at all
> 
> oForm.setint(1,1000) should gives a value of "1000" to parameter 1
> 
> but this does nothing, the oform.parameters stay empty ?

Hmm, this might be caused by some special implementation, seems to be
some inconsistency here, indeed.

> and SQL is 
> complaining about missing parameter value's

Well - parameters are the means by which sub forms are implemented, so I
am pretty sure they work in general. Not sure which concrete commands
cause the problem in your scenario :-\

> But passing a new command an reloading works like a charm... so we uses 
> this workaround sucesfuly

Fine :)

Ciao
Frank
-- 
-
To unsubscribe send email to dev-unsubscr...@dba.openoffice.org
For additional commands send email to sy...@dba.openoffice.org
with Subject: help

[dba-dev] Re: staus of bugfixes toward OOo 3.4 and dev300: cws fs34b and fs34c, fs35a, hsqldb19

[Frank Schönheit]

Hi Alex,

> I'm just glad you're still alive and kicking :-)) (and the same for the
> other guys if they're still around) The whole sudden-death-supernova
> radio silence was a bit freaky and more than a little sad :-)

Thank you - and ... well, yes. Not really a satisfying situation, for
nobody :-\

Ciao
Frank
-- 
-
To unsubscribe send email to dev-unsubscr...@dba.openoffice.org
For additional commands send email to sy...@dba.openoffice.org
with Subject: help

[dba-dev] Re: How to refresh DataSourceBrowser in a FrameControl

[Frank Schönheit]

Hi Fernand,

> Me again:
> when loading a paramerized statement i have aSQL error "Values not set 
> for all parameters"
> so i load
>aLoaderArguments(1).Name = "CommandType"
>  aLoaderArguments(1).Value = 2 'com.sun.star.sdb.CommandType.TABLE
>  aLoaderArguments(2).Name = "Command"
> aLoaderArguments(2).Value = "SELECT distinct *   FROM  
> pmgdbase.adv_reden_tbvips  WHERE pmgdbase.adv_reden_tbvips.REDENID = ? "

Argh.

There's no support for passing parameter values - the LoaderArguments
you specify are passed, by the FrameControl, to the component loaded
into it - which leads in DSB's case to
http://api.openoffice.org/docs/common/ref/com/sun/star/sdb/DataSourceBrowser.html#XInitialization
=> No support for such a thing.

In theory, the DSB - more precise: the form loaded into it - allows
delegating parameter requests to an external instance, via the
css.form.XDatabaseParameterBroadcaster interface. It allows registering
listeners which are asked when a parameter is to be filled.

However, you have no chance of passing such a listener to the
FrameControl in a way that it reaches the form in time.

So - for the very initial load, the parameter-based request won't work,
sorry.

Ciao
Frank
-- 
-
To unsubscribe send email to dev-unsubscr...@dba.openoffice.org
For additional commands send email to sy...@dba.openoffice.org
with Subject: help

[dba-dev] Re: How to refresh DataSourceBrowser in a FrameControl

[Frank Schönheit]

Hi Fernand,

> Thanks, now i have my Model and can reload, but the reloading do not 
> affects the activecommand ? an not the results
> 
> So how to make the new Loaderarguments ("active") or how to pass a new 
> activecommand to the DatasourceBrowser

Ah - I missed, in your original mail, that you actually want to change
the command underlying the DSB.

The simplest way might be to just set the "Command" property of the
database form (the model you just retrieved) before reloading.

A slightly more complex, but cheaper (in terms of runtime resources)
solution would be to base the DSB on a parametrized statement ("...
WHERE REDENID = ?"), and then use the XParameters.setInt (or whatever
type the REDENID column has) method:
  oForm = oController.com_sun_star_awt_XTabController_getModel()
  oForm.setInt( 1, sid )
  oForm.reload()

> my code is now:
> 
>   odlg.getcontrol("Grid2").LoaderArguments = aLoaderArguments2 ' the new 
> arguments with a new SQL statement in it

The LoaderArguments are used at the time the DSB is plugged into the
frame, and then discarded (at least as far as the DSB is concerned, not
sure the FrameControl implementation makes later use of it). Thus,
reload does know nothing 'bout changed LoaderArguments, so this doesn't
work.

>   oDatasourceBrowser = odlg.getcontrol("Grid2").frame.controller
>   omodel = oDatasourceBrowser.com_sun_star_awt_XTabController_getModel()
>   omodel.reload

As said above,
  oModel.Command = 
before doing the reload should help already.

Ciao
Frank
-- 
-
To unsubscribe send email to dev-unsubscr...@dba.openoffice.org
For additional commands send email to sy...@dba.openoffice.org
with Subject: help

[dba-dev] Re: staus of bugfixes toward OOo 3.4 and dev300: cws fs34b and fs34c, fs35a, hsqldb19

[Frank Schönheit]

Hi Zoltán,

> the hsqldb19 approved by QA still wait for DEV300 integration.

forgot to answer the hsqldb19 part ...

As far as I know, the original goal was to integrate hsqldb19 into 3.4,
if possible. Not sure what got of this idea, since EIS currently says
"Release = OOo 3.5", it might have changed. Ocke should know the details.

>From what I know, it is still worth pursuing a 3.4 target for the CWS,
at least because it is certainly desirable for the HSQL project. On the
other hand, the radical change in the CWS (moving to HSQLDB 2) is
certainly a risk for 3.4 - and while you and Ocke did a great job in
finding and fixing zillions of bugs already, there might be more,
undiscovered so far - and if they were to go into OOO340, it might be
hard to fix them in time for the release.

Ciao
Frank
-- 
-
To unsubscribe send email to dev-unsubscr...@dba.openoffice.org
For additional commands send email to sy...@dba.openoffice.org
with Subject: help

[dba-dev] Re: staus of bugfixes toward OOo 3.4 and dev300: cws fs34b and fs34c, fs35a, hsqldb19

[Frank Schönheit]

Hi Zoltán,

> I know correctly that the latest integrated into m106 database connected 
> cws was dba34d.
> The fs34b in finished status, and fs34 fixed two issue and still open, 
> the hsqldb19 approved by QA still wait for DEV300 integration.
> 
> In EIS i found that is nmerged to cws 
> dba34d:

No, it is the other way 'round: dba34d was merged into fs34b. Sorry, my
wording in EIS could have been better :)

> But I fuond in OOO340m0/DEV300m106 that for example,  bug 117454 old 
> report, and bug 117472 is still in.
> That means fs34b not merged correctly.

Not sure at the moment what the "finished" status for fs34b is supposed
to tell us - at least it implies "not integrated, yet".


says that fs34b is in status "integrated", but the "Milestone
(integrated)" field is empty - this means that the milestone which the
CWS has been integrated into has not been finished, but is ongoing -
which means the CWS will be in OOO340.m1. If it were in OOO320.m0, then
the "Milestone (integrated)" field would be filled, since m0 is done
already.

So, the bottom line is: No surprise that fs34b's bugs are not fixed in
m0, expect the fixes for m1.

As far as I know, m1 has been built already, or at least it was started
(since I got questions 'bout some build breakers caused by a flawed
integration of another CWS of mine :) ). Not sure whether it is finished.

Also, I don't know the timeline for the upcoming builds, but I know that
I am not the only one who thinks we (whatever "we" means in this
context) should at least release a proper 3.4. But again, there's still
some dust in the air, which might need to settle beforehand ...

Ciao
Frank
-- 
-
To unsubscribe send email to dev-unsubscr...@dba.openoffice.org
For additional commands send email to sy...@dba.openoffice.org
with Subject: help

[dba-dev] Re: How to refresh DataSourceBrowser in a FrameControl

[Frank Schönheit]

Hi Fernand,

> Point is : my Datsourcebrowser has no model ?

Ah ... the pitfalls of the Basic UNO binding!

The controller supports both the XController and XTabController
interfaces, both have a getModel() method, so "oController.getModel()"
(or "oController.Model") is ambiguous in Basic. It is not defined (to my
knowledge) to which of the methods this is resolved - seems to be
XController.getModel(), which indeed returns NULL - which is expected,
since the DataSourceBrowser does not have an associated document (which
would be the XModel returned by XController.getModel()).

Basic's syntax to access a method *with* specifying the interface it is
defined at is
  oDataSourceBrowser.com_sun_star_awt_XTabController_getModel()

Ciao
Frank
-- 
-
To unsubscribe send email to dev-unsubscr...@dba.openoffice.org
For additional commands send email to sy...@dba.openoffice.org
with Subject: help

[dba-dev] Re: OpenOffice Internship-2011

[Frank Schönheit]

Hello Amit,

> I am Amit Pal a undergraduate student from IT-BHU, majoring in computer
> science and eng. I want to be a part of summer internship 2011. I will
> be very glad if you tell me the procedure. I am new here 

Hmm, I don't know about any internship program 2011, and given the
recent changes in the project, I doubt there will be one soon. We'll
have to wait 'til the dust has settled, to see whether there will be any
such program under Apache's (OOo is a Apache Incubator project by now)
supervision.

Ciao
Frank
-- 
-
To unsubscribe send email to dev-unsubscr...@dba.openoffice.org
For additional commands send email to sy...@dba.openoffice.org
with Subject: help

[dba-dev] Re: How to refresh DataSourceBrowser in a FrameControl

[Frank Schönheit]

Hello Fernand,

> I try to use the "com.sun.star.frame.FrameControl" in a dialog acting as
> a "subforms'.
> 
> So i have 2 Framecontrol's  loaded with a dataSource browser based on a
> SQL-statement
> 
> When selecting a row in the first FrameControl the data in the second
> must been refreshed (passing a new SQL-statementto the second Framecontrol).
> 
> I found no way to do that because the activeCommand off the Resultset is
> "readonly".

The DataSourceBrowser supports the css.form.FormController service, thus
a css.form.XFormController interface, so the getModel method will return
the css.form.component.DataForm which represents the data. This, in
turn, has a css.form.XLoadable interface, which supports a "reload" method.

So, something like

  oDataSourceBrowser.getModel().reload()

should do (assuming that oDataSourceBrowser is the controller loaded
into your "Grid2" control).

Ciao
Frank
-- 
-
To unsubscribe send email to dev-unsubscr...@dba.openoffice.org
For additional commands send email to sy...@dba.openoffice.org
with Subject: help

[dba-dev] Re: Shared Library registration with regcomp

[Frank Schönheit]

Hi Rohit,

> I am trying to register the library (.so) file for the example skeleton
> sdbc driver using "regcomp" tool into the services.rdb file. When I try
> to register the shared library in "connection/unxlngi6.pro/lib

I suppose you mean "connectivity/unxlngi6.pro/lib" here, i.e. the local
output tree of the "connectivity" module?

> " directory it fails giving
> "CannotRegisterImplementationException" exception.
> 
> However during the build process this library is copied into
> 'solver//330/unxlngi6.pro " directory and when I
> try to register this file it succeeds !
> 
> Could anyone tell me what changes happen to the library files during
> build process when they are copied into the solver directory?

I suppose this is a LD_LIBRARY_PATH problem: your library is probably
linked against other libraries from URE (the UNO runtime environment),
which, in a complete build, also reside in $SOLVER/330/unxlngi6.pro/lib.
So, if your library resides there, too, and your LD_LIBRARY_PATH
contains ".", then loading the lib succeeds. Loading the lib in the
local output tree doesn't succeed, since the loader doesn't find the URE
libs there.

To verify this, try "ldd " to see which libs your actual lib
needs, and whether the loader finds them.

> My problem is that the my sdbc driver library is supposed to implement
> com.sun.star.sdbc.Driver service but when I register it from solver it
> is implementing some strange services like 
> "com.sun.star.comp.svl.PathService" and
> "com.sun.star.uno.util.numbers.SvNumberFormatterServiceObject" hence I
> am wondering if something is changing the library during the build process.

This means that you don't export the proper symbols from your library,
which most probably means your map file is wrong. Look into an other
driver's makefile.mk, search for a directive referring to a file
component.map, and copy this for your driver.

Background: since your driver doesn't export the necessary "component_*"
functions, which are looked by by the UNO component registration
process, those functions are taken from another (random) library which
your actual library links to. And those other functions, in your case
obviously originating from the libsvl* library, write their very UNO
component information.

Note that what you're doing is a component with so-called active
registration, which is deprecated. Passive registration is to be
preferred nowadays, it means that instead of adding (active) code to
your library which describes the UNO components it exports, you place an
XML file near your lib, and describe the components therein. See
http://wiki.services.openoffice.org/wiki/Passive_Component_Registration
for details.

This completely avoids the regcomp stuff, though at the moment, I am not
sure how to integrate those passive registration into the
build/deployment process. I think you can learn from other modules here,
too - VCL comes to mind, look into vcl/util/vcl.component, and how it is
used.

HTH

Ciao
Frank
--
-
To unsubscribe send email to dev-unsubscr...@dba.openoffice.org
For additional commands send email to sy...@dba.openoffice.org
with Subject: help

[dba-dev] Re: Opening forms in m105

[Frank Schönheit]

Hi Peter,

> my forms are not readable anymore (really ugly).
> That seems due the fact that forms are now opened in printlayout instead 
> of weblayout, but: shouldn't forms created in weblayout continue to open 
> in weblayout?
> Otherwise all those forms have to be edited oncemore, and people who 
> don't know about this fact may think 3.4 is buggy.
> For new forms this is ok.
> What's the reason (issue) for this change?

One of those nasty things called "bug":
http://openoffice.org/bugzilla/show_bug.cgi?id=117545

Ciao
Frank
--
-
To unsubscribe send email to dev-unsubscr...@dba.openoffice.org
For additional commands send email to sy...@dba.openoffice.org
with Subject: help

[dba-dev] Re: dba qa webpage

[Frank Schönheit]

Hi Zoltán,

> On 
> http://qa.openoffice.org/ooQAReloaded/DatabaseTeamsite/ooQA-TeamDatabase.html 
> webpage, Chris is a dba qa project lead.

Fixed, thanks.

Ciao
Frank
--
-
To unsubscribe send email to dev-unsubscr...@dba.openoffice.org
For additional commands send email to sy...@dba.openoffice.org
with Subject: help

[dba-dev] Re: Flat text Database Opening Changes in DataSource Browser

[Frank Schönheit]

Hi Fernand,

> Sinds 3.3 the opening of a Flat Text Database (showing the tables) in
> the DataSource Browser has changed.
> Before, when  showing the Tables (all the ".txt" files in a directory)
> was fast.and no files where locked by OO. Now , OO seems to load in
> Memory all the tables (.txt files) and locks all the files in the
> directory what makes a multi-user aproch imposible . With many files in
> the directory, it takes "ages" to view the tables also.
> Is this wanted behavior or should i file a issue ?

Please file an issue. Be sure to set the "regression" keyword, as it
sounds like this fits criterions for 3.4 release relevance (see
http://wiki.services.openoffice.org./wiki/OOoRelease34#Release_relevant_issues).

Thanks & Ciao
Frank
--
-
To unsubscribe send email to dev-unsubscr...@dba.openoffice.org
For additional commands send email to sy...@dba.openoffice.org
with Subject: help

[dba-dev] Re: Form wizard changed views?

[Frank Schönheit]

Hello Zoltán,

> Two other options,  "Columnar Labels on Top", and  "Columnar Labels 
> Left" inserts some controls into the form, in way that the controls 
> placed wrongly, not fully within the form, hang out, the field starts in 
> page, but ends out of the page.
> 
> When investigated further I found changes in form final format, until 
> now the form wizard created forms in web layout, now the form created in 
> print layout, and consequently the the above two settings  creates form 
> in weblayout and places correctly within their limits, but the form 
> saved in print layout, and some controls hangs out.
> 
> In the earlier versions until 3.3 I could switch between print/web 
> layout in data input mode, now this is impossible and form stays in 
> print mode, which is not wrong.
> users prints forms as reports very often, and usage of web layout in 
> past caused misunderstanding.
> 
> I have no earlier information about this change, i think no others have 
> this info.
> 
> My question is that, reopen this bug to fix two other settings in print 
> layout, or submit a new bug.
> Or this default form layout change was unintentional?

To me it looks as if the online layout broke somehow. Normally, Base, at
least when opening a form in edit mode, explicitly switches the document
view to Web Layout. That was considered a feature so far, not a bug :)

This does not seem to work in m103: Initially, forms come up in Print
Layout, then you can toggle the mode between Print Layout and Web
Layout, and the next form opens in the same mode in which you closed
your last form.

Now known as http://openoffice.org/bugzilla/show_bug.cgi?id=117545.

Ciao
Frank
--
-
To unsubscribe send email to dev-unsubscr...@dba.openoffice.org
For additional commands send email to sy...@dba.openoffice.org
with Subject: help

[dba-dev] Re: Reports in m102 don't work

[Frank Schönheit]

Hi Peter,

> seems the "classical" Report doesn't work in m102 anymore. Known issue?

for the record: submitted (by you) as bug 117454, will be fixed in CWS
fs34b, target OOo 3.4.

Thanks & Ciao
Frank

-- 
ORACLE
Frank Schönheit | Software Engineer | frank.schoenh...@oracle.com
Oracle Office Productivity: http://www.oracle.com/office

--
-
To unsubscribe send email to dev-unsubscr...@dba.openoffice.org
For additional commands send email to sy...@dba.openoffice.org
with Subject: help

[dba-dev] Re: Next record in form navigation bar

[Frank Schönheit]

Hi Peter,

> if I step to the last record, shouldn't the button "Next Record" then 
> not be disabled?
> There's a button "New Record" for this purpose.
> Often it happens, that the "Next Record" button is accidentally pushed 
> after the last record in a filtered recordset.

Well, the idea here is (and that's basically an assumption of mine, the
behavior is that way for longer than I work on the product) that the
"insertion row" is a "virtual" (n+1)'th row of our form, so pressing
"next" repeatedly lets you travel through all those n+1 records.

Whether or not this is a good user experience - phh. Personally, I never
considered it problematic. But my gut feeling is that's  question pretty
hard to decide.

Ciao
Frank

-- 
ORACLE
Frank Schönheit | Software Engineer | frank.schoenh...@oracle.com
Oracle Office Productivity: http://www.oracle.com/office
--

To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: sy...@dba.openoffice.org with Subject: help

Re: [dba-dev] Changes to DB are not persistent

[Frank Schönheit]

Hi Daniel,

> I'll review my code after Christmas and watch for the windows-problem,
> but I suspect some mistake with un-closed connections resulting in
> problems with locking (like a lock is held by an unclosed connection
> ...). Definitely my mistake and not an OOO-issue.

Well ... nearly everything which crashes is an OOo issue. In some cases,
we tend to say that fixing the particular crash resulting of an API
misuse is so difficult (for whatever reasons) that simply using the API
the right way is the easier "fix" :), but a crash is always worth a
look, at least.
So, if you have a reproducible crash - don't hesitate to submit an issue
for it. Fixing crashes can just make OOo better (and be it by a
developer thinking about why the crash could happen at all, what's
broken in the design, and how to prevent that kind of bugs in the future
:) ).

> Thank You very much for Your profound explanation. I'm rather new to
> OOO-coding, so your help is very welcome

You're certainly welcome.

Ciao
Frank

-- 
ORACLE
Frank Schönheit | Software Engineer | frank.schoenh...@oracle.com
Oracle Office Productivity: http://www.oracle.com/office

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] New flterbehavior for forms in 3.3

[Frank Schönheit]

Hi Peter,

> if a listbox in a form is linked to another table (foreign key relation) 
> and the content of the listbox is loaded with a select statement (no 
> subform), then the behavior in OpenOffice.org 3.3 is another one then in 
> OpenOffice 3.2.0:
> 
> If I click on the filter button on the form, in OpenOffice 3.3 the 
> filter navigator pops up and the listbox keeps its last value.
> 
> In OpenOffice 3.2 the listbox is empty and the fiter navigator is not 
> visible, which I find better.
> 
> Bug or feature?

I remember we fixed two bugs with list boxes and the form based filter
(114540, 114403), fixed in CWS dba34a. In the course of fixing those, we
also found other strange behaviors in this context, though I don't find
the issues right now. Maybe what you describe is one of those quirks.

In any way, you might want to try a recent developer snapshot to see if
the problem is fixed there.

Without further details, the "bug or feature" question is difficult to
answer. But as always - feel free to submit an issue.

Ciao
Frank

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] Changes to DB are not persistent

[Frank Schönheit]

Hi Daniel,

> That's a good hint. I experimented with Connection.close(), but it
> didn't solve the problem.

Hmm, I would have expected this to implicitly flush the changes.

> But freeing the DataSource with
> DataSource.Dispose() seems to work.

Not a good idea, see below.

> Now (cached) changes to the DB are
> written to the odb-file. And the lock gets removed - I suspect a
> locking-problem to be responsible for the crash of the windows-version.

I don't have time trying at the moment, but the lock file should be
removed, too - basically, it indicates that there is an open connection
to the database. Assuming that your code is the only client which
accesses the database, disposing your connection should also remove the
lock.
Or is it that there are other places (the same DB doc opened in a
window? Other Basic code? An open data source browser displaying some
table?) which access the DB doc or the data source?

> However some uncertainty remains. I can't figure out from the
> documentation when a close() or a dispose() is necessary and when not.
> For example Dispose()-ing the DB-Context doesn't seem to be a good idea
> as one has to restart OOO then to open a new DB-Connection ... So are
> there any rules when to Dispose() and when not?

First, for a connection (and this is special to this object, /not/ a
general rule), "close" is equivalent to "dispose". So, let's talk about
dispose only.

In general: Dispose objects when you *own* them, don't dispose them if
you don't.

A connection obtained with getConnection is yours, you are responsible
for freeing - i.e. disposing - it.

The DBContext isn't yours - it is a global object, existing in a single
instance only, available to the complete OOo application - so, do not
dispose it, or be punished with an unstable OOo.

As for the data source: They're shared objects, owned by the database
context. So, you should not dispose them - is it perfectly possible that
some other instance - e.g. the data source browser, a mail merge
operation, or some such - holds the data source, too.

>> So, some kind of flushing is necessary. This is inconvenient, but in 
>> the above sense, expected behavior.
> 
> Good to know, because neither the Basic Programming Guide nor the
> API-reference state this necessity to flush(), close() or dispose() and
> it seems to be unique to the HSQLDB-Backend. Seems to be at least
> confusing to me.

That's because HSQL is the only backend which stores the data in the
.odb file - for database where this is not the case, flushing is not
necessary by definition.

>> If you can create a small self-contained .odb (including the macro) 
>> showing this, please submit an issue at 
>> http://www.openoffice.org/issues/enter_bug.cgi?component=Database%20access.
>> Feel free to assign it to me (fs).
> 
> I hope DataSource.Dispose() will solve this issue, but I will figure
> that out after holidays (no windows at home). Is it ok to post (odb-)
> attachments to this list?

They should come through, however - at some point in time, an issue is
needed, anyways. So I'd prefer you submitting the issue, and atttaching
the .odb there.

Ciao
Frank

-- 
ORACLE
Frank Schönheit | Software Engineer | frank.schoenh...@oracle.com
Oracle Office Productivity: http://www.oracle.com/office


-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] Changes to DB are not persistent

[Frank Schönheit]

Hi Daniel,

> The code is adding a row to a database (Base-Document with embedded
> HSQL-DB) every time it gets called. However the changes are lost after
> closing OOO. To make them permanent it's necessary to flush() the
> DataSource.
> 
> First question: This is not exspected bahaviour, is it? Changes should
> be persistently saved without calling flush(), or am I wrong?

Well ... the problem with the ZIP-file approach of ODBs is that it is
impossible to immediately write all changes you did to the file.
(Anybody wishing to start a discussion how this violates fundamental
database principles ... please direct your concerns to the ODF faction.
I'd be grateful for any assistance in explaining why ZIP as a database
backend is a joke, at best.) That's basically a question of performance.

So, some kind of flushing is necessary. This is inconvenient, but in the
above sense, expected behavior.

However, note that your macro contains a resource leak, in that it
retrieves a connection, which it does not dispose afterwards - at the
very end of the Sub, you should have a
  Connection.close()
This should free the resources associated with the connection, and at
the same time flush its changes.

> But the trouble gets worse... The flush() - workaround works fine on
> Linux (Using OOO 3.2.1 and 2.4 on Debian), but it crashes OOO 3.2.1 on
> Windows (XP) ungracefully.

If you can create a small self-contained .odb (including the macro)
showing this, please submit an issue at
http://www.openoffice.org/issues/enter_bug.cgi?component=Database%20access.
Feel free to assign it to me (fs).

Ciao
Frank

-- 
ORACLE
Frank Schönheit | Software Engineer | frank.schoenh...@oracle.com
Oracle Office Productivity: http://www.oracle.com/office

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] Duplication of browse buttons in report builder in DEV300m95

[Frank Schönheit]

Hi Zoltán,

> I found the duplication of browse buttons in report builder, property 
> browser "Data" tabs,  in DEV300m95, as described in issue for forms:
> http://www.openoffice.org/issues/show_bug.cgi?id=115430
> This will be solved in dba34b for forms, this will solve report builder 
> issue, too?

Yes, it will solve the issue in all places where the property browser is
used.

Ciao
Frank

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] Base bug storing large files in a blob

[Frank Schönheit]

Hi Andrew,

sorry for the delay, hope the answer is still of some use.

> **
> 
> I am working with OpenOffice basic, HSQlDB 2.0.
> 
> I have a table for attachments in my DB.
> When i upload a File that is big for example 32 MB or 72MB in my table 
> which has BLOB datatype which has a length of 1073741824 - i get an EOF 
> exception at the following line in my code
> 
> oSimpleFileAccess.writeFile(staticpath & FileName, oBinaryField1)
> 
> BASIC runtime error.
> An exception occured.
> Type: com.sun.star.sdbc.SQlException
> Message: org.hsqldb.HsqlException: java.io.EOFException
> 
> This is the point at which i get the BLOB data that is saved in my table 
> and write it to a defined path and then read it from there. When i 
> upload small files everything works smoothly.
> 
> **
> 
> Sounds like a bug to me... Is this plausible?

Sure. Would need investigation whether this is on HSQL or OOo side, but
pretty much sounds like a bug to me as well.

Ciao
Frank

-- 
ORACLE
Frank Schönheit | Software Engineer | frank.schoenh...@oracle.com
Oracle Office Productivity: http://www.oracle.com/office

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] Multiple issues with Calc and JDBC-Oracle queries to large tables

[Frank Schönheit]

Hello Alexander,

> Accessing a few thousand rows works just fine, however, I got one
> table with about 1.2 mio. rows at 11 columns.
> ...
> OK, I'm not sure if Calc was made for my certain usecase or for that
> much data at all - but I thought I'll give you a hint that issues
> exists.

Honestly, accessing 1.2 mio. rows is ... stretching Base's limits. I am
not surprised at all OOo doesn't handle this - I don't think our code
base is prepared for that stunning amount of data.

> So, what should I be supplying for a bug report? And against what
> stream should I write a report?

You might want to submit a report at
http://qa.openoffice.org/issue_handling/pre_submission.html. Though the
reality is that allowing OOo to cope with that kind of data might
require a major overhaul, which will not be done without a pressing need
- which makes it rather unlikely that the problem will be fixed in a
foreseeable future.

Ciao
Frank

-- 
ORACLE
Frank Schönheit | Software Engineer | frank.schoenh...@oracle.com
Oracle Office Productivity: http://www.oracle.com/office

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] issue 112706: can I help?

[Frank Schönheit]

Hi Terry,

apologies for us ignoring your question for so long ... I don't really
have good excuse except laziness or something equally ... self-bashing,
so I don't even try ...

Just in case you're still interested in a response:

> OResultSet::move fails to find a matching bookmark (after 0
> interations through the loop starting at line 1600) and raises the
> assertion.

I think this points to the problem here. Well, into its direction, at least.

m_aPosToBookmarks is expected to be filled by this method, too. I'd
expect to find calls to OResultSet::move with a FIRST and possibly
subsequent NEXT parameters. In those calls, the map should be filled. If
the method is not called, then it could mean the method is not called -
in this case, the problem lies up the stack, again. If the method is
called, but the bookmark map is not filled (which I assume), this would
mean that m_nUseBookmarks is SQL_UB_OFF.

This parameter is set in Statement::setUsingBookmarks. Since
OResultSet::move is called with a bookmark request, this means the
layers above it assume the result set supports bookmarks - which means
they also should have called setUsingBookmarks on the respective statement.

If they *did* call it, with the proper value, but subsequently, the ODBC
driver returns another value, this means that either setUsingBookmarks
didn't deliver the wrong result to its caller ("no success"), or the
caller didn't respect the result, or the ODBC driver didn't deliver the
proper result.

If setUsingBookmarks has not been called before, then again the bug is
in the upper layers, I'd say - since then they're requesting
bookmark-based movement from the result set without enabling bookmarks
at the statement.

So, those would be the next things you could check: Is m_aPosToBookmarks
filled? If not - why? Is setUsingBookmarks called? With which
parameters, and which result? Does the value passed to setUsingBookmarks
match to what later on is retrieved to initialize m_nUseBookmarks?

HTH

Ciao
Frank

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] postgres ODBC problem with view

[Frank Schönheit]

Hi Josh,

> If so, that's rather problematic.  The CTID is a physical pointer ID,
> and as such can change out from under a current session if there are
> concurrent updates.  Using the CTID to grab rows could result in errors
> or even seeing expired data.

Which means SCOPE would be something other than bestRowSession - and the
bug on OOo side would be to use CTID for the given purpose nonetheless.

@Zoltan: Care to submit an issue?

Ciao
Frank
-- 
ORACLE
Frank Schönheit | Software Engineer | frank.schoenh...@oracle.com
Oracle Office Productivity: http://www.oracle.com/office

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] postgres ODBC problem with view

[Frank Schönheit]

Hi Josh/Zoltan,

>> The data content could not be loaded.
>> SQL Status: 42703
>> Error code: 7
>> ERROR: column "ctid" does not exist;
> 
> That's very odd. ctid is a system column; no driver should be accessing
> it, for any reason.

Ocke knows more about this, but I suspect the PQ driver might deliver
that column's name as BestRowIdentifier, which might tempt our RowSet to
use it in some kind of "SELECT * FROM  WHERE ctid=?" statement
(for re/fetching rows).

Ocke?

Ciao
Frank
-- 
ORACLE
Frank Schönheit | Software Engineer | frank.schoenh...@oracle.com
Oracle Office Productivity: http://www.oracle.com/office

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] How to pass password when opening DatasourceBrowser

[Frank Schönheit]

Hi Fernand,

>> Is your oconn object, by any chance, invalid?
> I can Xray it and it shows all details according to the wanted 
> connection, so ??
> 
> only passing the password to the com.sun.star.comp.dba.ODatabaseSource 
> password property works for me

I'm clueless than :(

Ciao
Frank

-- 
ORACLE
Frank Schönheit | Software Engineer | frank.schoenh...@oracle.com
Oracle Office Productivity: http://www.oracle.com/office

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] How to pass password when opening DatasourceBrowser

[Frank Schönheit]

Hi Fernand,

> You clueless, thats new for me :-)

Damn, that slipped my attention, normally I do not admit that :)

> I am still convinced thats your machine knows the Username and 
> passwords, or  your sytem is never asking for it :-) ?

If I replace the "getConnection" call to create the connection with
"connectWithCompletion", then it actually asks for the user/password -
so: no, that's not the difference :)

Ciao
Frank



-- 
ORACLE
Frank Schönheit | Software Engineer | frank.schoenh...@oracle.com
Oracle Office Productivity: http://www.oracle.com/office

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] How to pass password when opening DatasourceBrowser

[Frank Schönheit]

Hi Fernand,

> Are you sure you didn' tryed with user/password before you tryed the 
> activeconnection, because OO remembers the connection made by 
> user/password ?

Yes.

> The code who works but is asking for User and pasdword:
> 
> 
>   Dim aProps(7) as New com.sun.star.beans.PropertyValue
>   aProps(0).Name = "DataSourceName"
>   aProps(0).Value = "mysql_native" ' deze "naam" moet dus GEREGISTREERD 
> ZIJN als Database in OO
>   aProps(1).Name = "CommandType"
>   aProps(1).Value = 0
>   aProps(2).Name = "Command"
>   aprops(2).value = "pmgdbase.mag_news_export"
> 
> The code who do not works :
> 
>   oDB = CreateUnoService("com.sun.star.sdb.DatabaseContext")
>oConn = 
> oDB.GetByName("mysql_native").GetConnection("user","password")
>'  xray oconn
>   Dim aProps(7) as New com.sun.star.beans.PropertyValue
>   aProps(0).Name = "ActiveConnection"
>   aProps(0).Value = oconn
>   aProps(1).Name = "CommandType"
>   aProps(1).Value = 0 ' 0 = tabel , 1 = query , 2 = SQL statement
>   aProps(2).Name = "Command"
>   aprops(2).value = "pmgdbase.mag_news_export

One difference I see here is that you do *not* pass the DataSourceName
in the second case (my macro here does). This might make the difference
- can you try passing it, additional to the ActiveConnection?

Is your oconn object, by any chance, invalid?

Ciao
Frank
-- 
ORACLE
Frank Schönheit | Software Engineer | frank.schoenh...@oracle.com
Oracle Office Productivity: http://www.oracle.com/office

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] How to pass password when opening DatasourceBrowser

[Frank Schönheit]

Hi Fernand,

> Wath i already tryed en yet again tryed
> 
>   oDB = CreateUnoService("com.sun.star.sdb.DatabaseContext")
>   oConn = 
> oDB.GetByName("mysql_native").GetConnection("username","password")
> 
>   Dim aProps(7) as New com.sun.star.beans.PropertyValue
>   aProps(0).Name = "ActiveConnection"
>   aProps(0).Value = oconn
> 
> but the browser stays empty ! ( i tryed with  table and sql Statement)

"stays empty"? If you pass an ActiveConnection to the DSB, then it stays
empty, if you don't pass it, then it asks for user/password, and
properly displays your table? Did I get this right?

> maybe you did wath i already found out:
> 
> - worked from a opened Basedoc ?

no Base doc open at all, I did this from within a Writer doc.

> - you tryed first the code with datasourceName and made the connection 
> manualy and then changed he code to activeconnection ?

Used the same code as you wrote above.

> i trye to connect to a MySQL datasource using the Native Connector

/me too.

Ciao
Frank

-- 
ORACLE
Frank Schönheit | Software Engineer | frank.schoenh...@oracle.com
Oracle Office Productivity: http://www.oracle.com/office

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] LDAP-Mapping

[Frank Schönheit]

Hi Thomas,

> mailnews.js is looking the same like my user.js in Thunderbird. But the 
> problem still exists: If I change something like putting 
> "homePostalAddress" to "Custom4" (s.b.) the OO-field still stays empty. 
> Not so in TB.
> 
> pref("ldap_2.servers.default.attrmap.Custom4", 
> "homePostalAddress,mozillaCustom4,custom4");

Hmm - no idea at the moment what's going wrong there, and I would need
to find some time to fiddle with it myself to see what's going on ...
Might take a while :-\

Ciao
Frank

-- 
ORACLE
Frank Schönheit | Software Engineer | frank.schoenh...@oracle.com
Oracle Office Productivity: http://www.oracle.com/office

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] How to pass password when opening DatasourceBrowser

[Frank Schönheit]

Hi Fernand,

>   For opening a DataSourceBrowser I use following code
> 
>   Dim aProps(6) as New com.sun.star.beans.PropertyValue
>   aProps(0).Name = "DataSourceName"
>   aProps(0).Value = "mysql_native"
>   aProps(1).Name = "CommandType"
>   aProps(1).Value = 2 ' 0 = tabel , 1 = query , 2 = SQL statement

(I always recomment using com.sun.star.sdb.CommandType.* here, for
better readability of your code)

>   aProps(2).Name = "Command"
>   aProps(2).Value = "SQL statement"
>  aProps(3).Name = "ShowTreeView"
>   aProps(3).Value = false
>   aProps(4).Name = "ShowTreeViewButton"
>   aProps(4).Value = false

(note that ShowTreeView/Button are superseded (though still supported)
by Enable/ShowBrowser -
http://api.openoffice.org/docs/common/ref/com/sun/star/sdb/DataSourceBrowser.html#XInitialization)

>   aProps(5).Name = "ShowMenu"
>   aProps(5).Value = true
>   aProps(6).Name = "EscapeProcessing"
>   aProps(6).Value = false
>   oDataSourcebrowser = 
> frame1.loadComponentFromURL(".component:DB/DataSourceBrowser", 
> "_beamer", 0, aProps)
> 
>That works fine excepted that  the user is asked for a "Username" and 
> "Password" when  the  datasource is opened !
> 
> How can i avoid this behaviour by passing the "username and "password" 
> within my code ?
> I tryed to use a "ActiveConnection" where the Username and password are 
> passed... no luck

Hmm - I copied your code snipped, and added an "ActiveConnection"
parameter to aProps, containing an already established connection - this
worked like charm, as expected.

Sure you passed the right object, did not dispose it meanwhile, and the
like?

> Neither "UserName" or "Password" are accepted as arguments 

No, those are indeed not supported.

> thanks for any hint

The ActiveConnection is the way to go, and it usually works - not sure
what you do differently, sorry.

Ciao
Frank

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] LDAP-Mapping

[Frank Schönheit]

Hi Thomas,

> I cannot find any way to change LDAP-mapping in OO 3.2.1 (OpenLDAP). In 
> Thunderbird I can map every field successful with user.js.
> 
> For OO I did this: http://docs.sun.com/app/docs/doc/817-7496/fjdcg?a=view
> 
> - LDAP.xcu i.e. with "Mapping": mapping
> 
> - mapping-attr.map i.e. with this:
> org.openoffice.UserProfile/Data/c = registeredAddress
> 
> I don't get any data from "registeredAddress". I can change whatever I 
> want from fields used in UserProfile.xcs, there is no change... I am 
> also confused about this fields (<-> fields in UserProfile.xcs ?):
> http://dba.openoffice.org/FAQ/LDAP_field_mapping.html
> 
> Any idea, what I am doing wrong?

First, you're mixing up two different things :)

The documentation at docs.sun.com talks about user profile data in a
multi-user installation of StarOffice.

LDAP_field_mapping.html talks about the field mapping used by the LDAP
address book driver.

I suppose the latter - LDAP address book access - is what you're
interested in, really. Then the second problem is that
LDAP_field_mapping.html is out of date :-\

Since LDAP address book access is implemented using Mozilla code,
tweaking the mapping is two-step: First, locate mailnews.js in your
installation: It controls how the Mozilla code translates LDAP fields
into programmatic address book fields.
Second (and probably optional), the org.openoffice.Office.DataAccess
configuration (in a DataAccess.xcu file somewhere deep in the "share"
folder in your installation, but also and preferably accessible
programmatically) maps programmatic address book field names to UI
column names.

Those two together should give you control over what LDAP fields are
actually displayed, and how.

Ciao
Frank

-- 
ORACLE
Frank Schönheit | Software Engineer | frank.schoenh...@oracle.com
Oracle Office Productivity: http://www.oracle.com/office

Komplementärin: ORACLE Deutschland Verwaltung B.V.
Rijnzathe 6, 3454PV De Meern, Niederlande
Handelsregister der Handelskammer Midden-Niederlande, Nr. 30143697
Geschäftsführer: Jürgen Kunz, Marcel van de Molen, Alexander van der Ven

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] ResultSetType Settings in Openoffice Base

[Frank Schönheit]

Hello Asli,

> I am currently developing a DB project and I have implemented a database
> with IBM DB2 and connected it with jcc driver to Openoffice base. I had
> problems with "join queries of several tables". I searched in the source
> code of oo and in the internet, and I realized that the error arises from
> ResultSet settings, which are set to TYPE_SCROLL_SENSITIVE, default by
> openoffice. In order to display the results for a join query, resultSetType
> should be   TYPE_SCROLL_INSENSITIVE.

Hmm, I answered this a few days ago over there in us...@dba, but even
the web archive at
http://dba.openoffice.org/servlets/BrowseList?listName=users&by=date&from=2010-09-01&to=2010-09-30&first=1&count=8
is missing it, so perhaps it got lost ...

Here's my original answer:

You should not tamper with the content.xml, instead, set the value
programmatically.

For this, execute the following macro in the context of your .odb file:
  Dim settings as Object
  settings = ThisDatabaseDocument.DataSource.Settings
  settings.RespectDriverResultSetType = TRUE
  ThisDatabaseDocument.store

This tells Base to be less optimistic with its result set settings. That
is, normally Base assumes that it can use the most aggressive result set
type/concurrency, and that a database driver will silently downgrade
this to what it supports.

However, some drivers (and at least IBM's Universe drivers fall into
this category) do no silent downgrade, but instead produce an error. In
those cases, "RespectDriverResultSetType" tells Base to ask the driver
for the supported types.

However, also note that there are known drivers where this setting
doesn't work, simply because the driver itself lies about its supported
types. Again, some versions of IBM's Universe JDBC drivers fall into
this category.

So, you simply need to try out whether this setting really helps you.

Ciao
Frank

-- 
ORACLE
Frank Schönheit | Software Engineer | frank.schoenh...@oracle.com
Oracle Office Productivity: http://www.oracle.com/office

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] Reopen issue or submit new one?

[Frank Schönheit]

Hi Zoltán,

> After solving issue 113583 in fs33a, OOo still crashing with Charts.
> 
> The  chart change saving part solved in this issue, but some hanging or 
> crashing not.
> 
> Opened existing charts some of them worked without problem, but 3D Bar 
> chart and XY charts not picked up fully source data.
> 
> They showed  as Colums1, Column2, Column3, and not contain any data 
> created empty Chart.
> After editing create normal Chart.
> Some cases you can not go into Chart area with Double click, OOo hangs 
> or Crashes, no crahsreporter working I created screencast.

While symptoms - crashes and wrong data - are still there, the reason
why the issues was not completely fixed might be exactly because it
mixes different problems. So perhaps it's better to submit separate
issues, with one issue describing exactly one problem (the crash, the
non-working chart activation, the wrong data).

Ciao
Frank
-- 
ORACLE
Frank Schönheit | Software Engineer | frank.schoenh...@oracle.com
Oracle Office Productivity: http://www.oracle.com/office

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] Report Builder Roadmap

[Frank Schönheit]

Hi Drew,

> I think that these are implemented:
> - Rub Reports (partial)

I know I'm somewhat out of business with regard to Base and the Report
Builder, but I can't remember having seen sub reports :)

> - Repeatable Group Footer
> - Hyperlink Controls

ditto

> - Multi-Column support

ditto

Ciao
Frank

-- 
ORACLE
Frank Schönheit | Software Engineer | frank.schoenh...@oracle.com
Oracle Office Productivity: http://www.oracle.com/office

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] Report Wizard Modules

[Frank Schönheit]

Hi Drew,

> If anyone happens to have this off the top of their head. which source 
> modules would one look at to find the code for the Report Wizard 
> functionality?

All in module "wizards". The UI, together with the backend
implementation for text-based reports, is in
wizards/com/sun/star/wizard/report. The backend implementation for
ReportBuilder-reports is in wizards/com/sun/star/wizard/reportbuilder.

Ciao
Frank

-- 
ORACLE
Frank Schönheit | Software Engineer | frank.schoenh...@oracle.com
Oracle Office Productivity: http://www.oracle.com/office

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] What to do with "old" type of report issues

[Frank Schönheit]

Zoltán,

>  From time to time issues coming out with "old" type of reports.
> I know that SRB/ORB integration stopped for unknown/possible licensing 
> issues.

? The Report Builder will continue to be available for download, so ...?

> What will be happens with the open issues of old reports.
> What to do if new problems arises, confirm it and assign developer who 
> will not correct the problem.
> Or keep unconfirmed.

Targeting to "OOo Later" would be the most honest thing, I'd say.

Ciao
Frank

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] Report builder for OOO330_m2

[Frank Schönheit]

Hi Zoltán,

> Please upload report builder to qa ftp server.

I uploaded the version from an m3-build.

Ciao
Frank

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] MySQL Connector - alive?

[Frank Schönheit]

Hi Andrew,

> Wondering if anyone has any information at all about the connector?
> 
> The main extension site is still holding version 1.0.1 from 2009.
> 
> The qa-upload alpha verson hasn't updated since Jan 2010
> 
> Conanical and  OpenSUSE are including 1.0.1 in the repositories.
> 
> So what's up with this, anyone know anything?

There have been minor changes since 1.0.0, which led us to increasing
the number for 1.0.1. Those changes are not relevant to functionality
(except that in one case, it /could/ fix the localhost problem we were
not able to reproduce reliably), but more about adding correct RPATHs to
the libs, and technical stuff like that.

At the time of 3.3, there should be a 1.0.1 release.

Distros include 1.0.1 since they usually take the version from the main
trunk, which already is 1.0.1.

Ciao
Frank

-- 
ORACLE
Frank Schönheit | Software Engineer | frank.schoenh...@oracle.com
Oracle Office Productivity: http://www.oracle.com/office

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] Anyone on the Base team from Oracle in the office

[Frank Schönheit]

Hi Drew,

> There are issues coming in that really look like show stoppers - but a 
> waste of time to send email to release team without anyone in Hamburg to 
> comment on the effort to fix.

Ocke will still be on vacation for a while. I'll spend a few cycles for
Base, but (sadly) not starting immediately.

It might be good if you people collect a list of issues you consider a
stopper, and start raising them at relea...@ooo (if not already done
so), even if dev cannot comment on the effort so far. Better building
early pressure (as it would also help priorizing, ehm, my assignments :) ).

Ciao
Frank
  back from vacation the first day. Sorry, /[s|c]ould/ have announced
  here.

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] Where to find all open DB connections and closes them

[Frank Schönheit]

Hi Fernand,

> BTW: noch immer keine  "Base" heimweh  ?

:-P

Sometimes. There's so much interesting things I would have liked to do,
and there's so much nasty issues coming in which look like they should
be fixed before 3.3, but ...

On the other hand, my current assignments are pretty interesting, too :)

Ciao
Frank

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] Recovery process

[Frank Schönheit]

Hi Peter,

>>> seems the recovery process for base has some shortcomings yet.
>>> Neither a created report nor the basic code is restored after crashing
>>> and starting the recovery (WinXP and m6).
>> Hmm ... "nor the Basic code"? Do you mean that the Basic embedded in
>> your .odb is lost after a crash/recovery? That shouldn't happen at all -
>> is this reproducible?
>>
> I meant Basic code inside .odb that hasn't been stored before is lost, yes.
> Reproducable with http://qa.openoffice.org/issues/show_bug.cgi?id=107438 
> (ok I know the rules for the issues, if you confirm the behavior, I will 
> open another one).

Can reproduce. With Base as well as with Writer documents, and meanwhile
knowing some internals about the Basic IDE, I am not too surprised :)

If you submit an issue, I think it can be fixed in the course of the
auto recovery refactoring.

Ciao
Frank

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] Recovery process

[Frank Schönheit]

Hi Peter,

> 
> seems the recovery process for base has some shortcomings yet.
> Neither a created report nor the basic code is restored after crashing 
> and starting the recovery (WinXP and m6).

Hmm ... "nor the Basic code"? Do you mean that the Basic embedded in
your .odb is lost after a crash/recovery? That shouldn't happen at all -
is this reproducible?

Ciao
Frank

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] Opening a GridControl in a UNO Dialog

[Frank Schönheit]

Hi Noel,

>> Andreas knows ( I'll ask him )
> confirmation received, neither the dialog or basic streams are ODF ( /me
> phews a sigh of relief )

/me too :)

Ciao
Frank

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] Opening a GridControl in a UNO Dialog

[Frank Schönheit]

Hi Noel,

> hmm, looks like I lied, there is persistence of sorts, e.g. going from
> the filter to the dialog it seems the state of the dialog is transferred
> via the dialog stream so it looks like that I have already introduced
> some 'unofficial' attributes to support this,

Ouch. extending the ODF file format - and I think that the dialog
descriptions are part of ODF, too - is asking for trouble. Well, for a
lot of work, at least :-\

> but like I said, I am not
> happy to upstream the current scheme and it is not usable in the broader
> openoffice generic sense. This is the part would to be ironed out as
> part of upstreaming, I would be happy with your input/help on that.

Sure, let's see how far we can get there.

Thanks & Ciao
Frank

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] KOI8-U issue

[Frank Schönheit]

Hello Alexender,

> Hello!!! I am from Ukraine and I have found that
> in KOI8-U database is not correct display some symbols
>  
> Example: when i send the query or browse the table i get
> not correct letter "і" in word "Ав╕ац╕йна"  must be 'Авіаційна'

Do you use the integrated HSQLDB database, or do you connect to some
other database (e.g. MySQL)? Also, how did you enter the texts into the
database - using OOo, or using another tool?

Ciao
Frank

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] access to ldap server in oo 3.x

[Frank Schönheit - Sun Microsystems Germany]

Hi Lester,

> me and several other guys do experience difficulties in
> connecting from oo 3.x to ldap servers. see:
> 
> http://www.oooforum.org/forum/viewtopic.phtml?t=86482&sid=ae72a99dad9cf5c0714f8824e829
> http://user.services.openoffice.org/en/forum/viewtopic.php?f=40&t=20896&p=94733&hilit=ldap&sid=55e6bbb6ce8dd93f7bfd176aaa063a64#p94733
> 
> does anybody from the dba development team have a clue about this issue?

Not at all. I don't know of any (significant) change between 2.4 and 3.0
in this area.

Also, I have no clue what could cause this - every LDAP access I try
here works fine ...

You might want to try the latest developer snapshot of OOo
(http://download.openoffice.org/next/index.html), DEV300_m54. It
included a heavy refactoring in the LDAP access. More concrete, we
replaced the Mozilla code shipped with OOo (which is used for LDAP
access) with SeaMonkey code.
Perhaps LDAP access works with this version.

Ciao
Frank

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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] m54: inserting graphic into Oracle blob fails

[Frank Schönheit - Sun Microsystems Germany]

Hi Peter,

> using a form with a graphic doesn't work in m54 (jdbc, oracle 10g, Windows).

Did it work before?

> The message is "ORA-01400 cannot insert NULL ..."
> 
> I tried both "analyze sql command" true and false.
> 
> A known issue?

It might be related to another bug we had with image controls not
properly writing their content (in the case of being bound to text
fields). From what I know about that other bug, it is possible it also
manifests the way you describe.

The issue is fixed in CWS dba32e, which will probably materialize in
m56. If you're interested, I could upload a build of dba32e (Linux
and/or Windows) for you to check.

Ciao
Frank

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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] supportsCoreSQLGrammar and Primary Keys, etc.

[Frank Schönheit - Sun Microsystems Germany]

Hi Caolán,

> What I'm finding kind of hard though to find out though is if jdbc
> drivers should only be assumed to support setting primary keys if
> supportsCoreSQLGrammar is enabled and OOo is totally correct in what it
> does, and its a matter for postgres-jdbc to support it to get this to
> work.
> 
> Or if OOo is looking for more than it needs, e.g. some variation on
> supportsMinimumSQLGrammar || supportsCoreSQLGrammar ||
> supportsANSI92EntryLevelSQL is sufficient to enable setting primary keys
> or even if jdbc drivers should always be assumed to support setting
> primary keys ?

Requiring core SQL grammar for PK support is more of a heuristics (one I
didn't even know 'til know we use :) - that code must be really old).
Unfortunately, the current available MSDN ODBC SDK doesn't really define
core SQL grammar (but only minimum SQL grammar), so I am not sure how
correct this heuristics is.

Either way, nowadays we would implement this in another way: A driver
should be able to explicitly tell which features it (respectively its
database) supports. Since there doesn't exist an API for this, we used
to have some hard-coded meta-information like this in the code (e.g.
which DBs support primary keys, which formerly was determined by a
"supportsIntegrityEnhancementFacilities"-heuristics).

With CWS dbaperf2, we moved forward to a configuration-based approach.
That is, every driver is accompanied by configuration data describing
its capabilities. Here, we could introduce a "PK-support" feature in the
configuration data.

For generic drivers like the JDBC-SDBC-, ODBC-SDBC-, and ADO-SDBC
bridge, I tend to say they should always claim to support PKs, and leave
it to the system driver to reject PKs if they're actually not supported.

Ciao
Frank

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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] Open a form/report in a Base file from a standard action on a button - again

[Frank Schönheit - Sun Microsystems Germany]

Hi Drew,

> The form button can hold a URI for user with the standard action 
> 'Open', which is a type W3C [xmlschema-2] anyURI.
> 
> This is why? - this is the big hurdle...a naming convention designed for 
> the web, and it's in the standard and would need the OASIS folks to OK a 
> change. (expletive uttered here)

As far as I know (and it's absolutely possible I am wrong here), anyURI
should also cover something like "someprotocol:/some/absolutte/path".
So, there's nothing wrong with using an anyURI here, and no need for a
change. In fact, the existing pre-defined actions you can enter in the
UI are effectively implemented using an own URI scheme, and thus
perfectly legal. (Which doesn't touch the question of how sensible this
decision was, given that it effectively locks out other applications,
since this URI scheme isn't standardized in any way.)

Ciao
Frank

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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

[dba-dev] vacation notice

[Frank Schönheit - Sun Microsystems Germany]

Hi,

during the next three weeks, you won't read anything from me in this
list, as I'll be on vacation, and hardly be able to access the internet.

You probably won't be able to discern this phase from any other
three-week phase of silence of mine, but I thought I nonetheless mention
it ...

Have fun, but don't write too many issues and mails in this time, they
all add to the backlog I have to work off after the vacation :)

Ciao
Frank

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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] DisposedException - EOF reached

[Frank Schönheit - Sun Microsystems Germany]

Hi René,

> Yes, I already found out what IIRC meant. :-) I'm not of the sms
> generation!

I definitely do not belong into this generation either :)

> I indeed played with the code and during my 
> attempts removed registerObject. I believed it 
> was not so important where this was done

Correct.

> When I restore them BEFORE the 
> props.setPropertyValue (the original position), 
> then I get the errormessage: 
> IllegalArgumentException; the datasource was not 
> stored. Use the interface XStorable to store the 
> data source.

Ah, that's something I indeed wondered about, registering should not
succeed without the document being stored. So, the error you describe
here is completely correct.

> When I move the same lines AFTER the 
> props.setPropertyValue, then I get the earlier 
> DisposedException - closeConnection message.

Quite confusing.

Do you have a JAR or your modified sources you could send me (to the
sender address of this mail), so I cann have a look at this? Please no
fancy 3-pagers of how to set this up, something which runs out of the
box and hits the problem would be really nice :)

Ciao
Frank

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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] DisposedException - EOF reached

[Frank Schönheit - Sun Microsystems Germany]

Hi René,

> jurt.jar, ridl.jar and juh.jar are all stored in 
> the directory ...OpenOffice.org 3\URE\java, 
> nowhere else. unoil.jar is stored in 
> ...OpenOffice.org 3\Basis\program\classes 
> directory and nowhere else. I could not find 
> something that starts with IIRC (no idea what it is as well!).

Uhm, sorry, IIRC is an abbreviation for "If I remember correctly" :)

> All my code steps check for exception conditions, 
> but all the previous steps seem to succeed and to 
> return correct values. If the jars are ok, what 
> next can I check? It would be nice if I could use 
> a kind of trace to check what is going on behind 
> the scenes, but I believe that is not possible?

Sorry, I do not know at all whether tracing the Java UNO bridge is
possible (and I indeed think it's that bridge which causes problems here).

Sadly, I do not really have new ideas what could cause this, really the
only possible reason I know about is the incompatible jar files, but you
convincingly denied this.

Not sure if the code you're using is still the code you pointed to, or
if you already adjusted it. If the former, then please try moving the
"xServ.registerObject(..." line *after* the setPropertyValue. Would be
interesting to know whether the problem then still happens, and in which
line. I somehow suspect the DisposedException might be moved to the
*second* setPropertyValue then. In other words, I suspect that something
about the registerObject is killing your connection.

Ciao
Frank

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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] DisposedException - EOF reached

[Frank Schönheit - Sun Microsystems Germany]

Hi René,

> I'm trying to recode the sample known as 
> 'mailmerge code snippet' and found at 
> http://api.openoffice.org/source/browse/api/www/Examples/Snippets/Writer/Writer.MailMerge.snip?rev=1.1&view=markup.
> 
> I'm testing my code on a Windows Vista system 
> with OpenOffice 3.1 Dutch version. As soon as I'm 
> executing the method setPropertyValue with the 
> sdbc:flat , I get the exception 
> com.sun.star.lang.DisposedException . EOF 
> reached ..

If that "EOF reached" is a citation of your error message, then I'd say
that some previous API call killed the connection to your OOo instance:
"EOF reached", according to Grok
(http://svn.services.openoffice.org/opengrok/search?q=%22EOF+reached%22&defs=&refs=&path=&hist=&project=%2FOOO310_13),
comes from SocketConnection.java, which sounds as if you connected to a
running OOo via a socket (as opposed to a pipe), and this connection
somehow died.

> I understand I loose the connection with the server.

With "server", do you mean the OOo instance you connected to?

> But this server does not go down and keeps on running

If this refers to OOo ... this means (I assume) that on client side,
some UNO API call could not be translated properly. I do not know too
much about our UNO bridges which bridge API calls, but my assumption
would be that you're using incompatible .jar files, describing the UNO
API, on your client and server.

For instance, assume you have an interface XSomething, which has a
method doSomething, introduced in OOo 3.1. Now when you have an OOo 3.1
running, the UNO environment in this OOo process will know about this
interface and method.

Now assume that on your client, you use UNO jar files from OOo 3.0,
where this method does not yet exist (or has another signature, or
something like this). In this case, your client code will compile fine,
but at runtime, the UNO environment of your client will detect that a
call is made to a method which does not exist on "the other side of the
UNO bridge". The only reasonable reaction in such a situation would be
terminating the bridge, since a recovery is not possible at all (not
without potentially leaving your client in an undetermined state).

So, what I would check is whether the UNO jar files on your client and
server are the same. Those are, IIRC, unoil.jar, juh,jar, jurt,jar,
ridl.jar (might be more or less than those, not sure).

Ciao
Frank

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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] An API reference for calling the DB Record Search dialog functionality from client scripts?

[Frank Schönheit - Sun Microsystems Germany]

Hi Drew,

> I haven't begun looking for this - will be doing so tonight.
> If anyone has a direct link to where a good starting spot (assuming you 
> can make sense of my subject line) it would be very much appreciated.

exception dispatching the ".uno:RecSearch" URL into the frame where you
want to open the dialog, there's no API at all. Even with this solution
(which just mimics the user pressing the respective button), you cannot
control the dialog settings. Well, you probably could, by manipulating
the configuration settings
(/org.openoffice.Office.DataAccess/FormSearchOptions) the dialog is
initialized with. Ugly, but maybe doable.

Ciao
Frank

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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] OO database sort problem

[Frank Schönheit - Sun Microsystems Germany]

Hi Fernand,

> Do you mean I shuold file a issue and do the 'fs' thing :-)

:)
No, I fixed that while passing in a 3.2-targeted CWS (dba32e).

> BTW: "Reportedly, the Alpha version of the driver was able to connect to 
> a remote MySQL server in the internet, using the server's IP address. 
> The Beta version is not able to do this anymore, while, on the very same 
> machine, e.g. the Connector/J works fine for the very same server".
> 
> We had the same problem with the MySql  we installed on a XP machine 
> (for your testing), we could not get acces with the native connector, on 
> the other hand we have a same MySql running but now on a Windows 8000 
> server with no problem for the native connector
> So the difference could comming from not working on XP and well working 
> on Windows8000

I'll look into that, too, but that might touch MySQL code very deeply,
so I am not sure I can do anything before the MySQL-side of our C/OOo
team returns from vacation :-\

Ciao
Frank

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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] OO database sort problem

[Frank Schönheit - Sun Microsystems Germany]

> Could reproduce with the table dump you sent me, will put onto the
> "known problems" list for the connector, and investigate.

http://wiki.services.openoffice.org/wiki/Database/Drivers/MySQL_Native/Beta/Known_Issues#Standard_Filter_dialog_fails_to_set_a_column_filter:

"The bad news is: That's a bug in OOo itself, which is only triggered by
the way how the driver (legitimately) exposes its database/tables, so,
it cannot be fixed in the driver, but in OOo only."

Ciao
Frank

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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] OO database sort problem

[Frank Schönheit - Sun Microsystems Germany]

Hi Fernand,

>> For the first problem: Which database? 
> MySql native connector , the ODBC connector do not have this problem
> ODBC produce a  statementlike : SELECT * FROM `tbl_leveranciers` WHERE ( 
> `tbl_leveranciers`.`Uithangbord` = 'alphadent' )
> as you see without using the "schema name"

Could reproduce with the table dump you sent me, will put onto the
"known problems" list for the connector, and investigate.

However, seeing that this happens with the MySQL Connector/OOo, I doubt
this is what Robby originally referred to, so my question what he means
exactly remains.

Ciao
Frank

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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] OO database sort problem

[Frank Schönheit - Sun Microsystems Germany]

Hi Fernand,

>> For the first problem: Which database? 
> MySql native connector

Hmm, cannot reproduce. Can you give us a table dump (structure only is
sufficient)?

Thanks & Ciao
Frank

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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] OO database sort problem

[Frank Schönheit - Sun Microsystems Germany]

Hi Fernand,

> I suppose Robby is pointing to the use of the "filterering" who have a bug
> 
> when making a filter with the GUI OO produce SQL a statement like
> SELECT * FROM "pmgdbase"."tbl_leveranciers" WHERE ( 
> "pmgdbase.tbl_leveranciers"."Uithangbord" = 'alphadent' )
> This gives a error because "pmgdbase.tbl_leveranciers", must been 
> "pmgdbase"."tbl_leveranciers"
> Same behavior when using the filter in a form
> I filled already a related Issue 
> <http://qa.openoffice.org/issues/show_bug.cgi?id=102793> for it

Hmm, 102793 does not seem to describe the quoting problem from above,
sounds like two different problems.

102793 slipped my attention so far, will have a look.

For the first problem: Which database? Which driver? Does somebody know
an issue for this, too?

Thanks & Ciao
Frank

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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] How can I store the default values and column descriptions in odb file?

[Frank Schönheit - Sun Microsystems Germany]

Hi Michael,

> I would like to store default values and the column descriptions in the odb
> files as we do not fully support them in the database. Is it right that base
> can do this for us or must the driver implement the functionality to store
> the values in the odb files? I have neither an idea how to tell base to do
> this for me nor how to do it my self in the driver :(

The driver does not need to know about this at all.

Assuming that we talk about the ControlDefault as mentioned by Ocke (the
DefaultValue is effectively unused), this should work automatically: The
table design fills the property with what you enter there, the ODB
export filter retrieves and writes it.
Uhm, trying that with an embedded HSQLDB in OOo 3.1 it seems this isn't
the case ... need to verify that, but it seems that's a general problem
then.

For the description, the same holds: this shouldn't be a concern of your
driver at all, it should all be held in higher layers. (And here it even
worked for me with embedded HSQLDB.)

So, if with your driver, this is lost, I cannot really think of a
reason. However, the object hierarchy in dbaccess/source/core/api is
rather complex, and Ocke knows more about this than I do. Perhaps
depending on certain characteristics of your driver, the wrapper code
behaves differently/wrong.

I suggest you start debugging this in dbaccess/source/ui/tabledesign,
OTableEditorCtrl::SaveData. Check whether the description is properly
propagated there. Then, in TableController::alterColumns, check whether
the proper description is set as PROPERTY_HELPTEXT at the column, and,
more interesting, where this setPropertyValue call actually arrives -
which class implements this property? Compare this with
ODBExport::exportColumns in dbaccess/source/filter/xml: There's a
getPropertyValue( HELPTEXT ) call - where does it arrive, ultimately?
Which implementation provides this value?

(Compiling comphelper/source/property/* and
cppuhelper/source/propshlp.cxx with debug=1 might come handy, to be able
to step through all involved property set helper classes.)

Ciao
Frank

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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] OO database sort problem

[Frank Schönheit - Sun Microsystems Germany]

Hi Robby,

>   I have been an OO user for years and mostly love your package, however I 
> recently
> ran up against the sort bug in OO 3.1.0 Base.

Excuse my ignorance, but what exactly is "the sort bug in OO 3.1.0 Base"?

Thanks & Ciao
Frank

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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] sun-report-builder-alpha-1.1.1.m49 and DEV300m50

[Frank Schönheit - Sun Microsystems Germany]

Hi Zoltán,

> I tried the SRB alpha 1.1.1 from qa-upload with m50, and found unusable 
> on report wizard.
> Creates empty report in m50, but works correctly in m49.
> When click to second steps (labels) SRB hang, if I click on next 3 times 
> after ~40s suddenly go to step 5.
> When I click on finish, creates empty report, with bot option (create or 
> edit).

Without investigating this: m50 had a P1 (102701) which can manifest in
a lot of different ways. Basically every feature which uses OOo's
storage format for writing files can be affected - and creating reports
(by wizard or manually) falls into this category.

So, I would recommend wiping m50 from your disc completely, and waiting
for m51.

Ciao
Frank


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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] OpenOffice accessing Access 2007 database under Vista SP2

[Frank Schönheit - Sun Microsystems Germany]

Hi Rob,

> I wonder if you can help me. I am trying to read an Access 2007 database 
> from OpenOffice 3.1 on a computer running MS Windows Vista SP2
> 
> I am getting an error "The connection to the data source  could not 
> be established. Function sequence error"

Unfortunately, "Function sequence error" is some generic error message
which barely tells anything, except that the driver is not in the state
it expected to be.

If you have sample .accdb and .odb files, and submit an issue, attaching
those files, we can investigate the problem.


> I have researched the internet to find that I need to install "2007 
> Office System Driver: Data Connectivity Components" from 
> http://www.microsoft.com/downloads/details.aspx?familyid=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en

(If you hadn't installed those, you should have got another error
message. Hmm.)

Ciao
Frank

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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] Table wizard quirks OOo dev 3.2 m47 (partof SRB for ...)

[Frank Schönheit - Sun Microsystems Germany]

Hi Zoltan,

for the record:

> On linux m47 still installed, submitted issue:
> http://www.openoffice.org/issues/show_bug.cgi?id=102450

meanwhile resolved as duplicate of issue 102436 (as you can see from the
number, this is pretty recent, too). Thanks a lot for submitting the
issue, even though we found out it's a duplicate - using your files in a
debug build of OOo tremendously helped to prove that's a duplicate of
the above issue.

Thanks & Ciao
Frank

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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] Table wizard quirks OOo dev 3.2 m47 (partof SRB for ...)

[Frank Schönheit - Sun Microsystems Germany]

Hi Zoltán,

>  From my earlier mail:
>  >1. in table wizard, the personal and bussiness categories content 
> changed with each other,  you can find for >example CD-Collection in 
> bussiness category. (in both win/linux)
> 
> I logged out stated new session on linux, same error.

Meanwhile known as issue 102019.

>  >2. form wizard when you finished creation, with option work with the 
> form, window closes and not opens >back, and not saves into Form area - 
> Form lost. (On linux version caused OOo crash) If you select edit >mode, 
> the form opens in edit mode and saves into Form area. (On linux/rpm 
> version caused OOo crash)
> 
> In this part I made some more observation, it is only happens when 
> creates new table with wizard as in first step. If you create table in 
> design mode forms works as needed.

Hmm, cannot reproduce. Creating a ¨Assets¨ table with the table wizard,
and subsequently letting the wizard create a form for the table (where
the form wizard is started by the table wizard, by checking the proper
option on the last page of the table wizard), using all default options
of both wizards, works like a charm here.

> If you creates tables with wizard, and after form with wizard, form 
> cause crash on linux, on win not crate form.
> It is independent from file creation, it is happens with newly created 
> file or with old file.
> Crash reports: rvpfwvc and r5pfwvc.

Those reports indicate that the crash happens while the generated form
document is being loaded. Could you please try the following:
Repeat what you did, and at the very moment OOo crashs (and the crash
reporter dialog is still open): check your /tmp path for the most recent
files. Most probably, you'll find a document named similar to the form
you just created. Try copying this file to another location, before
closing the dialog in OOo. Then, when OOo restarts, try opening the file
- if this crashes, too, then you could send me the file (or submit an
issue for it yourself).

Thanks & Ciao
Frank

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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] 2 Strings appearing in English in Base UI

[Frank Schönheit - Sun Microsystems Germany]

Hi Arthur,

>> Perhaps next time I do such a nasty thing, I will hard-wire the French
>> and German translations in the code. All other NL communities either
>> never notice, or never complain :)
> 
> How many languages are you willing to hardwire?

Do I need - let me guess - Dutch, too? Hmm, this is getting out of
control ...

;)

Ciao
Frank


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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] 2 Strings appearing in English in Base UI

[Frank Schönheit - Sun Microsystems Germany]

Hi Zoltán,

>> I usually ignore all non-English bugs :)
>>   
> It is in reality, it was not true with OOo 3.0 HU langpack bugs :-)

I just wanted to say that issues *written* in a language other than
English are usually not handled, simply since we cannot learn that many
other languages.

>> Perhaps next time I do such a nasty thing, I will hard-wire the French
>> and German translations in the code. All other NL communities either
>> never notice, or never complain :)
> We will complain through dozens of issues. ;)

Uh, well, yes, I need to hardwire Hungarian, too ;)

Ciao
Frank

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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] 2 Strings appearing in English in Base UI

[Frank Schönheit - Sun Microsystems Germany]

Hi Sophie,

>> For the background: Those strings were added after the localization
>> freeze, but I wanted to have the feature in, so I decided we can go
>> without a localization for 3.1. But don't tell anybody ;)
> 
> I promise that the next bug dedicated to you will be written in this
> language : Ningalkku njan paranjathu manasilakunnille? ;-)

I usually ignore all non-English bugs :)

Perhaps next time I do such a nasty thing, I will hard-wire the French
and German translations in the code. All other NL communities either
never notice, or never complain :)

Ciao
Frank

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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] 2 Strings appearing in English in Base UI

[Frank Schönheit - Sun Microsystems Germany]

Hi Sophie,

> In Base, under Tools > Customize > Events, there is 2 strings appearing
> in English in my FR version :
> Loaded a sub component
> Closed a sub component
> 
> Would it be possible that they have forgot to join our l10n files? ;-) I
> can't find them any where, those strings are also not documented in the
> OLH. Do I open the bug for Database or for Framework ?

Let's get without a bug this time, I just fixed that.

For the background: Those strings were added after the localization
freeze, but I wanted to have the feature in, so I decided we can go
without a localization for 3.1. But don't tell anybody ;)

Ciao
Frank

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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] Some issues on 3.1.0 with macros

[Frank Schönheit - Sun Microsystems Germany]

Hi Ariel,

> --
> 
> * Create a new database document (menu File - New - Database)
> * Create a new macro (menu Tools - Marcos - Organize macros - OOo Basic, then 
> select the ODB, and press the New button)
> * Write a dummy macro
> * try to execute it
> 
> You get a macro warning (I my case I set security to "Medium" level).

Now known as issue 102139.

> css::container::XHierarchicalNameAccess::getByHierarchicalName() does not work
> 
> * create two forms:
>   "Form1"
>   "Folder1/Form1"
> 
> * The following (also attached, may it passes to the mailing list) opens 
> Form1 
> when trying to open Folder1/Form1

Cannot reproduce. OOO310.m11, WinXP. Hmm, admittedly StarOffice instead
of OpenOffice.org, but I doubt this makes a difference.

> -
> css::sdb::XSubDocument::open() does not work when the subdocument has no form 
> at all (this happens on OOO310_m11 but not in DEV300_m47):

Cannot reproduce, too.

Which platform? Sure you used m11 and not some intermediate version?

Ciao
Frank

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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] Datasource - specs - Evolution

[Frank Schönheit - Sun Microsystems Germany]

Hi Cor,

> Issue http://qa.openoffice.org/issues/show_bug.cgi?id=83592 for 3.1 
> linked to this specs:
> http://dba.openoffice.org/specifications/Data_Source_Property_Dialog.sxw
> 
> Seems rather old UI-stuff to me (compared to the current 
> File-New-Database Wizard).

No, it's the - still valid - spec of the dialogs under the Edit/Database
sub menu. (Well, probably you'll find the one or other minor item which
has been superseded by reality meanwhile.)

> But more interesting: I saw a note about Evolution, in "4.4 The 
> Connection Type wizard" . I guess that is old info as well... (see issue 
> 67600). Is implementing a bunch of work?

The Evolution section is up-to-date as well, but the Evolution driver is
available for Linux only.

Issue 67600 requests access to Groupwise on Windows, which is a
completely different story.

Since the Groupwise AB is claimed to be accessible via MAPI, I would
have assumed it works out-of-the-box with the "Windows Address Book"
database type, which is for this purpose (accessing the AB which is
exposed via MAPI). So, speaking strictly, that's probably not an
ENHANCEMENT, but a DEFECT.
I cannot really judge the effort for fixing this. Given that the real
MAPI-access code is in Mozilla (OOo ships with a few Mozilla libs
implementing this), it might turn out difficult. Also, when we ever
touch this area, I'd rather go the way of removing the dependency from
Mozilla code (which causes constant problems for various reasons), and
implement an own MAPI SDBC driver, which probably wouldn't make it
easier ...

Ciao
Frank

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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] issue with a variable in localization of querydesign

[Frank Schönheit - Sun Microsystems Germany]

Hi Andre,

>>> or 'SQL statement'. But in French (and I'm sure other languages), this
>>> is not possible to apply this variable to SQL statement in the same way,
>>> the article at the begining is not the same as for the others.
>> Uhm. Given that all we Base developers are native German speakers, and
>> in German, there is the very same problem, this should not have happened
>> at all ...
> 
> Well .. it's quite easy for German translation: you don't have to use
> an article (not very nice wording but works).

Well, yes. I just wanted to say that the author of this string should
and could have anticipated the problem, and prevent both your workaround
and Sophie's impossibility of a workaround by just doing it right in the
beginning.

Ciao
Frank


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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] issue with a variable in localization of querydesign

[Frank Schönheit - Sun Microsystems Germany]

Hi Sophie,

> I've an issue with localisation and I don't know if I need to report it
> against dba or not.
> 
> In fact, this string :
> #: query.src#STR_QUERY_SAVEMODIFIED.string.text
> msgid ""
> "The $object$ has been changed.\n"
> "Do you want to save the changes?"
> 
> has a variable $object$ that should be replaced by 'table view', 'query'
> or 'SQL statement'. But in French (and I'm sure other languages), this
> is not possible to apply this variable to SQL statement in the same way,
> the article at the begining is not the same as for the others.

Uhm. Given that all we Base developers are native German speakers, and
in German, there is the very same problem, this should not have happened
at all ...

Please submit an issue, assign it to me, and give it a target of 3.x.

Ciao
Frank

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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] Open database document from beamer - Bad Beamer.

[Frank Schönheit - Sun Microsystems Germany]

Hi Fernand,

> Can I suppose that 100764 
> <http://qa.openoffice.org/issues/show_bug.cgi?id=100764> is a duplicate 
> and is also been fixed now ?

Uhm, no, this sounds like a completely different issue to me, of which I
wasn't aware so far. Will have to investigate.

Ciao
Frank

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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] Open database document from beamer - Bad Beamer.

[Frank Schönheit - Sun Microsystems Germany]

Hi Drew,

> Yes, it is the same with Linux.
> 
> http://www.openoffice.org/issues/show_bug.cgi?id=100956

Thanks for finding and reporting this. Interesting bug, from a technical
point of view :). Fixed. For 3.1, hopefully.

Ciao
Frank

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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] Open database document from beamer - Bad Beamer.

[Frank Schönheit - Sun Microsystems Germany]

HI Drew,

> It appears that when a database document is opened for editing via the 
> Beamer macro execution is disabled.

Cannot reproduce: Let the wizard create a new DB doc, leave the
"register as data source" checked, in the DB doc, create a new
lib/module via Tools/Macros/Organize/Basic, save the doc, close the doc.
Open a text doc, open beamer, choose "Edit database file" in the context
menu of the data source => I'm presented with a "Do you want to execute"
question.
(Security level is set to "Medium".)

What is it you do differently?

Ciao
Frank

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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] i99686 and srb 1.1.0 Beta

[Frank Schönheit - Sun Microsystems Germany]

Hi Zoltán,

> I tried to check issue 99686 
> (http://qa.openoffice.org/issues/show_bug.cgi?id=99686), issued by me, 
> in DEV310m7,
> and it failed to show pictures in report.
> I used SRB 1.1.0.beta (2009.03.09, from qa upload server),  it raised  
> question, I need to use another version?

The fix for issue 99686 was (at least in parts) in the extension, so the
"old" beta does not contain it.

I uploaded a new version (Beta 2) to
ftp://qa-upload.services.openoffice.org/SRB, however did not try it, yet.

Ciao
Frank


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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] Need i-team for specification [was [dba-dev] New Filter Dialog]

[Frank Schönheit - Sun Microsystems Germany]

Hi Karl,

> I have used OpenOffice.org Software Specification Template and thus I have a 
> Writer document.
> 
> There is the specification wiki that says one should put the spec (even if 
> preliminary) online on http://specs.openoffice.org... but how do I? On this 
> page I cannot find any hint.

Sigh ... one reason I prefer the Wiki ...

You need CVS access to the ¨specs¨ project. Since I cannot grant you
this, and I am not even sure the project is still alive ... I could
offer you CVS access to the DBA project, so you can commit your spec
(still using CVS) to http://dba.openoffice.org/specifications/index.html.

Ciao
Frank


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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] Need i-team for specification [was [dba-dev] New Filter Dialog]

[Frank Schönheit - Sun Microsystems Germany]

Hi Karl,

> There does not seem to be much interest in ux and qa... :-(

As Liz said, it might indeed be possible that especially UX is on the
Cebit ...

> I have finished a first version of a specification. Lots of details are still 
> missing. I didn't pay, for example, any attention to accessibility yet.
> 
> However, the first version has enough content (23 pages) to see how I think 
> the new filter dialogue could -- and should -- work. Before I continue, I 
> would like to get some feedback. Maybe my ideas are in complete disagreement 
> with the expectations of the community.
> 
> So how should we proceed? Shall I stop and move the first version to 
> /dev/null 
> since I do not have a complete i-team, or should I upload it somewhere and 
> wait for being bashed?  ;-) 

The latter :)

> In case you suggest the latter, how and where should this version of the spec 
> be announced?

Did you do this as Writer doc, or do you plan to do it in the Wiki? In
the first case, you should find a place.

For announcements, annou...@specs.openoffice.org is the ... intended
place, though ... I've rarely seen anybody using it, so I in fact
suggest to do the announcement in us...@dba and disc...@ux (though
feedback/discussion should happen in one list only, us...@dba preferrably).

> Anyway, I think I should stop now and wait for feedback. 

Thanks & Ciao
Frank

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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] Need i-team for specification [was [dba-dev] New Filter Dialog]

[Frank Schönheit - Sun Microsystems Germany]

Hi Karl,

> So please read on, as I need a member of dev, ux and qa.

I might not have all the necessary time, but if nobody else volunteers
for the dev part, then count me in. (But be warned that I seldom can
resist giving UX-related comments :)

>>> On [2] I found some other things that need to be done/checked before I
>>> start:
>> In general, do not impose too much meaning into those requirements (but
>> don't cite me on that :).

Ts. Didn't I say "don't cite me on that"? :)

Ciao
Frank

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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] Macro Migration Remarks

[Frank Schönheit - Sun Microsystems Germany]

Hi Fernand,

> I did the migration from 2.4 to 3.1 (latest snapshot m3)off a complex 
> db-doc with 2 forms containing several libraries with soem dialogs in it.
> Everyting went extremly well :-)

Fine :)

> well execpted  The names of the 
> libraries are changed to a combination off the original librarie name 
> and the name off the form. This renaming, however, is not done in the 
> basic code lines like loading dialoglibraries  the load point still to 
> the original dialoglibrary.
> The renaming is also not done in the basicdialog-control-events who stay 
> pointed to the original macro ibrary names
> 
> Do not know if this is a wanted behaviour or I should make a issue off it ?

http://wiki.services.openoffice.org/wiki/Macros_in_Database_Documents#Migrate

Adjusting the names in the Basic code is up to impossible (when we want
to do it correctly, without replacing the wrong tokens), without
actually running the macro in a sandbox, thus it was not implemented.

The dialog events - uhm, as the specification proves, those have been
*completely* forgotten. Shame on me! (and the reviewers of the spec :)

So, please write an issue for the latter - ideally with a sample
document, as always.

Thanks & Ciao
Frank

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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] Need i-team for specification [was [dba-dev] New Filter Dialog]

[Frank Schönheit - Sun Microsystems Germany]

Hi Max,

>> [1] http://dba.openoffice.org/development/projects.html#new_filter
> 
> @FS: there is syntax highlighting still on that page, would you remove 
> it, please?

Done. Thanks for the reminder.

Ciao
Frank

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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] Form > Tablecontrol event: how to obtain column, row and other information

[Frank Schönheit - Sun Microsystems Germany]

Hi Karl,

> (1) Was the mouse pressed in a particular cell, and if so, which one?
> 
> (2) Was the mouse pressed on a column header, and if so, which column?
> 
> (3) Was the mouse pressed on a row marker, and if so, which row?
> 
> (4) Was the mouse pressed outside of header, row markers and cells?
> 
> (5) How can I find out, which rows are selected, if any?

In general, the current column position can be obtained via
http://api.openoffice.org/docs/common/ref/com/sun/star/form/XGrid.html#getCurrentColumnPosition
(at the Source member of the event you got). I am not sure, however,
whether this is updated *before* or *after* your listener is called,
i.e. if it still returns the old column.

The selection, as said by Fernand, can be obtained using the
getSelection method (or the Selection property, which is the same in Basic).

The current row cannot be obtained, though perhaps implicitly be
determined by the current row of the form.

Probably the safest way for the concrete row would be taking the pixel
position of the mouse, and calculating the affected cell, taking into
account the header and row height. However, this probably requires
translating the heights from logical units into pixels, which requires
the XUnitConversion interface, which is available in 3.1 only.

This approach might even work for the concrete column, by calculating
with the column widths. However, I am not sure at the moment the width
of the row header is available at the grid control model ...

All in all, there's pretty much uncertainty in here, so I think fixing
the issue with the grid column events might be ... safer. Though,
column-related events won't solve the problem of obtaining the current
row ...

> (6) When I press the right mouse button in a cell or on a column header, a 
> pop-up menu appears. Can I add my own menu items to these menus, and if so, 
> how?

No, that's not possible.

Ciao
Frank

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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] New Filter Dialog

[Frank Schönheit - Sun Microsystems Germany]

 QA.

Having more user ex members ("more" because I assume that you have a
certain user ex affinity, else you wouldn't offer to write a spec) is
always a good thing. Again, asking is what gives you answers/volunteers.
 disc...@ux is a good place. I of course could recommend Chris Lukasiak
to you, who happened to take the UX role in the Base team after our
previous UX expert left for other tasks.

Personally, I am immodest enough to offer my help in the Dev as well as
UX area, though I fear I haven't as much time to spend for the project
as I would like to have.

> --Q4 [i-Team Agreement]:
> --Do all i-Team members agree on Q1 - Q3? 
> 
> Well, first I need these three people...
> 
> --What happens if I can't answer all questions mentioned above, with Yes?
> --The consequence could be that your valuable work won't be integrated 
> --into OpenOffice.org. 
> 
> So, at the moment I should better not start or should I?

You should.

I consider a specification a very good means to plan a feature, to stay
in contact with the stakeholders (which is very important, see above),
to ensure that all the time all of them see the same big picture ... I
do *not* consider a specification and end in itself, as I do not
consider the Qs an end in themselves - if you can reach what they (the
Qs, and on a higher level the spec itself) want to ensure by other
means, then Just Do It (TM).

> Although it might 
> not be necessary to meet all these requirements as long as only the spec is 
> going to be written, it would be a good idea to involve at least a User 
> Experience member.

Yes.

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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] Which version of SRB use with DEV300m2?

[Frank Schönheit]

Hi Zoltán,

> It's normal, my question was non clear.  I  tried to usa all my SRB's 
> and downloaded m1 version from Pavel's build, and no working version.
> cannot start any report from m2 as were in earlier last 5 developer version.
> I searched and I found that issue 98549 fixed and fix cws  integrated 
> and found that this was not fully real, reports not working from m2.

The fix for issue 98549 did not make it into m2, and I still have to
find out whether this is SubVersion's fault, or a mistake of release
engineering. Just to know who to shoot ...

Ciao
Frank

PS: Technically, the fix was part of a file which meanwhile had been
renamed in the main trunk, and SVN and file renamings aren't really good
friends ...

-- 
Frank Schönheit StarOffice/OpenOffice.org Base
frank.schoenh...@sun.com+49 40 23 646 663 / +3
Sun Microsystems Germany Hamburg, Nagelsweg 55
--

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] Poll mailing list working?

[Frank Schönheit - Sun Microsystems Germany]

Hi Regina,

> are you sure, it works now?

There's rarely something I am sure about in collab.net's infrastructure.

There's at least one message (except my test messages, which I deleted
from the archive to not clutter it) by now:
http://dba.openoffice.org/servlets/BrowseList?listName=poll&by=date&from=2009-02-01&to=2009-02-28&first=1&count=1.

Sigh. Care to re-send your mail?

Ciao
Frank

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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] About hiding the new interface XRecovery for FormDocument

[Frank Schönheit - Sun Microsystems Germany]

Hi Yan,

just yesterday Andreas explained the concept to me, again :)

In my previous answers, I assumed that the recovery service would
iterate over all documents registered at the desktop, and use their
XRecovery interface. However, as Andreas reminded me, the plan is that
the recovery services is just a listener at the GlobalEventBroadcaster,
and iterates over all documents known there.

In this case, it is in fact necessary to hide the XRecovery interface
for embedded documents, so please go ahead with this change.


>> So, the save-code in Base would look like
>>   - create a wrapper storage
>>   - save my own content
>>   - create a sub storage for every opened form
>>   - use the form's XRecovery to save it into the sub storage
>>
>> So, the bottom line is: When you remove the XRecovery from embedded
>> forms, this will make final implementations more difficult.
>>
> Does it mean making database document store it's own sub documents is 
> difficult?

No, I just meant that at some point in its own emergency save process,
the form document needs to emergency-save a certain sub document. If
this document had the XRecocery interface, this would be just a matter
of delegating to this interface.

Now when the sub document does not have this interface, then the form
document needs to decide itself what "emergency save" means for the sub
document. At the moment, this decision is still easy: It's just a simple
"XStorage::storeTo" call.

However, there might be points in the future where the implementation of
XRecovery::store (or however you named it) for text documents is
*extended* to be more than a simple "storeTo". In such a case, we would
need to duplicate this extended semantics in form documents, too. In
case XRecovery were still present at the sub documents, this duplicate
would not be necessary.

That said, I am still a little bit unsure whether hiding the XRecovery
interface is the most future-proof solution, but I think you can go
ahead with it.

Ciao
Frank


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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] Poll mailing list working?

[Frank Schönheit - Sun Microsystems Germany]

Hello Zoltán,

> On GullFOSS post: http://blogs.sun.com/GullFOSS/entry/if_you_had_3_wishes
> you warned us to send our votes on features, and that we will see all 
> poll mail in p...@dba mailing list.
> The mailing page shows 0=zero mails, but must show at least one, what I 
> sent to it.
> Some thing wrong happened with that mailing list?

Argh! Did I ever mention I hate collab.net's infrastructure?

I chose "discuss" as mailing list type (unnecessary to mention I was
unable to find an explanation of the mailing list types), and obviously
this means that only mails from subscribers are sent to the list. Which
explains that the list is still empty, though my own test mails made it
through :-\

I fear I will have to publicly ask to resend all the voting mails :(
Quite embarrassing.

Thanks for pointing that out.

Ciao
Frank

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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] About hiding the new interface XRecovery for FormDocument

[Frank Schönheit - Sun Microsystems Germany]

Hello Yan,

> A new interface com.sun.star.frame.XRecovery is being designed. It will 
> be used by the autorecovery service inside the framework module and 
> supported by all applications. FormDocument of database, which is not 
> used as a top level document, will ignore the new interface.
> Currently, ODatabaseDocument can inherit XRecovery and implement its 
> method load/save. I want to pass some parameters, which can disable the 
> interface XRecovery, to the sw::ctor() when creating a new FormDocument. 
> I tried to do this in the ODocumentDefinition::loadEmbeddedObject(...) 
> but found no good way. How can I pass some parameters to the sw::ctor() 
> when creating a new FormDocument in database?

There already is a mechanism for passing parameters to the document
implementation, to disable certain functionality.

For instance, for the documents embedded in a database document, we
disable the usage of XEmbeddedScripts.

For this, we pass a parameter "EmbeddedScriptSupport" when creating the
document, see
http://svn.services.openoffice.org/opengrok/search?q=EmbeddedScriptSupport&defs=&refs=&path=&hist=&project=%2FDEV300_m40.

In SFX, this creation parameter is translated into the
SFXMODEL_DISABLE_EMBEDDED_SCRIPTS flag, which is passed to the document
factory:
http://svn.services.openoffice.org/opengrok/xref/DEV300_m40/sfx2/source/doc/sfxmodelfactory.cxx#176

Then, the factories for the various document types examine the presence
of this flag
(http://svn.services.openoffice.org/opengrok/s?refs=SFXMODEL_DISABLE_EMBEDDED_SCRIPTS&project=/DEV300_m40),
and translate it into a call to SfxObjectShell::SetHasNoBasic:
http://svn.services.openoffice.org/opengrok/xref/DEV300_m40/sw/source/ui/app/docshini.cxx#401

This, finally, instructs the SfxBaseModel belonging to the
SfxObjectShell to *not* expose the XEmbeddedScripts interface.


However, let me ask an important question: Why do you really want to
disable this interface?

First, it should not hurt if it is present: The auto recovery process
iterates over all documents which are known at the desktop, and "sub
documents" of a database document are explicitly *not* known at the desktop.

Second, the non-presence of this interface would make the implementation
in Base harder: To properly implement a emergency-save and auto-recovery
for Base documents, we also need to emergency-save and auto-recover the
sub documents.
For instance, when you have a database document and one form open, and
OOo crashes, then Base needs to save both the database document, *and*
the form. The latter is done easiest, if course, if it can be delegated
to the form itself.
So, the save-code in Base would look like
  - create a wrapper storage
  - save my own content
  - create a sub storage for every opened form
  - use the form's XRecovery to save it into the sub storage

So, the bottom line is: When you remove the XRecovery from embedded
forms, this will make final implementations more difficult.

Ciao
Frank

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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] MWS builds and SRB development

[Frank Schönheit - Sun Microsystems Germany]

Hi Zoltán,

> It is a possible to attach to any MWS, versions of SRB which allows new 
> features supported in main code, same way as dictionaries installed with 
> OOo?

bundling extensions with the OOo distribution is technically easily
possible, but a political issue. People need to decide and *agree* to
which extension is/not bundled, and this seems to be a difficult process.

Reporting is, in my opinion, an integral part of a database application,
so you ask me, SRB should be an integral part of Base (not even in the
form of an extension).

I took the opportunity to start, again, a discussion about integrating
SRB into Base - something I'd really like to see happening, as it would
significantly lower the efforts around SRB (e.g. testing different SRB
versions for compatibility with different OOo versions).

Let's see.

Ciao
Frank

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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] Macro migration wizard in m41

[Frank Schönheit - Sun Microsystems Germany]

Hi Peter,

> after migrating the macros from a form to the document (which seems to 
> end successfully), the macro organize dialog neither lists the document 
> nor a opened form.
> Don't know, if this is a base issue.

It is. This problem came in with m38, where two DBA-CWSes were
integrated, and a conflict was resolved improperly. The issue is fixed
in both dba31g (integrated into m1) and dba31h (will be integrated into
m2), so probably also in m42.

Thanks for catching this!

Ciao
Frank

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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] Feature pool

[Frank Schönheit]

Hi Peter,

> just a little reminder for the unconfirmed issue 
> http://qa.openoffice.org/issues/show_bug.cgi?id=66593
> (alignment property for numeric controls)

try the latest developer snapshots :)

Ciao
Frank

PS: submitting issues directly to me, in state UNCONFIRMED, has a high
chance of losing them ... leaving the owner blank, so they get assigned
to dbaneedsconfirm, is much better.

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] Events on Form TableControl-elements not working

[Frank Schönheit - Sun Microsystems Germany]

Hi Fernand,

> I tried to put a Mouse Click event on a Textfield (column) in a 
> TableControl ioff aForm. The event is ignored and the macro on the event 
> is not called
> Puting the Mouse Click Event on the TableControl itself works properly
> For the moment I found a work around using  the properties of the row 
> who is selected by the mouse click. Is this normal behaviour or do I mis 
> something?

Neither nor. I'd call it a bug. (Knowing the internals, I suppose this
never worked.)

Ciao
Frank

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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] Developer offers help in PDF Form export

[Frank Schönheit - Sun Microsystems Germany]

Hi Zoltán,

> One company offering help in PDF export, on community forum:
> http://user.services.openoffice.org/en/forum/viewtopic.php?f=53&t=14899
> As I know, you are the developer of Forms in OOo.

I answered in the forum, thanks for the pointer.

Ciao
Frank

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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] OOo Base 3.1 New Features wiki page

[Frank Schönheit - Sun Microsystems Germany]

Hi Zoltán,

> I compiled a wikipage from features mailing list mails, and some cases 
> from requirement documents.

that's great - next time somebody asks me what's new in 3.1's Base, I
know where to direct him to! Thank you very much!

Ciao
Frank

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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] DEV300_m39 breaks in evoab2 NResultSetMetaData.cxx

[Frank Schönheit - Sun Microsystems Germany]

Hi Ariel,

> DEV300_m39 breaks in connectivity/source/drivers/evoab2
> ...

if you're not aware of an issue for this - please submit one. This could
be fixed as master fix (i.e. directly for m40, not in a CWS).

Ciao
Frank

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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] How to keep users away from Tabels ?

[Frank Schönheit - Sun Microsystems Germany]

Hi Drew,

> The functionality supplied with issue 97889 is available in the current
> development build of OO.o 3.1 (DEV300_m37 with m39 do out in a few days
> according to an email in lists today's),

no, the fix for this was committed to dba31h, which is not yet
integrated, so there's no dev snapshot containing this functionality.

> For an example of setting an event listener using OOBasic

The issue is fixed in a way that Tools/Customize/Events contains two new
entries, which you can simply bind a macro to. No need to do the binding
programmatically.

Ciao
Frank

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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] How to keep users away from Tabels ?

[Frank Schönheit - Sun Microsystems Germany]

Hi Fernand,

> "CWS dba31h" any idea when i will be available for us ?

it's one of our last CWS' towards 3.1, its timeline depends on the
frequency of new 3.1 bugs coming in (the more 3.1 bugs, the earlier
dba31h will be full - but please don't feel tempted :)

Ciao
Frank

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

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org