[libreoffice-users] Re: Urgent Base problem

2013-01-24 Thread capemayal
Hello Alex. Thanks your response. I'm using 3.5.4 from Ubuntu 12.04 LTS software library. Right now, the only workaround I've found is to create view from the query, then use that for the report. However, I'm going to assume you've gotten 3.7 from the LO website. I'll uninstall my 3.5.4 and d/

[libreoffice-users] Re: Urgent Base problem

2012-03-17 Thread Andreas Säger
Am 17.03.2012 11:41, Ian Whitfield wrote: What "filter" must I selct or what must I do to get my Database going again?? You need to restore your database from a backup. It is lost. This would not have happened with a true database connection. The database wrapped in a single document (embedd

[libreoffice-users] Re: Urgent Base problem

2012-03-17 Thread Andreas Säger
Ian Whitfield wrote via personal mail: *Hi Andreas* Thanks for your reply!! Appreciated - although I don't "like" the answer!! I thought to ask you this rather 'off-list' in case. You say I must use a "Real Database Connection" if I want to work with this bastard!! By "Bastard" I guess you mea

[libreoffice-users] Re: Urgent Base problem

2012-03-17 Thread Andreas Säger
Am 17.03.2012 21:20, Mark Stanton wrote: I would suggest replacing the bastard (are we really talking like this? :-) ) with MySQL or perhaps even better MariaDb (mebbe even Postgres). Replacing one excellent databse engine with another excellent (much bigger) database engine will not solve an

[libreoffice-users] Re: Urgent Base problem

2012-03-18 Thread Andreas Säger
Am 18.03.2012 08:56, Mark Stanton wrote: I think the point Mark was making was to switch away from using the embedded back-end to pretty much any external one. Which is what you often suggest too. Yes indeed. Can HSQLDB be used as an external engine? I thought not, which is why I didn't inclu

[libreoffice-users] Re: Urgent Base problem

2012-03-18 Thread Andreas Säger
Some additions for anybody who wants to follow my receipt: Am 18.03.2012 10:25, Andreas Säger wrote: Extract ./database/ from your embedded database somewhere to your files. Rename your database files with a common "dbname." prefix. The "dbname" in the below URL is "chargen" so I renamed the fil

[libreoffice-users] Re: Urgent Base problem

2012-03-21 Thread Alexander Thurgood
Le 19/03/12 11:36, Ian Whitfield a écrit : Hi Ian, > > One thing I've lost with my "crash" is the correct sorting order on my > Base Form. > There is a known bug in 3.5 where the sort order does not get memorised and stored for re-use on next opening of the ODB file. It should be fixed for 3

Re: [libreoffice-users] Re: Urgent Base problem

2013-01-24 Thread Dan Lewis
On 01/24/2013 05:14 PM, capemayal wrote: Hello Alex. Thanks your response. I'm using 3.5.4 from Ubuntu 12.04 LTS software library. Right now, the only workaround I've found is to create view from the query, then use that for the report. However, I'm going to assume you've gotten 3.7 from the

Re: [libreoffice-users] Re: Urgent Base problem

2012-03-17 Thread Tom Davies
Hi :) I think the point Mark was making was to switch away from using the embedded back-end to pretty much any external one.  Which is what you often suggest too.  Regards from Tom :) --- On Sat, 17/3/12, Andreas Säger wrote: From: Andreas Säger Subject: [libreoffice-users] Re: Urgent Base

Re: [libreoffice-users] Re: Urgent Base problem

2012-03-18 Thread Russell Wilson
u, I don't mind learning again, if one is learning to do things more reliably and or powerfully Rusty in more ways than one I'm rusty ;-) - Original Message - > From: Andreas Säger > To: users@global.libreoffice.org > Cc: > Sent: Sunday, 18 March 2012 10:25 PM >

Re: [libreoffice-users] Re: Urgent Base problem

2012-03-19 Thread Ian Whitfield
Hi All Thanks for all the information and suggestions from everyone!! Appreciated!! First of all an apology from me - Re: "Hi-jacking" a thread. I'm on a couple of other "lists" and on these I only have to change the Subject Line to start a new thread - and I keep forgetting that the LO list D

Re: [libreoffice-users] Re: Urgent Base problem

2012-03-19 Thread Ian Whitfield
Hi One thing I've lost with my "crash" is the correct sorting order on my Base Form. I originally found a nice tutorial on the Net on how to do this but can no longer find this!! Can anyone point me in the right direction to be able to sort my data again?? I want to sort by Surname and t

Re: [libreoffice-users] Re: Urgent Base problem

2012-03-19 Thread Dan Lewis
On Mon, 2012-03-19 at 12:36 +0200, Ian Whitfield wrote: > Hi > > One thing I've lost with my "crash" is the correct sorting order on my > Base Form. > > I originally found a nice tutorial on the Net on how to do this but can > no longer find this!! > > Can anyone point me in the right directio

Re: [libreoffice-users] Re: Urgent Base problem

2012-03-19 Thread Tom Davies
n, 19/3/12, Ian Whitfield wrote: > From: Ian Whitfield > Subject: Re: [libreoffice-users] Re: Urgent Base problem > To: users@global.libreoffice.org > Date: Monday, 19 March, 2012, 10:36 > Hi > > One thing I've lost with my "crash" is the correct sorting > order on

Re: [libreoffice-users] Re: Urgent Base problem

2012-03-19 Thread Tom Davies
itfield > Subject: Re: [libreoffice-users] Re: Urgent Base problem > To: users@global.libreoffice.org > Date: Monday, 19 March, 2012, 10:06 > Hi All > > Thanks for all the information and suggestions from > everyone!! Appreciated!! > > First of all an apology from me -

Re: [libreoffice-users] Re: Urgent Base problem

2012-03-19 Thread Brian Barker
At 12:44 19/03/2012 +, Tom Davies wrote: Side-issue = Zip To open a zip-file on Windows you need to have something like WinZip, WinRar, File-roller or something else similar. Nope. All currently supported versions of Windows include built-in support for zip files. Brian Barker -- For

Re: [libreoffice-users] Re: Urgent Base problem

2012-03-20 Thread Tom Davies
om: Brian Barker Subject: Re: [libreoffice-users] Re: Urgent Base problem To: users@global.libreoffice.org Date: Tuesday, 20 March, 2012, 2:03 At 12:44 19/03/2012 +, Tom Davies wrote: > Side-issue = Zip  To open a zip-file on Windows you need to have something > like WinZip, WinRar

Re: [libreoffice-users] Re: Urgent Base problem

2012-03-20 Thread Brian Barker
At 08:56 20/03/2012 +, Tom Davies wrote: I've known quite a few people using Xp that couldn't open zipped files and needed help installing an archive manager. Do you mean you know dim people and advise them wrongly? Er, maybe suggest they just double-click the .zip file? Brian Barker

Re: [libreoffice-users] Re: Urgent Base problem

2012-03-20 Thread Tom Davies
everal MS programs for viewing pictures.  Again a pre-existing condition of particular logins on a couple of machines.  Regards from Tom :) --- On Tue, 20/3/12, Brian Barker wrote: From: Brian Barker Subject: Re: [libreoffice-users] Re: Urgent Base problem To: users@global.libreoffice.org Date:

Re: [libreoffice-users] Re: Urgent Base problem (stability in long term use)

2012-03-17 Thread Paul Lens
Interesting to know! For my part, by precaution, all my data are kept in separate dbf tables, linked to an odb file. Why do I use dbf? Standard format making it portable to all softs, notably GIS softwares. Old archives can also be read even if you changed your soft. There is not much inf