Hi Ariel,
Concerning your OOo Basic dream, reading
http://extensions.openoffice.org/servlets/ReadMsg?list=devmsgNo=1062
it seems that is
impossible but just because core developers, when adding new features
are not very concerned to make them accessible from starbasic. IMHO it's
Hi Marc,
Hi Marc,
N'Abend,
00:37? G'te Nacht :)
Now that you mention it ... it would probably be peanuts to implement
the behavior you describe (it wasn't before, since in the course of
writing the wrapper, I reworked to wizard to allow sources which are not
in a .odb, which is a
Hi Marc,
Dragging .dbf .. no it was .DBF or .csv onto a base docs table win
doesn't already, but I assume this is a question of configuration. For
me (on win98se I must admit =:) it still starts a calc window.
Hmm, this never was the goal :). The goal was a UNO wrapper around the
copy table
Hi Marc,
Playing aroung with a .odb using internal hsql that has grown to a bit
more than 12MB on disk it starts to get a little slow. Especially
closing items (forms, tables, queries) takes some time, although the
underlying table is rather small in size.
Closing those sub-documents flushes
Hi Marc,
An idea here could be to re-package the .odb using the database part as
a single item with compression -0, but I think zip doesn't support this.
It does. The meta information in all of OOo's document is uncompressed,
for quicker access. However, still the complete package has to be
Hi Marc,
Unfortunately not. This would be the only change which *really* allows
to address a number of performance issues with the embedded HSQLDB.
Amongst others, closing data views or forms becomes unacceptably slow
(IMO) if the .odb exceeds a certain (relatively small) size limit. Also,
Hi Marc,
And since ODF dictates this approach it is implicitly excluding high
performance on bigger data volumes.
As long as ODF insists on ZIP as container format, and as long as we're
talking about frequent small writes: yes.
An idea here could be to re-package the .odb using the
Hi Mechtilde,
The OOo-maintainer removed the driver from OOo.
That's good to know. As much as I regret that there is no possibility to
access MSA databases on Linux, I think using the alpha driver was never
a good idea.
(Also, /me thinks the distros should sponsor some developers to finalize
Hi Marc,
Wouldn't it be pretty easy in terms of workload to only add a menu item
import table or adding a document type .dbf to the open dialog in
base? This way the *existing* table import wizard could be triggered.
Okay, I don't know if it would be doable for server databases and if the
Hi Mathias,
If i use a document (e. g. *.odt) as container of a form, i can set a
*.odb directly as datasource. But the path is always absolute. I wish,
it could be relative, how other stored URLs.
Is this a bug or a missing feature?
'Cause there's no specification (AFAIK) for the store
Hi Marc,
Well, the field formatting requires exactly that the value is displayed
in the respective control/field, and then compared with the search term.
The original intention was to allow searching for substrings in such
fields, which is up to impossible when you don't apply the same
Hi Marc,
Hm, I didn't think about views or keyless queries here ... how does
the current implementation work, maybe tuning the client side search
algorithm or changing the view update policy (only every 10th or 100th
value) could help a lot?
Well, the field formatting requires exactly that
Hi Peter,
your mail in [EMAIL PROTECTED] is still marked as TODO in my mail folder, sorry
for not answering for this long time.
after 30 min of inactivity with a form the connection to a
jdbc-datasource has been closed automatically (don't know if base or the
driver is guilty here ;) ).
To
Hello Peter,
the wide variety of answers here show that the concepts are clearly too
... complex.
in a form which is connected to a server db I filled some text fields
with api.
The content of these fields are not saved by clicking the Save
record-button. Only typing or pasting seems to
Hi Peter,
the following error occurs, if I save a table created with the designer:
ORA-00906: left parenthesis missing
I get the same hint, if I drag a HSQL table structure into an oracle
jdbc db.
I suppose this is something about the driver returning wrong meta data.
OOo asks the
Hi Ocke, Hi André,
When should I use a Mutex in my functions?
This question is discussed very often. :-) The best way is to use it in
every* method which is public available.
That's a good level-0-approximation, but not really correct :)
Talking about multi-threading concepts would
Hi Rado,
I've been working with 2.0.2 for a while now and just upgraded to 2.0.3.
After upgrading my scripts don't work any longer.
...
I can reproduce this with a MySQL/ODBC database. Do you mind submitting
an issue for this, so we can fix this regression it ASAP?
Thanks Ciao
Frank
(and
Hi André,
sorry for the delay, missed yur mail completely yesterday ...
| - If this doesn't work ... hmm. Debug into
| dbaccess/source/ui/misc/dsntypes.cxx, in particular
| initUserDriverTypes, and see whether your driver is listed there. If
| not, your DataAccess.xcu is wrong. If yes,
Hi Christian,
I would like to contribute to the OOo development process.
Let me join Ocke in giving you a Welcome :)
I've picked out the Joins in dBase queries project, as I like
parsers and know dBase dialects quite well. My problem is the lack of
time, so don't expect to get results very
Hi Éric,
OK, I analysed the other drivers a bit more :
- only two drivers declare they offer the sdbcx.Column service (hsqldb and
mysql)
- there seems to be a Column class in only four drivers (ado, hsqldb, mozab,
and mysql)
- many drivers instantiate a sdbcx::OColumn (calc, dbase, evoab,
Hi Éric
I see. Okay, in database terminology this means that your database meta
data should return |false| form othersFooAreVisible methods ...
I have checked, yes, they do all return sal_False. I suppose they would need
to return sal_True once the concurrency is handled better?
Yes.
Hi Alex,
Just on the off-chance here, because I don't know what is going on, but
this wouldn't have anything to do with OOo getting the letter D confused
as an instruction for date fields ?
Yes, it is. D is a keyword, since it's used for the {D ...} date
notation. Unfortunately, OOo's parser
Hi Marc,
Very nice, and the best thing is this service is published at the
API. :)
Hey, of course, what did you expect? ;)
Ciao
Frank
--
- Frank Schönheit, Software Engineer [EMAIL PROTECTED] -
- Sun Microsystems http://www.sun.com/staroffice -
- OpenOffice.org
Hi Marc,
Secondly, there is no oConnection.createInstance in OOo 1.1.3 but this
code does in fact work:
Yes, the SingleSelectQueryComposer is new in OOo 2.0. 1.x had the
css.sdb.SQLQueryComposer, which is what your code uses. This service is
still present and functional in 2.0, but deprecated,
Hi Daniel,
I really don't know how you'd approach it from the OOo side of things.
Since PDF::ReportWriter requires complex items to be passed into it (
structures that describe fields, groups, and the data array itself ), I
suppose the easiest ( and dodgiest ) way of approaching it would be
Hello Dan,
First, I apologize if this email is directed to the wrong place or people.
no, you're at the right place here :) - welcome!
I'm working with the pre-2.0 beta version of the database.
Older than m79? How ... adventurous :)
What can anyone do to speed up or help with the database
26 matches
Mail list logo