openoffice-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ariel Constenla-Haile <arie...@apache.org>
Subject Re: Mail Merge Problem
Date Sat, 10 Nov 2012 10:17:14 GMT
Hi,

On Sat, Nov 10, 2012 at 11:03:12AM +0100, Andreas S├Ąger wrote:
> > i have been trying to get empty fields to not leave blank lines.
> > I have got it working with fields like Town but when the field name
> > has a space in it, like' Street Address 1' I cant work out how to
> > refer to field.
> > 
> > I have been using Insert->Section and checking Hide.  in the 'With
> > Condition' field I have been adding 'city eq ""' but how do I refer
> > to 'Street Address 1', I think it is the space that is causeing the
> > problem.
> > 
> > Ben
> > 
> 
> Then the question is how the space gets into the field. The field is
> not empty if there is a space so the rule which hides the entire field
> does not apply.  Which is the type of database you are connected to?
> Hit F4, right-click the data source icon and choose "Edit Database
> File". The status bar of the database window indicates where the data
> come from.

If I understood Ben, he has a problem not with the content of the
field/underlying DB record, but with the name of the field in the
condition, for example "Database 1.Some table. Street Address 1";
according to the online help, "Conditions and Database Fields":

When you refer to a database field in a condition, use the form
Databasename.Tablename.Fieldname. If one of the names contains
a character that is an operator, such as a minus sign (-), enclose the
name in square brackets, for example,
Databasename.[Table-name].Fieldname. Never use spaces inside field
names.

It seems he has to use [] to surround database/table/column names with
spaces:

[Database 1].[Some table].[Street Address 1]

I didn't try it at home, so I'm not sure if it's like this.

Then he may face the problem that some databases fill empty records
with blanks.


Regards
-- 
Ariel Constenla-Haile
La Plata, Argentina

Mime
View raw message