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


Hi Chaim,

Rather then 'edit' use 'Edit in SQL View' to open the query definition,
this will bypass the problem.
_additionally_
If you designate the query definition as 'SQL Direct' this will have the
effect, for this particular query def, of always opening for edit in SQL
view.

HTH,

//drew

On Thu, 2011-10-06 at 11:51 +0200, Chaim Seymour wrote:
Hi

At this stage, I have two computers, a new one running Windows 7 and the old
one that ran Vista. After buying a new computer, I erased the Vista from the
old one and installed Fedora 15.

I have a database designed specifically for fountain pen collectors on the
Windows computer, but decided to set up something  using LibreOffice with
different fields and a different emphasis.

I used the Open Office writer under Windows but this is the first time that
I tried the database program. I would be quite happy to erase my first
attempt and try again. Its the only way to learn.

My command of Linux is still poor, but I have learnt a lot so far and still
have plenty to learn

Many thanks

Chaim

On 6 October 2011 11:26, Tom Davies <tomdavies04@yahoo.co.uk> wrote:

Hi :)
Is this a 1st attempt at moving away from Windows and MS Office at the same
time?

If the database was an Access database then the Queries, Forms and Reports
don't translate easily and need to be re-created.  The data in the Tables
should be Ok and any relationships between the tables is likely to be ok (i
would check that).

You might be able to translate the Queries by going back into Access and
view them as Sql statements and then copy&paste those into notepad and from
there into Base.  Access's Sql is quirky so it might be better to just
re-create the Queries from scratch.

Moving away from Windows does kinda force you into leaving MS Office
but it's often a good idea to stay in Windows a bit longer and just get
used to the programs first before migrating.  LibreOffice is a crucial
part of that, along with Firefox/Opera/Chrome instead of IE and
Thunderbird/Evolution/Claws for emailing.

A lot of programs written
for Windows do work in Gnu&Linux using Wine (Wine Is Not an
Emulator (it uses a more sophisticated approach)) but MS Office,
Outlook (and Outlook Express) and Internet Explorer are 3 that don't work
well.

Rgards from
Tom :)


--- On Wed, 5/10/11, planas <jslozier@gmail.com> wrote:

From: planas <jslozier@gmail.com>
Subject: Re: [libreoffice-users] data base program
To: users@global.libreoffice.org
Date: Wednesday, 5 October, 2011, 15:11

Chaim,

On Wed, 2011-10-05 at 13:57 +0200, Chaim Seymour wrote:

Hi all

I set up Fedora 15 on my second computer and the Libre Office is
included.

As a fountain pen collector, I started building a database for my
collection. I defined the fields and built a table. I started filling the
table, but wanted to add an extra field. To my surprise, the structure of
the db had disappeared. The table works. I can add items and alphabetize.

Can one go back and rebuild the db structure from the table and if so how
does one do it?


Right click on the table and select edit and you will see the table
design. Make your changes, adding new columns should not cause any
problems with data integrity and save. When open the database for data
entry you will see the new column.

Thanks

Chaim

--
Chaim Seymour
David Elazar 8
Givat Shemuel 54032
Israel
tel: 972-3-5320560




--
Jay Lozier
jslozier@gmail.com

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

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




-- 
Chaim Seymour
David Elazar 8
Givat Shemuel 54032
Israel
tel: 972-3-5320560




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

Context


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.