Hi,
During the marketing conference call, today, 10th Anniversary activities
where discussed. One idea was to put together an updated, and expanded,
history of the project.
To get this started I've taken the liberty to start a page on the Wiki:
Hi,
Looking over a few items regarding report builder, research for an
article, a few questions come to mind.
Looking at the Roadmap on the wiki [1]
I think that these are implemented:
- Rub Reports (partial)
- Repeatable Group Footer
- Hyperlink Controls
- Multi-Column support
while there
Hi,
Just wanted to say thank you to those that worked on the Base 3.3 New
Features page on the wiki.
It appears the only module to have such a page ready, before the 3.3
beta PR went out..
Thanks again Zoltan and B. Michaelsen
Drew
On 08/09/2010 02:52 PM, Mechtilde wrote:
Hello Drew
Am 09.08.2010 20:09, schrieb Drew Jensen:
On 08/09/2010 01:16 PM, Mechtilde wrote:
Hello Drew,
Am 09.08.2010 14:47, schrieb Drew Jensen:
What connector, I'm not talking about a connector...but maybe you mean
this one is fixed: http
Hi Mechtilde.
Thanks for responding like you did. I did not want my curtness in the
last email to seem towards you, nothing would be further from the truth.
But - there are other issues Zoltan has been working into the system
that it looks like need some input from someone in Hamburg also.
On Mon, Aug 2, 2010 at 5:17 AM, Ben Carbery ben.carb...@gmail.com wrote:
Hi Devs,
I am just trying out Base 3.2.0 with a postgresql 8.1 server. Very easy to
get going, but I noticed that some complex select statements generate
syntax
errors in base, but work fine via psql. There don't seem
Christoph Lukasiak wrote:
Christoph Lukasiak wrote:
moin database testing folks,
i would like to start a 'new year cleaning up db unconfirmed issues'
week (or two) to reduce this issues maybe under 50 (~120 last week,
under 100 at the moment, after diligent work mainly from drew, as i
Like I said - just like Blues Thursday - only - totally different
Do you twitter?
The tag is #blrgssunday
For a place to pull it together at:
http://drewjensen.typepad.com/blog/2010/03/hug-a-bug-day-2-bluegrass-sunday.html
Think of it as experiential art for geeks...
Well - it is but barely
Good morning,
Glorious day here in the Allegheny mountains.
Just jumping in where we left off in the last email
Christoph mentioned some of the really old Issues, with no activity for
a goodly while.
so let's start with the Music http://baseanswers.com/blues-am.ram
A first fitting piece for
- count is at 84
Guess it's time for another batch of tunes.
http://baseanswers.com/blues-84.ram
Time for some lunch -
Drew
On 3/18/2010 2:56 PM, Reizinger Zoltán wrote:
2010.03.18. 16:27 keltezéssel, Drew Jensen írta:
Is there anyone on the list that could look at this issue:
http://qa.openoffice.org/issues/show_bug.cgi?id=108415
Specifically with OO.o 3.2 w/ De or Es language packs.
I tried this on Hu version
well Folks - having full and good faith in Zoltan's next email clearing
an issue from the - Base unconfirmed issues
On 3/17/2010 5:17 AM, Christoph Lukasiak wrote:
Reizinger Zoltán wrote:
2010.03.15. 11:02 keltezéssel, Christoph Lukasiak írta:
Christoph Lukasiak wrote:
moin database testing folks,
i guess (and this is an experienced guess :) that about 30% of the
current issues have no responses for
Christoph Lukasiak wrote:
i guess (and this is an experienced guess :) that about 30% of the
current issues have no responses for months or are found on versions
long time ago, are not reproducable anymore or written that bad that
nobody can follow the description etc. :( so i usually rework
On 3/16/2010 2:45 PM, Marc Santhoff wrote:
Am Montag, den 15.03.2010, 11:02 +0100 schrieb Christoph Lukasiak:
Christoph Lukasiak wrote:
moin database testing folks,
i would like to start a 'new year cleaning up db unconfirmed issues'
week (or two) to reduce this issues maybe under 50 (~120
Hi Guys,
Priority wise IMO
Really need to hammer the issues right now looking for hidden gems.
The group has usually managed to keep our open issue count below 100,
normally well below.
Right now we are closer to 120 - It would help if we could just find a
way to tackle that list and get
Anyway - just a few thoughts of the top of my head...(mostly)
good ideas .. i had similar thoughts :)
*laughing*...hey I said mostly
Drew
ps - yeah I stole them
-
To unsubscribe, e-mail:
Hi,
Ok - so 50% of the developer team is now gone.
Anyone want to take a crack at where that leaves us?
Come on now - everyone has had a day to think about it.
Drew
-
To unsubscribe, e-mail:
On 2/28/2010 11:43 AM, Reizinger Zoltán wrote:
Hi,
I downloaded dev33m72 and installed on win7 and ubuntu 9.10.
In the Release notes they say that mysqlconnector cws was integrated,
but when I try to create new database the native driver not selectable
in both system.
On win I searched for
On 2/22/2010 8:38 AM, Drew Jensen wrote:
On 2/22/2010 2:23 AM, Peter Eberlein wrote:
Hi,
anybody from the base team there who can confirm
http://www.openoffice.org/issues/show_bug.cgi?id=109185
Also, could you tell me how you are connecting, ODBC, JDBC?
Thanks
What do you mean with a dataview window: grid control, date control, table?
Yes I meant if you just opened a table directly.
The latter: you can format the table column as -mm-dd hh:min:sec,
the time then is always 00:00:00.
and yes that would be the possible problem I was wondering
Fernand Vanrie wrote:
Frank
as told on d...@api i have still some 2 minor questions
as soon my code is complete i will postit here, there are a few
extentions around (like Drew' ReportRunner) who also can take
advantage of this new knowledge
huh - I almost forgot...just might spur me to
On 2/10/2010 1:38 AM, Ocke Janssen wrote:
Hi all,
Reizinger Zoltán wrote:
Hi all,
Ezzel a dátummal: Tuesday 09 February 2010 19.00.32 Drew Jensen ezt írta:
On 2/9/2010 11:53 AM, Frank Schoenheit, Sun Microsystems Germany wrote:
Hi Ocke,
I thought that I fixed that one in a DEV320
On 2/9/2010 5:03 PM, Frank Schoenheit, Sun Microsystems Germany wrote:
Hi Drew,
I have a query:
SELECT COL1 AS ALIAS FROM TABLE
Now I am handed a dataform in a routine and I need to find the column
names in the table, not the alias.
depending on which column object you have ... there might
for each
HSQLdb, MS Access, MySQL Native, ODBC/SQLite3
Note - I gave up trying to force a commit of the GUI controls to the
bound data columns.
To SLOW...
Drew
'Copyright (C) 2010 Andrew 'Drew' Jensen
'atjen...@openoffice.org
'
'This program is free software: you can redistribute
Attached bas file with support for SQLite3 via ODBC
'Copyright (C) 2010 Andrew 'Drew' Jensen
'atjen...@openoffice.org
'
'This program is free software: you can redistribute it and/or modify
'it under the terms of the GNU General Public License as published by
'the Free
and one with dates working...
now to rewrite the whole thing in js maybe...lol
'Copyright (C) 2010 Andrew 'Drew' Jensen
'atjen...@openoffice.org
'
'This program is free software: you can redistribute it and/or modify
'it under the terms of the GNU General Public License
That is the error I get with the follow lines:
if CurrentControl.ServiceName =
stardiv.one.form.component.ImageControl then
prepStatement.setBlob( fldcnt, CurrentControl.BoundField.getBlob )
else
prepStatement.setString( fldcnt,
CurrentControl.BoundField.getString )
end if
This
and as a BTW
if CurrentControl.ServiceName =
stardiv.one.form.component.ImageControl then
dim oStream as object
oStream = CurrentControl.BoundField.getBinaryStream
prepStatement.setBinaryStream( fldcnt, oStream, oStream.Length )
else
prepStatement.setString( fldcnt,
.
MS Access has an error in the executeUpdate command on the prepared
statement.
MySQL and PostgerSQL haven't checked.
Anyway, if anyone gives it a try I'd appreciate it.
Thanks
Drew
'Copyright (C) 2010 Andrew 'Drew' Jensen
'atjen...@openoffice.org
'
'This program is free
On 2/7/2010 12:26 AM, Drew Jensen wrote:
Last update for tonight. (new file attached)
But not quite last question.
Just tried this with SQLite3 ODBC data source.
Fail with error '?' in SQL INSERT not recognized.
We do support prepared statements with parameters under SQLite3 ODBC, yes
Fernand Vanrie wrote:
Just Stumbled on the fact that Subforms are no longer working with
3.2 RC1on a WINDOWS box
Normaly i connect to a MySQL server over Native or ODBC but even after
cpopying the table to a OO-HSQL file i have the same behaviour
To check: make a DBbase and use the
Daniel Käfer wrote:
Hello,
I use a postgres database and try to make a query with a (PLPG) SQL
function in OOo Base. This query needs two parameters: begin_date and
end_date.
SELECT * FROM f_termine_report( '{1010131}', :begin_date, :end_date
,true, true, true, true)
try this
With a
I use a postgres database and try to make a query with a (PLPG) SQL
function in OOo Base. This query needs two parameters: begin_date and
end_date.
SELECT * FROM f_termine_report( '{1010131}', :begin_date, :end_date
,true, true, true, true)
try this
CALL f_termine_report(
SELECT * FROM f_termine_report( '{1010131}', :begin_date,
:end_date ,true, true, true, true)
try this
CALL f_termine_report( '{1010131}', :begin_date, :end_date ,true,
true, true, true)
I don't need to wait for a response I realize that's just a wrong
suggestion.
Hi,
Right
Drew Jensen wrote:
The request is to enhance the query parser components to recognize a
command such as
CALL somefunction( params )
- allowing escape processing for function parameters
-- I don't know what the implications are regarding column names
-- Also don't know the cost
Christoph Lukasiak wrote:
Valden Longhurst wrote:
Correction: the assumption can be made on my part that I want to do
this. I did not intend to speak for others and their time. :-)
On 11/02/2009 07:29 AM, Valden Longhurst wrote:
Yes, as their is so few database examples out there, I'd like
Christoph Lukasiak wrote:
I created one that I am willing to freely provide you (with all
rights belonging to OpenOffice.org) that shows some of the less-known
features of HSQL. It is attached and has no dependencies on macros
or add-ons.
i would propose you to upload it here (then
On Thu, Oct 29, 2009 at 2:08 PM, Andrew Jensen
drewjensen.in...@gmail.comwrote:
Data!
Here is what I was thinking.
Option 1 - Just push the data into the odb file(s) and be done with it.
Pros - Doesn't get any easier then downloading one file.
Cons - The download is big.
Option 2 - refer
Hello Valden,
I think it would be excellent to add another example database to the
community repository. Which is seems ot forming on the wiki.
As for spiffing it up, Just a suggestion, first maybe put together a few
words on what each form or query does. If a query will prompt for data maybe
a
Drew Jensen wrote:
Right now then I'll go check the trigger statement against a stand
alone HSQLdb engine...and then maybe use the HSQLdb supplied sample
for triggers in the Base file (Table and Trigger def).
Ok - so it is my trigger statement.
Tried the supplied trigger definition
Reizinger Zoltán wrote:
Hi Ocke,
Ocke Janssen írta:
Moin,
On 10/15/09 19:49, Reizinger Zoltán wrote:
Drew Jensen írta:
Ocke Janssen wrote:
On 10/15/09 11:32, Reizinger Zoltán wrote:
Ocke Janssen írta:
Win upload now completed and tested.
I down loaded the new installation set, installed
Ok - how much of the new features in 1.9 should be usable in Base.
I don't mean via the GUI, rather
- Is there anything in the engine that is being suppressed in the
embedded implementation?
- Triggers , Procedures/Functions, etc
How about the other way - Anything that under 3.2 was not
Thought I'd pass this along -
When you are running multiple SQL statements in the SQL window how the
auto_commit setting behaves has changed w/current 1.9 build.
Under OO.o 3.2 (hsql 1.8) each statement is committed as executed.
Under DEV 3.3 (hsql 1.9) the statements are committed or rolled
Ocke Janssen wrote:
On 10/15/09 11:32, Reizinger Zoltán wrote:
Ocke Janssen írta:
Win upload now completed and tested.
I down loaded the new installation set, installed on winXP Home
Hungarian version, from cmd window:
msiexec/a openofficeorg32.msi
into C:\Program Files\OOo_hsqldb19\
Hi,
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.
Thanks,
Dj
-
To
Reizinger Zoltán wrote:
Hi Frank,
Frank Schönheit - Sun Microsystems Germany írta:
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
Reizinger Zoltán wrote:
Hi Frank,
Frank Schönheit - Sun Microsystems Germany írta:
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
IgorLarysa wrote:
Hello Nino,
Thank you for quick response. We are now working on requirements as we have
only project description: Create a music database (for handling music files,
cover, info) That's why we asking community for ideas.
Larysa
Hi Larysa,
May I ask - Who is the databse
IgorLarysa wrote:
Hi Drew,
For your question May I ask - Who is the databse for? Personal use only or
for others to use also? I can answer that the best project gets the chance
to be integrated into the OOo version as a sample document and will be
available then for users worldwide. We were
Ariel Constenla-Haile wrote:
Hello Igor,
On Friday 29 May 2009, 13:54, IgorLarysa wrote:
Hello Nino,
Thank you for quick response. We are now working on requirements as we have
only project description: Create a music database (for handling music
files, cover, info) That's why we asking
Ariel Constenla-Haile wrote:
Hello Drew,
On Friday 29 May 2009, 16:05, Drew Jensen wrote:
Thank you for quick response. We are now working on requirements as we
have only project description: Create a music database (for handling
music files, cover, info) That's why we asking community
Fernand Vanrie wrote:
Drew ,
Could this story been related to my latest issue
http://qa.openoffice.org/issues/show_bug.cgi?id=100764 (100764)
where i found that when selecting some lines in a beamer the events on
a opened dialog no longer works, but calling the same macro from a
toolbar
I will open an issue for this 'lost assignments' problem and attach a
very small example file. (After I do all this again under Linux to see
if there is any difference from what I'm getting here under XP)
Yes, it is the same with Linux.
Hi,
It appears that when a database document is opened for editing via the
Beamer macro execution is disabled.
My question:
Is there a simple way to disable that behavior for a specific
datasource's database document?
Thanks
Drew
Hi,
Have been actively using the 3.1 dev builds to construct a database and
this late idea for an enhancement comes to mind now.
Would be nice if one could define a custom toolbar or menu, using the
database document UI, at the database document window - and then - be
able to select that
Karl Weber wrote:
Hi Frank,
Am Donnerstag, 5. März 2009 15:42 schrieb 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
Mechtilde wrote:
On 20.02.09 20:18, Mechtilde wrote:
Hello,
There is a discussion at us...@de.openoffice.org.
We have problems to create a report about more than one pages.
We need a logo on the first page. and the group header on each page.
Details are displayed as a table.
In the
Drew Jensen wrote:
However there is a work around - ugly - but works.
Add an explicit Group to the report. (You know just type something
like 1 in the Group Dialog)
make this the first group, just below the page header, now turn off
Page Headers and use this GoupHeader instead.
Add your
Howdy,
Recently Frank posted up a pool of 'Next Features' possible for Base,
among which was this entry:
export the complete database/application
* as web application
* as JavaFX application
First thought was - Where is Mono?...LOL...
OK - seriously speaking now.
What exactly
Reizinger Zoltán wrote:
I answers to my mail Dev300m39 win version installs as dev 3.0 instead
of dev 3.1.
http://www.openoffice.org/issues/show_bug.cgi?id=98168
Zoltan
Hi All,
I downloaded from mirror windows version of DEV300m39, and installed
on freshly installed winXP noearlier version of
Frank Schönheit - Sun Microsystems Germany wrote:
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
Ocke Janssen wrote:
As far as I know this version should be 4 times faster in report
generating as before. You still need to start Writer or Calc which
cost most of the time.
And the formula which can be used have been reworked as the wiki page
for it.
Hi Ocke,
Just wondering if the new
Fernand Vanrie wrote:
Hallo Drew
Thanks for you extended reply. We are developing a Implemenation who
is based on Micrsoft SQL tables and views and or ODB file is connected
with ODBC. Due to the fatc that it are relative small data-tables
everyting go smootly. I learned a lot having a deeper
Fernand Vanrie wrote:
Hallo Drew, Frank
We have developed a a implementation as described by Drew, wath sould
be the best practice at this day to keep or users a far as possible
from our Tables etc..
Second question: waths the actual situation of having macro's in the
base document (OO 3.0)
Frank Schönheit - Sun Microsystems Germany wrote:
It should refuse to open the file.
Uhm.
I'd have a hard time implementing a logic like do not open this
document when you cannot execute on-load-macros, this sounds ... strange.
However, together with a open a form when opening the DB
Here is the scenario -
You have downloaded OpenOffice.org 3.1.
You installed the Switchboard extension.
You created a Base database file setting.
Developed your embedded scripts to handle the business logic in your
database.
Used Switchboard to generate your opening screen.
Carefully crafted
Alex Thurgood wrote:
Errrm, logically, it shouldn't run the macros. Ideally, you would get a message
telling you that macros have been deactivated or that you don't have the rights
to run MyMacro etc, but wait, let me guess, OOo just crashes without warning ?
Or better still, it runs the
Ocke Janssen wrote:
If anything doesn't work as for example in a DEV300_m35 so please tell
me or even submit an issue so that it doesn't get lost. So please help.
The build does not seem to honor macro security settings at all - runs
any macro from anywhere.
Mechtilde wrote:
Hallo
I want to create a report based on a query.
I use the SUN-Report-Builder.
There I define the query which I want to use.
In the report header I write the title of the report.
The page header is empty.
I define a group and fill the group header with two fields including
Mechtilde wrote:
Hello Drew,
Drew Jensen schrieb:
Hi Mechtilde,
Have you checked the 'Keep Together' property for this group in the
Sorting Grouping dialog.
I tested as no as only with the first detail. Both give the same result.
Just curious.
Is it a bug?
hmm
Frank Schönheit wrote:
Hi Max,
this snapshot now support these as well:
- syntax highlighting and bracket matching in Tools-SQL as well
(sometimes I really love programming ;-))
- configurable colors in tools-options-appearance
- parameters are highlighted as well
Cool stuff. Great
John Meek wrote:
I am an expert in Access 97 through 2003 and Access Visual Basic.
I downloaded Open Office 3 Beta 2 because of the database features.
I have become more and more disgusted with Microsoft.
I am looking to teach myself to use your database procuct.
How do I
Andreas Saeger wrote:
I'm so fed up with Base that I'm not even curious any more.
I'm sorry to say that.
@ Andreas - I think most of us already know that you have strong
feelings about Base. You have given your reasons quite well in previous
posts.
However if I may - Ocke asked a valid
Ocke Janssen wrote:
Moin all,
I uploaded a snapshot for the cws rptchart02 to
ftp://qa-upload.services.openoffice.org/
To access it use your OOo account. There are English and a German
version for Linux available and the new version of the
sun-report-builder extension.
This cws allows the
Ariel Constenla-Haile wrote:
Hi Peter,
Peter Eberlein escribió:
The original question remains (subject):
I can add an image control manually to the form, but how to commit a
picture without the whole api stream stuff...
tested on 2.4.0 with HSQLDB embedded, and with MySQL (JDBC/UnixODBC),
Michal wrote:
I am trouble maker because I wish it works my way.
Hi Michal,
Well - nothing wrong with that. First - I don't know if any of the
developers will chime in here but perhaps I can help a little.
First - it would be nice to know which version of OOo and under which OS
you are
Ariel Constenla-haile wrote:
Hi people,
following what Drew started a weeks ago, I've tried to reproduce the
database table preview in the Mail Merge wizard:
Hi Ariel,
Replace the Image control in the dialog with a group box ( FrameControl)
and it all works. (Image controls can't receive
Fernand Vanrie wrote:
if you formulate a parameter query and you save it with the
variables, you can later create a query in which only the variables
have to be replaced by the expressions that you want. OpenOffice.org
asks for these variables in a dialog as soon as you open the query.
Can
Fernand Vanrie wrote:
when its means that you can later create a query means you can
RUN a query
then is understand the lot :-)
I sent an earlier reply - but now that I see this I am left to ponder if
the Help text author was not intending to explain what happens with the
Alexandro Colorado wrote:
I am involved on the creation of a new site for the OOo community. The
site still a work in progress but still want to call for action. This
site will be a repository to host resources for OOo specifically
templates and clipart.
Alexandro Colorado wrote:
I am involved on the creation of a new site for the OOo community. The
site still a work in progress but still want to call for action. This
site will be a repository to host resources for OOo specifically
templates and clipart.
HI,
I am running tests to close some of the verified fixed issues and came
across something that I feel I need some clarification on.
Issue #61059 is a specific example.:
Tested with SRC680_m245 it passes, with OOH680_m6 it fails.
In the EIS entry for CWS dba24b it shows that the fix for
Hi,
Wondering if anyone knows of a location that is publishing development
builds ( or otherwise ) for Linux x86_64 platform ( deb or rpm)?
I had been getting these for long time from linux.cz ( Pavel's builds )
but it appears that they are no longer available there. ( I suppose only
so
Hi Ariel,
I've been following along with your posts - one comment.
About whether an extension supplied database should:
a) be registered
b) show up in the DSB
I think this needs to be narrowly defined. If we are talking about
actual odb files embedded in the oxt file, then I can see an
On Nov 21, 2007 1:54 AM, Frank Schönheit - Sun Microsystems Germany
[EMAIL PROTECTED] wrote:
Have fun, and tell me (in this list) anything you like or dislike about
it.
Frank Schönheit - Sun Microsystems Germany wrote:
Have fun, and tell me (in this list) anything you like or dislike about
Frank Schönheit - Sun Microsystems Germany wrote:
Hi Drew,
Should the copy table wizard in this release also work with an old
fashioned DnD? Just tried it under XP and it fails to start.
Hmm - WORKSFORME :-\ Between different DBs or within the same DB? Does
copy'n'paste work? Do you
Well, here we go again...LOL
I note that RedFlag has just announced that they are assigning QA staff
to work on the OpenOffice.org project.
Wonderful news.
Yup, One for Writer, One for Calc and One for Impress.
Jees - What's it going to take for people to acknowledge there is a
database
As I said in the issue.
Using latest developers build
Derby 10.3.1.4
Can create tables, but not set PK via GUI
Can add fields to a table.
Can not edit existing fields.
Adding data via SQL window - no problem.
After closing OpenOffice.org and then reopening database, when
connecting I get this
89 matches
Mail list logo