Re: [dba-dev] Table names Uppercase a must? Strange things

2005-04-11 Thread Josh Berkus
Frank, > 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 will > use it. Well, all quoted identifiers is fine *if* the identifiers co

Re: [dba-dev] Speaking of the PostgreSQL driver ...

2005-04-11 Thread Scott Carr
Frank Schönheit - Sun Microsystems, Inc. wrote: 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 cer

[dba-dev] Form Controls in BASE

2005-04-11 Thread philip morgan
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 of the data field fr

[dba-dev] BASE - Group by headings missing - OpenOffice 1.9.90.1

2005-04-11 Thread philip morgan
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". Sales Table InvoiceNoProductID QuantitySalesPersonID I1000W1002

Re: [dba-dev] Table names Uppercase a must? Strange things

2005-04-11 Thread "Frank Schönheit - Sun Microsystems, Inc."
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