[libreoffice-users] Re: Serious application development with LibreOffice and LibreOffice Basic

Greetings Mark,

I am puzzled at what you posted in reply to my original message...

I was talking about a desktop database as the front-end in a Client/Server application.

It appears your question was with using spreadsheets as a database table.

Did I not understand something that was intended?

Sincerely,

--
Michael Lueck
Lueck Data Systems
http://www.lueckdatasystems.com/

> Mark LaPierre wrote:> Oops!  I meant to send this to the list.
> > This is what I was told when I asked about the capabilities of Base:
> >
> > "
> > Le 17/02/2013 02:38, Mark LaPierre a écrit :
> >
> > Hi Mark,
> >
> >
> > > Now how do I create non-linked tables inside the same DB?
> > >
> > > How do I link to another external spreadsheet using the same DB?
> >
> >
> > You would be better off using an external HSQLDB instance to link
> > directly to text tables (note that these would not be Excel files). See
> > the HSQLDB manual for how to do this.
> >
> > http://hsqldb.sourceforge.net/doc/guide/guide.html#texttables-chapter
> >
> > > Can I link to only one spreadsheet at a time?
> >
> >
> > In a single ODB file with the embedded hsqldb engine, AFAIK yes.
> >
> >
> >
> > >  From your email I gather that all tables must be tabs on the one
> > > spreadsheet that is linked.  Is that a true statement?  Seems pretty
> > > inconvenient.
> >
> >
> > It is, fairly. But LO Base is not Access, nor FMPro. If you need to work
> > comfortably with and edit multiple separate data sources, using the
> > embedded hsqldb is probably not the best choice.
> >
> > Alex"
> >
> > YMMV



--
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