Re: [libreoffice-users] Database back end?

I believe the first issue here is that I am not aware the method to use a base document as a back end and the same manner that you might contact say a different database using JDBC. So, I think you might need to use the API to manually manipulate the document which is very different than maybe w

[libreoffice-users] Database back end?

I was wondering if it would be possible to hookup a Java Web Application I am working on to LibreOffice's Base back-end. If it is possible, where can I find the API and a stand alone LO-Base? Thanks! -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.li

Re: [libreoffice-users] Database corruption since LO 5.7.3 installed

Hi Ptoye and all:         You say that sometimes the data file open well. When it happen, I suggest you to save the file with a new name (Other file). I would solve your problems. Regards, Jorge Rodríguez El 07/01/2018 a las 06:23, ptoye escribió: Since upgrading to LO 5.7.3 a database of

Re: [libreoffice-users] Database corruption since LO 5.7.3 installed

Hi Peter, Am 07.01.2018 um 13:23 schrieb ptoye: > Since upgrading to LO 5.7.3 a database of mine keeps getting corrupted. When > I try to open it it opens in Writer with the text Ó×r6ÒÒ#v If I try > opening it in a Zip file reader I'm told it's not a valid Zip file. It's not > consistent though;

[libreoffice-users] Database corruption since LO 5.7.3 installed

Since upgrading to LO 5.7.3 a database of mine keeps getting corrupted. When I try to open it it opens in Writer with the text Ó×r6ÒÒ#v If I try opening it in a Zip file reader I'm told it's not a valid Zip file. It's not consistent though; sometimes it opens OK. It's an embedded HSQLD database

Re: [libreoffice-users] Database help please

> On 3/03/2016, at 08:07, John Montgomery wrote: > > My problem arises when I enter double numbers eg A11, A20 etc, these should > follow in sequence but do not follow the sequence I want but A10 follows A1 > etc. > How can I ensure correct sequencing. Enter A1 to A9 as A01 - A09 Similarly wi

Re: [libreoffice-users] Database help please

I don't know if it works in your case, but perhaps using A01, A02 … A10 will give the right order? Kolbjørn Den 02.03.2016 20:07, John Montgomery skreiv: Dear Sirs, I am trying to assemble a simple graveyard database but am having difficulty in getting the form to work as I want. I have tried t

[libreoffice-users] Database help please

Dear Sirs, I am trying to assemble a simple graveyard database but am having difficulty in getting the form to work as I want. I have tried to use parts of the "Search and Filter" database but end up confused. I have also read relevent parts of the Base manual. I have two forms, Graves and Burials,

Re: [libreoffice-users] Database Design

I wish to thank those who responded. I will play with your suggestions and take your warnings to heart. At least for now, my son wants to go a different route with this by using an XML file to store the data and one or more Perl scripts to manage the XML file's content and to generate and to eM

Re: [libreoffice-users] Database Design

Also, I wouldn't even bother with putting up a table of driving instructions. I'd hook into Google's map driving capabilities. Don't reinvent the wheel unless you absolutely have to. On 11/17/2013 2:20 PM, James E Lang wrote: I have no experience designing a database. I hope this list is a s

Re: [libreoffice-users] Database Design

My $.05 (.02 adjusted for inflation): I'm seeing 3 tables SUBSCRIBERS SUBSCRIBER_ID SUBSCRIBER_NAME SUBSCRIBER_ADDRESS PUBLICATIONS PUBLICATION_ID PUBLICATION_NAME SUBSCRIPTIONS SUBSCRIBER_ID PUBLICATION_ID SUBSCRIPTION_START SUBSCRIPTION_END SUBSCRIPTION_DAYODELIVERY SUBSCRIPTION_SPECIALINST

[libreoffice-users] Database Design

I have no experience designing a database. I hope this list is a satisfactory forum for my questions. My son delivers a variety of newspapers with some subscribers getting more than one publication and with each publication's deliveries varied according to the day of the week. I want to constr

[libreoffice-users] Database error

Hello all, I use Mac and have Libreoffice 4 download 2 day a go from your Server. Then I like to use the Database I get this error : SQL Status: 42000 Error code: 105 [Actual][SQL Server] Unclosed quotation mark after the character string 's'. -- To unsubscribe e-mail to: users+unsubscr.

[libreoffice-users] Database field on top of PDF document

When I try to move a database field on top of an image (or PDF object), writer won't let me place it on top of the image. Is there a way to put a database field on top of an image? -- View this message in context: http://nabble.documentfoundation.org/Database-field-on-top-of-PDF-document-tp

Re: [libreoffice-users] Database problem

On 05/09/2013 10:59 AM, Paul D. Mirowsky wrote: On 5/8/2013 2:43 PM, Dan Lewis wrote: On 05/08/2013 02:06 PM, Sean wrote: Hello, the header constantly repeats itself around 8 times on every page. it's in the location: Database- MusicStudents Reports- AverageCostLesson please tell me the sol

Re: [libreoffice-users] Database problem

On 5/8/2013 2:43 PM, Dan Lewis wrote: On 05/08/2013 02:06 PM, Sean wrote: Hello, the header constantly repeats itself around 8 times on every page. it's in the location: Database- MusicStudents Reports- AverageCostLesson please tell me the solution

Re: [libreoffice-users] Database problem

On 05/08/2013 02:06 PM, Sean wrote: Hello, the header constantly repeats itself around 8 times on every page. it's in the location: Database- MusicStudents Reports- AverageCostLesson please tell me the solution -- View this me

Re: [libreoffice-users] Database problem

Sent: Wednesday, 8 May 2013, 19:06 >Subject: [libreoffice-users] Database problem > > >Hello, > >the header constantly repeats itself around 8 times on every page. > >it's in the location: >Database- MusicStudents >Reports- AverageCostLesson > >please t

[libreoffice-users] Database problem

Hello, the header constantly repeats itself around 8 times on every page. it's in the location: Database- MusicStudents Reports- AverageCostLesson please tell me the solution -- View this message in context: http://nabble.docu

Re: [libreoffice-users] Database Help: reiterating report header

On 05/08/2013 01:19 PM, Sean O'Connell wrote: Hello, I'm having trouble with my database report: i can't seem to only have one header (field) on each page without repetition on every record (there are like 10 headers(fields) in one page). For clarification and your help, please see the attachme

[libreoffice-users] Database Help: reiterating report header

Hello, I'm having trouble with my database report: i can't seem to only have one header (field) on each page without repetition on every record (there are like 10 headers(fields) in one page). For clarification and your help, please see the attachment of my database. It's in the location: Databas

Re: [libreoffice-users] Database sort problem

On 01/19/2013 11:59 AM, Ian Whitfield wrote: Hi All I now have my Main Form with Sub Form working well with one remaining problem... My Sub Form has a Field 'Date' (Type Date) and I have set it to sort into Date Order by selecting the field 'Date' and the value 'Ascending'. My date format i

[libreoffice-users] Database sort problem

Hi All I now have my Main Form with Sub Form working well with one remaining problem... My Sub Form has a Field 'Date' (Type Date) and I have set it to sort into Date Order by selecting the field 'Date' and the value 'Ascending'. My date format is DD/MM/YY (all numbers). But it seems to sort

Re: [libreoffice-users] database

On Fri, 2012-04-20 at 15:39 +0100, Elizabeth Lawrence wrote: > HI, > > I have downloaded libreoffice in order to use the database. I can > bring up the database but the one I want use wont open the wizard for > tables. > I have tried to uninstall libreoffice twice but it wont go. My blood

[libreoffice-users] database

HI, I have downloaded libreoffice in order to use the database. I can bring up the database but the one I want use wont open the wizard for tables. I have tried to uninstall libreoffice twice but it wont go. My blood pressure is soaring - please help! Liz Lawrence -- For unsubscribe in

Re: [libreoffice-users] database or spreadsheet

On Wed, 2012-02-08 at 08:34 +0100, Stefan Weigel wrote: > Hi Drew, Halo Stephen, Before we start in earnest. This was an outlying case as far as I'm concerned, not the norm here. But that said, we learn usually from looking at those situations where things didn't go quite as expected. That is m

Re: [libreoffice-users] database or spreadsheet

Hi, Am 08.02.2012 13:18, schrieb Chris Morgan: > We all have > to accept that spreadsheets will always be 'abused' when > a database may be more appropriate, until someone invents > a whole new database-spreadsheet hybrid. True. However, Calc (and other spreadsheet applications) offer a bunch of

Re: [libreoffice-users] database or spreadsheet

This is nothing to do with MS Office vs LibreOffice. It is to do with whole spreadsheet vs database debate. Normal users like spreadsheets, because you can start with a blank spreadsheet, add stuff by typing, or copy/paste, and produce useable results straight away. Spreadsheets are also very ext

Re: [libreoffice-users] database or spreadsheet

Hi Drew, Am 08.02.2012 00:32, schrieb drew: > The user asked how to rename sheets in Calc - end of story. But the beginning of the story is, that the user, before asking this question, first described an unfortunate way of holding data, which is the reason why he needs to rename a big number of

Re: [libreoffice-users] database or spreadsheet

On Tue, 2012-02-07 at 19:47 -0500, Paul D. Mirowsky wrote: > I think this is my "bad". > > I apologize to all. No need - a lot of traffic happens here, and it all is generated by humans.. stuff happens - my main point is - put it behind, a good discussion came of it. //drew > > On 2/7/2012 7:0

Re: [libreoffice-users] database or spreadsheet

I think this is my "bad". I apologize to all. On 2/7/2012 7:01 PM, drew wrote: On Tue, 2012-02-07 at 18:32 -0500, drew wrote: On Tue, 2012-02-07 at 22:17 +, e-letter wrote: On 07/02/2012, Nino Novak wrote: As a consequence: It would help most, if the database set up barrier could be low

Re: [libreoffice-users] database or spreadsheet

On Tue, 2012-02-07 at 18:32 -0500, drew wrote: > On Tue, 2012-02-07 at 22:17 +, e-letter wrote: > > On 07/02/2012, Nino Novak wrote: > > > > > > As a consequence: It would help most, if the database set up barrier could > > > be > > > lowered. > > > > > > We therefore should ask (and try to le

Re: [libreoffice-users] database or spreadsheet

On 02/07/2012 05:20 PM, e-letter wrote: On 07/02/2012, Jay Lozier wrote: IMHO, the real problem is that good data modeling is not usually taught to users and unless they start working with databases they never learn data modeling. Most books on using databases will, if briefly, discuss the conc

Re: [libreoffice-users] database or spreadsheet

On Tue, 2012-02-07 at 22:17 +, e-letter wrote: > On 07/02/2012, Nino Novak wrote: > > > > As a consequence: It would help most, if the database set up barrier could > > be > > lowered. > > > > We therefore should ask (and try to learn) what makes database creation so > > difficult, and how cou

Re: [libreoffice-users] database or spreadsheet

On 02/07/2012 05:17 PM, e-letter wrote: On 07/02/2012, Nino Novak wrote: As a consequence: It would help most, if the database set up barrier could be lowered. We therefore should ask (and try to learn) what makes database creation so difficult, and how could we contribute to ease the learing

Re: [libreoffice-users] database or spreadsheet

On 02/07/2012 05:05 PM, e-letter wrote: On 07/02/2012, Pertti Rönnberg wrote: After reading Dan’s “Chapter 8” I realized that LO-Base is The solution when a database of medium size/complexity is needed, either using the embedded HSQLDB or connecting to an external “real” database engine (e.g. M

Re: [libreoffice-users] database or spreadsheet

On 07/02/2012, Jay Lozier wrote: > > IMHO, the real problem is that good data modeling is not usually taught > to users and unless they start working with databases they never learn > data modeling. Most books on using databases will, if briefly, discuss > the concepts of data modeling and databas

Re: [libreoffice-users] database or spreadsheet

On 07/02/2012, Nino Novak wrote: > > As a consequence: It would help most, if the database set up barrier could > be > lowered. > > We therefore should ask (and try to learn) what makes database creation so > difficult, and how could we contribute to ease the learing curve? > > Or directly: how ca

Re: [libreoffice-users] database or spreadsheet

On 07/02/2012, Pertti Rönnberg wrote: > After reading Dan’s “Chapter 8” I realized that LO-Base is The solution > when a database of medium size/complexity is needed, either using the > embedded HSQLDB or connecting to an external “real” database engine > (e.g. MySQL or SQLite). Very much like MSA

Re: [libreoffice-users] database or spreadsheet

I hope to to condense and reply to all. A person has spent arduous hours of entering/linking/formula-ing etc... on spreadsheets. It is not the optimum of data entry, as would be a database form. But it does do every thing they want it to. Now, if a translation Calc (spreadsheet) to Base (data

Re: [libreoffice-users] database or spreadsheet

On Tue, 2012-02-07 at 12:39 -0500, Jay Lozier wrote: > On 02/07/2012 11:51 AM, Nino Novak wrote: > > On Tuesday 07 February 2012, Jay Lozier wrote: > > > >> Two related issues are a problem: spreadsheets are relatively easy to > >> set up and enter data with some inflexibility while databases harde

Re: [libreoffice-users] database or spreadsheet

On 02/07/2012 11:51 AM, Nino Novak wrote: On Tuesday 07 February 2012, Jay Lozier wrote: Two related issues are a problem: spreadsheets are relatively easy to set up and enter data with some inflexibility while databases harder to set up and without the right front end tools some tricky to prop

Re: [libreoffice-users] database or spreadsheet

Hello everybody – and especially Dan Lewis. I happened to read this thread about a database vs. spreadsheet. First of all I will thank Dan for him mentioning the “Getting Started Guide/Getting Started with Base/chapter 8"! I cannot understand how I could have missed it when I for some time have

Re: [libreoffice-users] database or spreadsheet

On Tuesday 07 February 2012, Jay Lozier wrote: > Two related issues are a problem: spreadsheets are relatively easy to > set up and enter data with some inflexibility while databases harder to > set up and without the right front end tools some tricky to properly > enter data but are much more fle

Re: [libreoffice-users] database or spreadsheet

On 02/07/2012 07:24 AM, e-letter wrote: On 06/02/2012, Dan Lewis wrote: Or maybe the failure is the refusal to understand the purpose for each part of a database. Tables and forms are for adding, modifying, and deleting data. Queries and reports are for data output. If you want to enter

Re: [libreoffice-users] database or spreadsheet

On 07/02/2012 12:47, e-letter wrote: On 06/02/2012, Gordon Burgess-Parker wrote: You are talking about me. I and many many others have used the same methods of categorising and storing data in Excel, Lotus 123, Multiplan and various other spreadsheet applications for a great many years. It's no

Re: [libreoffice-users] database or spreadsheet

On 06/02/2012, Gordon Burgess-Parker wrote: > You are talking about me. > I and many many others have used the same methods of categorising and > storing data in Excel, Lotus 123, Multiplan and various other > spreadsheet applications for a great many years. It's nothing whatsoever > to do with "d

Re: [libreoffice-users] database or spreadsheet

On 06/02/2012, Dan Lewis wrote: > Or maybe the failure is the refusal to understand the purpose for > each part of a database. Tables and forms are for adding, modifying, and > deleting data. Queries and reports are for data output. If you want to > enter data, you use a table or form. If yo

Re: [libreoffice-users] database or spreadsheet

On 02/06/2012 01:22 PM, Dan Lewis wrote: Or maybe the failure is the refusal to understand the purpose for each part of a database. Tables and forms are for adding, modifying, and deleting data. Queries and reports are for data output. If you want to enter data, you use a table or form. If

Re: [libreoffice-users] database or spreadsheet

On 06/02/2012 15:37, e-letter wrote: Readers, There was an interesting discussion which seemed to be about using accounting principles/conventions with computer software. Clearly the original poster forgot to dispense with traditional thought processes and think critically about how new tools (

Re: [libreoffice-users] database or spreadsheet

Or maybe the failure is the refusal to understand the purpose for each part of a database. Tables and forms are for adding, modifying, and deleting data. Queries and reports are for data output. If you want to enter data, you use a table or form. If you want to manipulate data, you use querie

Re: [libreoffice-users] database or spreadsheet

Everybody knows how write simple math statement as a formula. Everybody doesn't know how to right an SQL statement. The largest failure to using database vs. spreadsheet is the refusal to allow tables to set up formulas in databases as they are in spreadsheets. A formula interpreter would qu

[libreoffice-users] database or spreadsheet

Readers, There was an interesting discussion which seemed to be about using accounting principles/conventions with computer software. Clearly the original poster forgot to dispense with traditional thought processes and think critically about how new tools (first the computer, then more specifica

[libreoffice-users] Database selection in mail merge.

I am using mail merge for letter creation from within a form in Base. The base letter(s) were created in writer without problem. The View/Database (or F4) displays the explorer and fields from the database correctly. Whenever the form letter is opened the database is shown as selected and correctl

Re: [libreoffice-users] database

TER FREER > To: users@libreoffice.org > Sent: Sat, 4 June, 2011 11:11:15 > Subject: [libreoffice-users] database > > Dear Sir, > I have Windows Vista Home Premium Service Pack 2 > I was looking for a Database programme and chose your Libre Office 3.3.2 > programme. >

[libreoffice-users] database

Dear Sir, I have Windows Vista Home Premium Service Pack 2 I was looking for a Database programme and chose your Libre Office 3.3.2 programme. I downloaded and installed the programe including the LibreOffice Help Pack in English. After some traing and use I decided this was just too complicated