Re: [libreoffice-users] Re: LibreOffice Base and MySQL

; edi...@federalsaints.net> wrote: > On 01/24/2016 10:04 AM, Hank Alper wrote: > >> Hi Ian, >> I frequently import Calc Spreadsheets into my MySQL database using >> phpMyAdmin.. My version of phpMyAdmin asks to locate the File you wish to >> import.Specifical

Re: [libreoffice-users] Re: LibreOffice Base and MySQL

Hi Ian, I frequently import Calc Spreadsheets into my MySQL database using phpMyAdmin.. My version of phpMyAdmin asks to locate the File you wish to import.Specifically, it offers a Browse option. Locate the Calc file you wish to import.by browsing to it in your file system. It also asks for the ty

Re: [libreoffice-users] LO Base/MySQL Backup??

Hi Ian, Ive been reading the posts concerning the security of your database using mysqldump. Are you using a remote server for your MySQL, or is it on your own computer? I've completed a database using LO Base with embedded HSQL. I guess I can use a MySQL server on my own machine to which I can con

Re: [libreoffice-users] SQL statement error when linking Main form to SubForm

Hi Noel I'm building a database for a fishing club. I have Member and Boat as two of the many tables in the DB. I have a form which shows my Member data and a sub form with the Boat data of all the boats the member owns. I used the wizard to produce this form. How did you establish the relationship

Re: [libreoffice-users] Italics and bold in BASE

Hi The short answer to your question is "Yes". You can use Bold and Italics in your Forms and in your Reports in Base. In both cases you must be in design mode. Have you been able to design a Form without using Bold or Italics ? Hank On Wed, May 8, 2013 at 12:31 PM, acanela wrote: > Hello, > >

Re: [libreoffice-users] Base data-loss and other problems

Hi Tom, My experience with the embedded database in Base has convinced me to move to an external back-end. I have had several instances of data loss particularly during sessions of heavy data input. While I'm in the process of moving my database to an external H2 database, I still use the embedded

Re: [libreoffice-users] Re: Base Report Builder

hopefully nothing too drastic. > > Apols for not replying sooner! I've just been a bit snowed under and > anyway Dan, Alex and others know far more about specifically Base itself so > hopefully someone has been able to give you much better help! > Regards from > tom :) > &g

Re: [libreoffice-users] Re: Base Report Builder

H2 has to offer. > > Noel > -- > Noel Lodge > lodg...@gmail.com > > > On 27 January 2013 17:24, Hank Alper wrote: > > > Hi Alex, Mark, Tom, > > You guys scare me ! I'm beginning to think I'd better start looking for > a > > new back end. I

Re: [libreoffice-users] Re: Base Report Builder

Hi Alex, Mark, Tom, You guys scare me ! I'm beginning to think I'd better start looking for a new back end. I've put a lot of work into this project. Tom, this is not a small database like an address book. After normalizing, my design has 16 tables.( with a few more coming as I've discovered as I

Re: [libreoffice-users] Re: Base Query Sort and Reports

Hi capemayal, In your case expression you use the WHEN keyword. You should have a THEN keyword to match. If the two dates in your expression match THEN what happens ? Hank On Sat, Jan 26, 2013 at 10:52 AM, capemayal wrote: > Yes, thank you Dan. > > I upgraded to 3.6.4, and the problem went away.

Re: [libreoffice-users] Base Report Builder

a bit more appropriate > than an embedded hsqldb... > The date on the above email was a couple of weeks ago. So, this > statement likely does not apply to LO 3.6.4.3. > > --Dan > > > On 01/20/2013 10:04 PM, Hank Alper wrote: > > Hi Dan, > Thanks for your quick

Re: [libreoffice-users] Base Report Builder

hen would it be appropriate to use it? As for CHECKPOINT DEFRAG, when should that be used. That might be useful as Base is getting much less responsive, seems bloated.. The size of my database file is about 360 KB. Hank On Sun, Jan 20, 2013 at 4:55 PM, Dan Lewis wrote: > On 01/20/2013 04:31 PM

[libreoffice-users] Base Report Builder

Hi I've invested a considerable amount of time in constructing tables, forms and queries for a project of mine. I successfully produced 3 nice reports using Report Builder. Now, I'm starting to observe strange behavior in Base. Queries and Reports I've prepared days earlier suddenly disappear after

Re: [libreoffice-users] Re: Base scenario

Ian How are you defining your primary keys and your foreign keys ? From your post, it looks like you have two tables, 'Members' and "eMail". Implicit in your post it appears that the primary key of 'Members' is 'Record ID'. Also, the primary key of 'eMail' is 'Message ID' while a key called 'Member

Re: [libreoffice-users] Re: Base scenario

an Whitfield wrote: > *Hi Hank* > > Thanks for your reply to me - appreciated!! > > > *On 01/01/2013 10:21 AM, Hank Alper wrote: > * > > *Hi Ian, > I'm not sure what you mean by automatic.Would you consider a list box with > a drop down list of all the member names

Re: [libreoffice-users] Re: Base scenario

Hi Ian, I'm not sure what you mean by automatic.Would you consider a list box with a drop down list of all the member names with the equivalent member ID being the input value to the subform automatic enough? I've used this approach many times on the project I'm working on. In your form edit mode

Re: [libreoffice-users] Libre Office Version 3.6.4.3 (Build ID: 2ef5aff)

Hi Chris, I'm using the same version of Libre Office as you are, on a windows 7 Professional system.. I have run databases on this version of Base which were developed on previous versions and even some developed on Open Office. I do not not have the same problem as you. However, If I close the ope

Re: [libreoffice-users] Re: Base Form behavior.

/06/2012 05:08 AM, Hank Alper wrote: > > Hi Hank, > > > ith the same result. Is this a bug? Has anyone noticed this type of > >> behavior ? Base seems to start out handling records in increments of >> about >> 40 records until it finds the end of the file. Stra

[libreoffice-users] Base Form behavior.

with the same result. Is this a bug? Has anyone noticed this type of behavior ? Base seems to start out handling records in increments of about 40 records until it finds the end of the file. Strange. Hank Alper -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Pr

Re: [libreoffice-users] documentation for LO base

Hi I have found that a good source of documentation for LO base is found in some of the documentation written for OO Base. I've been using Marano Casanova's excellent work available at Base_tutorial.pdf (application/pdf Object).