Re: [users] Exporting a database

2010-10-05 Thread Ed Warne
-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: Re: [users] Exporting a database On Tue, 2010-10-05 at 01:48 +0100, Ed Warne wrote: Hi I'm trying to convert my Open Office database to Lotus Approach. As I understand it, the recommended way of doing this is via Open Office

Re: [users] Exporting a database SOLVED (I think)

2010-10-05 Thread Ed Warne
-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: Re: [users] Exporting a database On Tue, 2010-10-05 at 15:52 +0100, Ed Warne wrote: Thanks Drew That seems useful. I'm assuming the * is meant to be after the SELECT, rather than before the FROM? Is a csv just text? Do I need

[users] Exporting a database

2010-10-04 Thread Ed Warne
Hi I'm trying to convert my Open Office database to Lotus Approach. As I understand it, the recommended way of doing this is via Open Office Spreadsheet and thence to a text file. When I do this, fields get converted into the wrong format. Text fields which contain only numerics convert to

Re: [users] Unable to delete or amend records in base 3.2.1

2010-08-17 Thread Ed Warne
, 2010 7:20 PM Subject: Re: [users] Unable to delete or amend records in base 3.2.1 Ed Warne wrote: snip What might I neeed to check? Is there a way of directly entering a SQL delete command? (amending a query in SQL prevents this). Thanks

Re: RE: [users] Unable to delete or amend records in base 3.2.1

2010-08-16 Thread Ed Warne
Sorry. I guess I can't reply from my other e-mail address (without it being moderated?). See below. Ed --- On Mon, 16/8/10, ed warne edwarne2...@yahoo.co.uk wrote: From: ed warne edwarne2...@yahoo.co.uk Subject: RE: [users] Unable to delete or amend records in base

RE: [users] Unable to delete or amend records in base 3.2.1

2010-08-16 Thread ed warne
- From: Ed Warne [mailto:ed.wa...@care4free.net] Sent: Sunday, August 15, 2010 10:18 AM To: users@openoffice.org Subject: [users] Unable to delete or amend records in base 3.2.1 Hi I'm in a query and have tried to delete a record entered in error. When I click yes I want to delete it, the record

[users] Unable to delete or amend records in base 3.2.1

2010-08-15 Thread Ed Warne
Hi I'm in a query and have tried to delete a record entered in error. When I click yes I want to delete it, the record remains. I tried to amend the record and on leaving the row, it reverted to the original contents. This happens with other records. I've tried clicking the edit icon (to