Hi Wolfgang,
>>but don't forget to clean it up later on, to not leak resources:
>> oConnection.close()
> normally used :-))
good to hear :). This is often forgotton, which then leads to later
operations possibly failing, since the previous (still alive) connection
locks resources associated with
Hi Wolfgang,
> 2. Failed query 1: The MsgBox write the table identifier in Capitals
> followed by the chosen name in mixed Upper/lower case:
> The query is working after renaming the table name in ALL CAPITALS.
It seems that our engine, HSQLDB, is indeed automatically capitalizing
all identifier
Hi Wolfgang,
> Writing
>
> oQuery.Command = "SELECT * FROM " & "Journal"
> the table (also all other names) was not found.
with
sQuoteChar = oConnection.getMetaData().getIdentifierQuoteString
try adding the |sQuoteChar| before and after the table name.
If you don't have a connect
Hi Philip,
> I am creating a form using a field from a BASE table with OpenOffice
> 1.9.90.0. I want to use a 'Formatted Field' to display the contents of
> this field. After selecting the table from the 'Form Properties' window
> one would expect that the next action would be the selection o
Hi Philip,
> I am writing a report using a BASE table in OpenOfiice 1.9.90.1. I
> simply need to display all rows in the following table and GROUP by
> ProductID, ie, "Select * from Sales, group by ProductID".
> [does not work]
which is now known as issue 47329.
Thanks for reporting.
Ciao
Fr
Hi Sophie,
> I was sure the implementor was not far from you ;) I'll fill the bug
> against dba project, right ?
nope, please word processor - they "just" integrate our functionality.
Though people never believe it, we (DBA) do not have any shares in mail
merge, except that from time to time, I
Hi Sophie,
> And the next button after those two is ... Mail merge ! in 1.1.x it
> opens a dialog window where you can choose which records you want to
> print from 3 different modes (all, selected records, or records from x
> to y).
Ah ... forgot about this one ...
Just asked the implementor
Hi Sophie,
> Some of our users have requested to not use the wizard to mail merged
> datas in letters. I thought the icône in F4 toolbars was the right one,
> but no, the wizard was still hide behind it ;)
? Not sure whether I get you here. If we're talking about the "Data to
text" and "Data to
Hi Alex,
> [mail merge]
> As a follow on to Sophie's question, it appears from reports on the
> French list that you can now no longer select the printer, because the
> print dialog doesn't come up. In 1.1.x, the mailing or serial letter
> component let you choose the printer for output after you
Hi Scott,
> [postgresql driver]
> What would be needed to get this into the Build Environment? I may have
> some time to get this in.
Would be great!
- create a project holding the needed PostgreSQL headers/libs/whatever,
or place them in the external project. Not sure what's the better
sol
Hi Josh,
> Well, all quoted identifiers is fine *if* the identifiers come from the
> database, not from the user. And provided that they don't get automatically
> uppercased before being quoted.
I'm not sure whether I understood Wolfgang's original post right (it
seems that two non-native Eng
Hi Josh,
> What's the logic behind the query tool generating all-quoted identifiers?
as always, "Trying to be on the safe side, making more DBs happy than
harming others". Or so. If the database (its driver, more precise) tells
OOo that there *is* a quoting character for identifiers, then OOo wi
Hi Daniel,
>>- press F4
>>- select the desired table in the data source browser
>>- drag'n'drop a column header of your choice into the document, while
>> holding Ctrl-Shift
> I can do all of these successfully. Thanks, that's more than what I had
> before.
fine :)
>>- switch off the design mo
Hi Daniel,
> How can I make a form that reflects the contents of a database table?
the fastest way to get *something* is to
- press F4
- select the desired table in the data source browser
- drag'n'drop a column header of your choice into the document, while
holding Ctrl-Shift
- switch off the
Hi Jacob,
> I would assign it, but don't know your user name :D
> It's issue 46164: http://www.openoffice.org/issues/show_bug.cgi?id=46164
oops :) [EMAIL PROTECTED]
I'll grab the issue, thanks for filing it.
Ciao
Frank
--
- Frank Schönheit, Software Engineer [EMAIL PROTECTED] -
- Sun M
Hi Jacob,
> [table views]
> Do you think that could be clarified in the documentation?
Do you mind submitting an issue for this, component "documentation".
Please add how to navigate to the help topic which needs improvement.
You may assign it to me initially, and I will add my comments and
forw
Hi Oliver,
> after adding a piece of text (which contains some checkboxes)
> to the autotext container, i want to insert it into a new writer document ...
>
> but after inserting the autotext, the text document is in *design* mode ...
> this is not what i wanted ... cause at the time i added the
Hi Jacob,
> I don't think I understand the concept of table views. What is a table view?
Basically a server-side query. To clients (such as OOo), it basically
looks like an ordinary table. Depending on the server, it means that you
might be able to do table-operations on them - for instance, use
Hi Jayant,
> Just wondering, if there is any xml file that needs to be written so
> that In the
>
> "mail merge wizards"-> 3. "Check if the address data matches
> correctly".
>
> is enabled correctly depending upon the "selected Address" ??
>
> Though I can see in the DataAccess.xcu
> "Colum
Hi Josh,
> ... is it going to ship with OOo 2.0?Even if it's beta, it's fairly
> functional, and would make life easier for a lot of users. The license
> shouldn't be a problem, the PostgreSQL libraries are BSD.
Most certainly not. I'd like to have it, because it seems to be in a
pretty s
Hello Ian,
> I am updating the Migration Guide files (part of OOoAuthors.org) for
> OOo2.0 (based on 1.9.74) so that the updated guide is ready for the
> regional conferences. One of the chapters of the guide is titled Sharing
> Files.
> I would just like to check that my understanding on a few ma
Hi Ian,
> Thanks for replying to this message. My apologies for not replying to it
> myself as I had found and joined in on the dev@api.openoffice.org
> discussion.
Ah, indeed, you contributed to the macro in this thread :). No problem,
from time to time I just try to "finish" at least the "trivi
Hi Ian,
> In 1.9.77 for Linux I can add a macro library to a Form or a Report, but
> not directly to a .odb file is this correct?
Yes
> How do I open a form (or report) by macro (either via UNO dispatch calls
> or API) so that I can create controls for doing this? For example
> creating a switch
Hi Justin,
> Went there and with a bit of investigating, found it as TaskID 'i42033'.
>
> It's Milestone (integrated) is blank, and the Est. due date (ready for
> QA) is a few days ago (10th Feb), so it probably means it'll be
> available for testing soon.
yes, it's status is "Ready for QA", w
Hi Alex,
> - can't access your data outside of OOo, either via ODBC or JDBC. If you
> install the JDBC driver that comes natively with HSQLDB instead of that
> provided with OOo, your ODB document stops working
"stops working"? Sounds like worth a visit to IssueZilla :)
> - can't rename your dat
Hi Chris,
> ERROR: (com.sun.star.uno.RuntimeException) { { Message = "Lock
> file indicates that a concurrent Office process is running!",
> Context = (com.sun.star.uno.XInterface) 0x0 } }
juest guessing: see whether your ~/.openofficesomething (or was it the
installation directory) c
26 matches
Mail list logo