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 <[email protected]> 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 <[email protected]> wrote: > > > > From: planas <[email protected]> > > Subject: Re: [libreoffice-users] data base program > > To: [email protected] > > 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 > > [email protected] > > > > -- > > For unsubscribe instructions e-mail to: [email protected] > > 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: [email protected] > > 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: [email protected] 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
