Re: [libreoffice-users] How to change Writer form letter database connection

Are the field names identical from original to newer data?

Are you creating new/updated queries?

I'm always switching to new single source databases from boilerplate 
Writer and haven't had a problem. I have not tried multiple sources though.

Also beware that while the fields may update to the new data, <next 
record> has to be applied manually.  (Seems to be true in most versions 
of LibreOffice).



On 10/11/2016 1:45 PM, Gary Dale wrote:
> Spoke too soon. The data source changes but not the fields. Unless I 
> change the fields in the document (re-insert them from the current 
> data source), they show up as blank. This is NOT what I want. I want 
> the fields to move to the new data source.
>
> In fact, I can't think of a reason for the current behaviour. Why 
> should switching data sources do that instead of the more sensible 
> behaviour of picking up the data from fields with the same name in the 
> new data source?
>
>
> On 11/10/16 01:34 PM, Gary Dale wrote:
> > No. I think you're thinking about Ctrl-Shft-F4 which brings up the 
> > the Data Sources toolbar.
> >
> > Actually, it's started working now for some reason. The error message 
> > I was getting has gone away. Weird.
> >
> >
> > On 11/10/16 12:22 PM, Tom Davies wrote:
> > > Hi :)
> > > Is it F4 to bring up a "connected databases" toolbar?
> > > Regards from
> > > Tom :)
> > >
> > > On 11 October 2016 at 17:00, Gary Dale <garydale@torfree.net> wrote:
> > >
> > > > How does one go about changing the database that a form letter 
> > > > connects to?
> > > >
> > > > I have this problem in several "form letters". I want to connect to a
> > > > different database than the one they were created against for the 
> > > > simple
> > > > reason that I have a different set of data that I want to print 
> > > > against.
> > > >
> > > > If this is a simple spreadsheet connection then I can simply 
> > > > connect the
> > > > database to a different spreadsheet. However I have a some cases 
> > > > where I
> > > > need to use queries with joins and/or sub-queries, which precludes 
> > > > the use
> > > > of a spreadsheet connection.
> > > >
> > > > While the obvious answer is to use a single database and use a 
> > > > query to
> > > > only select the current data, this is not ideal in my case. I 
> > > > prefer to
> > > > keep the data sets entirely separate so I can archive them by event 
> > > > along
> > > > with a lot of other event-specific files.
> > > >
> > > >
> > > > --
> > > > To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> > > > Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> > > > ubscribe/
> > > > 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


--
To unsubscribe e-mail to: users+unsubscribe@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