.28Third_quarter_2010.29
http://wiki.services.openoffice.org/wiki/Feature_Freeze_Testing_3.3
If someone wants to bring some of the line items form these pages to the
new wiki page...by all means do so.
That's it I suppose - thanks - and don't be shy,
Drew
there are yet to be:
- Add-on functionality
- Formula API
- Scripting support
- Flow text into sections
Would this be accurate?
Thanks
Drew
[1]
http://wiki.services.openoffice.org/wiki/SUN_Report_Builder:Planned_Features#AutoFormating_of_Controls
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.
out the SQL
command.
When you create a new Base query definition with in SQL view it does not
automatically stop the Base query parser from trying to parse the SQL
command -to do this you must select 'SQL Direct' - check your toolbar in the
query definition editor.
HTH,
Drew
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
know
the start of the day here, and a little sleep
for me..
Til later,
Drew
-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org
ahead, look at that list of unconfirmed, sorted oldest first, issues
-- if it looks to you like that issue can just be closed - because maybe
you actually do that type of thing
--- then either drop me an email and say
Drew close that issue - I just need the issue numer
or
--- drop by the irc
- 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
that jumped in - and as I put in the subject:
A little traveling music for way out http://baseanswers.com/blues-78.ram..
Sunday 3-21-2010 / Bluegrass day...just like today -ONLY - totally
different..see you on the wire
Drew
- that would be me - to be seated.
Next event Sunday 3/21 - Bluegrass Day
TTFN
Drew
-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org
you are all invited - no cover charge at the door - there is a three
drink minimum :)
Look for the Tall Ugly Guy at the door - that would be me - to be seated.
Next event Sunday 3/21 - Bluegrass Day
TTFN
Drew
last week,
under 100 at the moment, after diligent work mainly from drew, as i
know), not let any issues untouched and to check if they are still
valid (specially the older ones) .. so please support the OOo QA Base
team with this work and let us keep our area clean and up-to-date.
now we are down
in raising our chances of getting some help
that way.
Anyway - just a few thoughts of the top of my head...(mostly)
Drew
-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h
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: dev-unsubscr
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: dev-unsubscr
distribution package. So you
still need to install separately.
Drew
-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org
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
abut.
Thanks
Drew
-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org
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
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
if
This ie with 3.2 RC5 and an embedded db, XP.
The exact error is
Type: com.sun.star.sdbc.SQLException
The driver does not support the functionality for
'XParameters::setBlob'. It is not implemented.
This is correct?
Thanks
Drew
,
CurrentControl.BoundField.getString )
end if
Does work, quite well.
Drew
-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org
.
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
now.
Drew
-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org
this
With a query def in SQL view and escape processing disabled (SQL Direct)
perhaps this syntax:
CALL f_termine_report( '{1010131}', :begin_date, :end_date
,true, true, true, true)
I Can't say for sure that will work, but I would not be surprised if it did.
Drew
}', :begin_date, :end_date ,true,
true, true, true)
woops - sorry Daniel,
I don't need to wait for a response I realize that's just a wrong
suggestion.
Drew
-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
containing zero or
more rows, the columns named p0 to p(n-1)
Thanks,
Drew
-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org
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
sites if they would host
if for you.
Drew
-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org
.
Drew
-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org
, fk's or triggers then
added these...it jumps to 776K during the creation of the indexes.
After a SHUTDOWN COMPACT the file comes in at ~285 K.
Later,
Drew
a quick line in a FAQ style file that shows a valid entry and then what
results will be returned.
Sincerely,
Drew
On Wed, Oct 28, 2009 at 3:04 PM, Valden Longhurst
valdenlonghu...@edgecs.com wrote:
Good day Christoph,
After reading about the Music database project at
http
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
- meaning that they aren't
be turned off in the implementation here.
Thanks
Drew
-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org
back as
a batch.
To me this is much preferred as I can take control and force commits in
a script if it needs to be broken down into smaller atomic pieces, there
was *no* way to change the behavior of one statement / commit before.
Drew
:
The newer build does not need the stand-alone hsqldb.jar?
Drew
-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org
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
and have it
launch the form wizard it never fails.
Anyway - if no one opens an issue before me I will do so later tonight.
Drew
-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h
and have it
launch the form wizard it never fails.
Anyway - if no one opens an issue before me I will do so later tonight.
Drew
-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h
for? Personal use only or for others to
use also?
and one more question.
Why Base? Is there a particular reason, per chance - you create many
Impress files that use music files and want to stay in OO.o as you work
with cateloging? Maybe it is just what you have on your machine?
Thanks
Drew
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
( embedded HSQLdb is fine ) and bring up the
table Wizard.
Under 'Personal' table templates you will find table definitions for
tracking CD/DVD library.
It might be a good place to start from.
Drew
-
To unsubscribe, e-mail: dev
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
forms.
-or-
Maybe I'm missing something obvious and already there in the package to
help here?
Anyway - just more a note to myself to check Issuezilla and maybe open
an RFE if not already there.
Thanks
Drew
idea, but just want to be sure.
However - I think I can commit to the QA role. ( with a slight caveat
that I still need go over details with the QA team leaders )
Best wishes,
Drew
-
To unsubscribe, e-mail: dev-unsubscr
your normal group header only
on pages 2...n then reverse the logic of the conditional print statement.
Simple..
Want an example file, have that also, will attach it to the not yet
created entry in Issuzilla.
Drew
ps My example works with DEV310_m3 and SRB (LOL, hell if I know which
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
6.5 if you
don't have one and I'll see you in class!
Best wishes,
Drew
OpenOffice.org-minimal-version value=3.0 d:name=OpenOffice.org
3.0/
/dependencies
update the oxt file with the changes and install it under m39.
No doubt this voids the warranty ;/
Drew
-
To unsubscribe, e-mail: dev
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
functions will flow backwards into SRB 1.0.x ?
if not then someone should, I suppose, make note on the wiki page which
functions are available with which release.
Thanks,
Drew
-
To unsubscribe, e-mail: dev-unsubscr
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
no doubt.
Anyway - just a little idea to kick around on the list.
Till later,
Drew
-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org
- or loads the file
from a directory that does not allow embedded macros to run.
What should happen?
Drew
-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h
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.
.
How can I manage to get the report header and the following informations
beginning on the first page?
Hi Mechtilde,
Have you checked the 'Keep Together' property for this group in the
Sorting Grouping dialog.
Just curious.
Thanks
Drew
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
power or not in other words.
So - just speaking for myself...thank you for the time and effort you
are putting in to it.
That's it.
Sincerely,
Drew
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e
start.
John Meek
Hi John,
Well, how did you start with MS Access 97 and VB?
Did you just jump in and start building something?
Drew
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL
Drew
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
of a Sneak Preview post at the
forum...just as soon as I can figure out how to make a superscript TM
without using html [ we don't allow html code in posts on the
forum, so I will need to add the bbCode for it first, I would not want
to violate the trade mark] ( twisted smirk...)
Drew
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),
also.
and
You can find HSQLdb specific documentation for the ALTER TABLE and
CREATE SEQUENCE commands at their web site - http://hsqldb.org
Drew
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL
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
a FORM or a REPORT based on Query1
then you will be prompted for this replacement value when the FORM or
REPORT is opened also.
Drew
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
( as if it where a table ) and when Query2 is RUN it would prompt
for the SearchName parameter also.
Drew
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
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.
for this issue was
integrated in m238.
OK, I realize OOH is the work for the 3.0 release, but should I be
noting in the Issues when OOH680_m6 release does not pass for an issue
that does in SRC680_m245?
Thanks
Drew
much time is available and since MAC is now being built there...well ).
Anyway, I would like the builds for my ubuntu AMD64 environment - so any
know of a location?
thanks much
Drew
-
To unsubscribe, e-mail: [EMAIL PROTECTED
was hoping to put some time into this within the next 2 days and my
first goal is to get a NetBeans projects setup for Report Wizard and Report
Builder. If someone can help with a little information about getting this setup
that would be great.
Thanks very much
Drew
the address:
http://wiki.services.openoffice.org/wiki/Documentation/Database
vs
http://wiki.services.openoffice.org/wiki/Database
They both get you to the same page, but the former doesn't force the redirect.
So - any preference as to the address I use?
Thanks
Drew
a supplied odb, but there must be a
simple way to do so within the extensions code when needed. I don't see
how that is not the case already.
Drew
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL
it.
Hi Frank,
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.
Drew
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
this warning:
Scroll sensitive result sets are not supported by server; remapping to
forward-only cursor
Added the auto_increment statement IDENTITY to the advanced properties
of the connection manager, attempting to create an auto_increment field
now generates a syntax error.
Drew
be displayed i the new window.
-Original Message-
From: Dinbandhu [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 20, 2007 11:33 AM
To: dev@dba.openoffice.org
Subject: Re: [dba-dev] OO 2.3 Base form view says read-only-- But
it's not
On Thu, 2007-09-20 at 14:45 +, Drew wrote
- long story about
installing Community Version of Solaris on the second hard disk of a HP
PCarrrgh...that has no place here...arrrgh... Live and Learn.
Drew
-Original Message-
From: Dinbandhu [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 19, 2007 05:41 PM
To: dev
'
oEvent.Source.Parent.Parent.CurrentController.Frame
sOldTitle = oDBFormFrame.Title
offset = InStr(sOldTitle, ( )
if offset 0 then
oDBFormFrame.Title = left( sOldTitle, offset - 1 )
end if
end sub
-Original Message-
From: Drew [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 19, 2007 10:56 PM
To: dev
ISSUE# 81658
-Original Message-
From: Frank Schönheit - Sun Microsystems Germany [mailto:[EMAIL PROTECTED]
Sent: Monday, September 17, 2007 07:49 AM
To: dev@dba.openoffice.org
Subject: Re: [dba-dev] Importing foreign file databases into a .odb
Hi Marc,
In principle it would be enough
the issue, swapping
some mails in preparation makes it easier to concentrate on the
important things to write to the issue (me thinks).
But Drew is too fast for me, thank you Drew!
Marc
-
To unsubscribe, e-mail: [EMAIL PROTECTED
into a .odb
Am Montag, den 17.09.2007, 16:27 + schrieb Drew:
Actually, there was a point a few weeks back that this was gong to be
entered.
I may have started down the road you did - thinking that it needed to
be expanded to the general problem of importing data. That lead to
paralysis on my
this. To
duplicate that in Base you have to create some a very simple Basic macro,
called from a form.
Drew
not assign it as
the PK. Base will complain when you save, ignore it, DO NOT let it create a PK
column. HSQL will automatically set this as the PK next time the tables are
refreshed. Compound keys a not so easily handled.
Drew
and the column is named ID I would enter this
command:
ALTER TABLE Table1 ALTER COLUMN ID IDENTITY
Click on the Execute button.
The column type is changed without any loss of data.
For detailed description of that command look at the HSQLdb users guide
available at http://hsqldb.org
Drew
100 matches
Mail list logo
