Re: [libreoffice-users] data base program

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