Re: [libreoffice-users] Re: Mailmerge from query broken in 3.4.6?

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.
>
>   
8><...
> Alex
>   
Alex,
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.
HTH
Girvin Herr



--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted