Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index

Alexander Thurgood wrote:
Le 28/09/12 14:43, Mark Stanton a écrit :

Hi Mark,

My query couldn't use the query wizard (Andreas won't be surprised). In coding the query I wrote the field names in camelcase (eg "Address1", "PersonName"), the actual database fields are all in lowercase. Changing this made the mailmerge show data. However, the query worked prior to that, and in fact the hidden paragraph conditions worked correctly, even though they were also in camelcase.

I seem to recall reading that somewhere on the French user list a while ago.


This may not help nor apply to your particular problem, but it may help point you to the problem. I am working on with program called DataVision as a replacement for the broken Base report builder. Reading your message reminded me of seeing something about column naming in the DataVision manual. Here is a snippet (my comments in <>). start snippet------------------------------------------------------------------------

   Database Name Case Sensitivity
   Some databases support case-sensitive names. In those databases, the
   column named "mycol" is different from the column named "MyCol".
   Unfortunately, the programs that access databases, such as JDBC
   drivers and command line tools like PostgreSQL's psql, often confuse
   the issue by changing all names to lower case or upper case
   internally, before sending the query to the database.  When you type
   "select MyCol from MyTable", it sends "select mycol from mytable" to
   the database <server>.
   If your database was created using names with only lower case (or
   upper case) letters, you may not see any problem. Your queries
   always work because no matter what case you use, the names are
   converted to all lower case (or upper case) and everything is fine.
   In order to access a column named "MyCol" using a tool that converts
   the names, you have to quote the mixed-case names. For example, the
   query "select MyCol from MyTable" must be entered as

       select "MyCol" from "MyTable"

   The quotes go around the parts of the name that need them, not the
   whole name <sql statement>. For example, the quotes don't go around
   the entire name "MyTable.MyCol". Instead, you would need to type

       select "MyTable"."MyCol"

End snippet -----------------------------------------------------------------------------

The manual then goes on to talk about DataVision-specific things.
So, your problem may not be Base, but your JDBC driver. Then again, maybe a change in Base has broken this communication to your JDBC driver. That would take more investigation. If, however, you are writing your own SQL, then you may check for this quoting requirement.
Girvin Herr

For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.