[libreoffice-users] Re: mySQL login from a form using direct connect

2014-12-29 Thread Alexander Thurgood
Le 29/12/2014 00:20, craig48 a écrit : > > When I open the form, the database password is requested and I enter it, and > the form's grid is loaded with the data. I'm having trouble connecting from > the form using a basic macro. The connection requires a password. Running > the following code p

[libreoffice-users] Re: Recommendations for an Android app?

2014-12-29 Thread Alexander Thurgood
Le 29/12/2014 13:00, Charles-H. Schulz a écrit : Hi Charles, > Well.. we are about to have one I think ? > One that allows for editing as well ? Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-u

[libreoffice-users] Re: Recommendations for an Android app?

2014-12-29 Thread Alexander Thurgood
Le 29/12/2014 13:00, Charles-H. Schulz a écrit : EuroOffice : Presenter Calc Words all provide for native editing of ODF documents. Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Pos

[libreoffice-users] Re: Macro to open form + pass on value from current form

2014-12-17 Thread Alexander Thurgood
Le 17/12/2014 18:07, Joel Madero a écrit : Hi Joel, >> - checked whether a value existed in another table via a parameterized >> query, > Do you have an example of how to do this? The online documentation is > quite scarce for base :-/ Unfortunately, this was in a previous life of mine, and I di

[libreoffice-users] Re: Macro to open form + pass on value from current form

2014-12-17 Thread Alexander Thurgood
Le 17/12/2014 03:05, Joel Madero a écrit : Hi Joel, > I have a form that has bookID as a unique key. I want to have a button > that is to open a second form and do the following: > > (1) search for the bookID in another table (Series); > (2) If bookID does not exist in Series, create a new rec

[libreoffice-users] Re: How to edit a signature file into a PDF document

2014-12-05 Thread Alexander Thurgood
Le 04/12/2014 07:03, Alex Thurgood a écrit : > > Master PDF Editor for Linux will let you do all this and more. And for those on Mac, just use the PDF Viewer (Preview) that Apple supplies, as you can now add signatures directly from a scanned source in OSX 10.10. Previous to OSX 10.10, I used

[libreoffice-users] Re: Base knows SQL functions?

2014-11-28 Thread Alexander Thurgood
Le 28/11/2014 14:15, Mark Stanton a écrit : Hi Mark, > So, to explain it fully, the (very prety and worthwhile) design mode *does* > appear to have "a list" of what it knows about... Perhaps it has to... Even > with that switched off Base still checks and only accepts code it knows > about, bu

[libreoffice-users] Re: Base Help Anyone

2014-11-18 Thread Alexander Thurgood
Le 18/11/2014 12:35, Alan Pedder a écrit : Hi Alan, > > Is is a know issue that it is unstable ? In addition I set auto save and > backup yet fail to find them anywhere. Yes, unfortunately a known and frequent phenomenon with the default provided embedded hsqldb implementation. You might g

[libreoffice-users] Re: New LibreOffice user Question

2014-11-12 Thread Alexander Thurgood
Le 12/11/2014 15:22, Dave Asaibene a écrit : Hi Dave, > I have a Mac Mini running OS 10.4.11 and a Macbook Air with 10.10. I want to > donate the Mac Mini to a community center, however I also want to set up a > database for their use and be able to transfer files or work and modify the > dat

Re: [libreoffice-users] Re: LO and Java 8u25 - SOLVED

2014-10-29 Thread Alexander Thurgood
Excellent, thanks for this Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libre

Re: [libreoffice-users] Re: LO and Java 8u25 - SOLVED

2014-10-29 Thread Alexander Thurgood
Le 29/10/2014 11:10, Alain Andrieux a écrit : Hi Alain, > Hi Alex, > > Creating a template as described in the bug report works just fine, no crash > here. It is not the template itself that causes the problem, but rather "Saving as template" which invokes the template manager, but thanks for

[libreoffice-users] Re: LO and Java 8u25 - SOLVED

2014-10-29 Thread Alexander Thurgood
Le 29/10/2014 09:54, Alain Andrieux a écrit : Hi Alain, Could you test whether : https://bugs.freedesktop.org/show_bug.cgi?id=85531 also affects you ? Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-

[libreoffice-users] Re: LO and Java 8u25

2014-10-22 Thread Alexander Thurgood
Le 22/10/2014 16:45, Alain Andrieux a écrit : You need to download and install : JavaForOSX2014-001.dmg as well. Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines +

[libreoffice-users] Re: SQLite on OS X

2014-10-17 Thread Alexander Thurgood
Le 15/10/2014 17:42, Hal Vaughan a écrit : Hal, You might have found this out already, but I could only obtain read access to my test sqlite dbs using the jdbc drivers and your sqlite db must exist already before you make the connection, i.e. you can't use LO to create new sqlite dbs. I would we

[libreoffice-users] Re: SQLite on OS X

2014-10-15 Thread Alexander Thurgood
Le 15/10/2014 17:42, Hal Vaughan a écrit : Forgot to add that you will possibly need to tick a couple of boxes in the Advanced Properties dialog, the last two to be precise : Manage primary keys Respect the resultset type for the database driver The last one avoids a unsupported scroll_forward

[libreoffice-users] Re: SQLite on OS X

2014-10-15 Thread Alexander Thurgood
Le 15/10/2014 17:42, Hal Vaughan a écrit : Hal, > I found this link > (https://wiki.openoffice.org/wiki/Documentation/How_Tos/Using_SQLite_With_OpenOffice.org) > about using SQLite with OpenOffice, but I am having trouble finding updated > info about using SQLite with LibreOffice and the link

[libreoffice-users] Re: Open .accdb in--or convert to--.odb in LibreOffice Base?

2014-10-08 Thread Alexander Thurgood
Le 08/10/2014 16:09, Dan Lewis a écrit : Dan, > There is an extension that should help you. Download it from the > LibreOffice Extensions website: > http://extensions.libreoffice.org/extension-center/access2base > This is included by default in official TDF releases of LibreOffice now. A

[libreoffice-users] Re: Question about table icon

2014-10-02 Thread Alexander Thurgood
Le 02/10/2014 14:18, Sophie a écrit : > hum, Alex, after more than 15 years I can't believe that you're a new > user ;-) Ah yes, you could be well be right there, ooops, mea culpa ;-) At least it got the ball rolling ^^ Cheers, Alex -- To unsubscribe e-mail to: users+unsubscr...@global.li

[libreoffice-users] Re: Question about table icon

2014-10-02 Thread Alexander Thurgood
Le 02/10/2014 10:54, Sophie a écrit : Hi Sophie, > Small question to new users, who is aware of the table icon behavior: > Yes, and i really like this feature :-) -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-list

[libreoffice-users] Re: MySQL native connector for OS X

2014-09-22 Thread Alexander Thurgood
Le 22/09/2014 16:53, Dan Lewis a écrit : Hi Dan, > Can MySQL be accessed on an Apple computer using a native > connector? If so, what is the URL for where it is located? If not, how > can it be accessed and the URL for the connector's location? > Answer to your first question : yes Answe

[libreoffice-users] Re: Multiple Forms In HTML

2014-09-19 Thread Alexander Thurgood
Le 19/09/2014 01:07, Hal Vaughan a écrit : Hi Hal, > > Overall, yes as Alex says, LibreOffice, as an HTML editor, is crippled. At > some point I have a question on another issue I want to post relating to the > HTML editor and how converting to HTML can seriously mung the whole layout of > a

[libreoffice-users] Re: Multiple Forms In HTML

2014-09-17 Thread Alexander Thurgood
Le 17/09/2014 18:07, Hal Vaughan a écrit : Hi Hal, > So, with nobody saying there’s a way to do this, I take it that it’s just not > possible to do multiple forms in HTML documents? Probably not, AFAIK even the XML form support is just one page at a time, and the HTML editor in LibreOffice ha

[libreoffice-users] Re: longstanding bugs - what does it take to get them fixed?

2014-09-02 Thread Alexander Thurgood
Le 02/09/2014 10:56, Tom Davies a écrit : Tom, > Such truths are unpopular with "the higher-ups" here and Alex probably got > hassled, off-list, for daring to say it. Alex's answer does tell how to > get the job done, and even hints at a variety of options, but the > "higher-ups" tend to miss th

[libreoffice-users] Re: Converting Microsoft Access to Libre Base

2014-08-13 Thread Alexander Thurgood
Le 13/08/2014 10:55, Peter Goggin a écrit : Hi Peter, > I cannot see how to transfer rhe MS Access to run uder LibreBase. I > tried doing the conversion under XP by loading LibreOffice and then > opening the Access data base using LibreBase. with the following results: All this does unfortunatel

[libreoffice-users] Re: (not) base question

2014-08-08 Thread Alexander Thurgood
Le 08/08/2014 16:10, lunixbox a écrit : > Sorry i was not clear, its more how to set up the search query /form as > i doubt you can go on for 400 points to search. Org question : > What i want using cars as example is to make a search for > color,year,doors,model.kilometers driven,cabrio,engine,fu

[libreoffice-users] Re: Base questions

2014-08-06 Thread Alexander Thurgood
Le 06/08/2014 13:16, Wolfgang Keller a écrit : > The SDBC driver was already there, developed by third-parties. > http://www.openoffice.org/dba/drivers/postgresql/ shows the limitations of the driver at the time the decision to move to hsqldb was made, and they were quite severe. In addition,

[libreoffice-users] Re: the release 4.3 in PPA launchpad

2014-08-06 Thread Alexander Thurgood
Le 05/08/2014 21:24, Tom Davies a écrit : > Thats an interesting list of add-ons/Extensions or additional packages. Is > there any easy clue as to what they do? I personally suspect they do add > something positive to LibreOffice and might consider adding them to my accessodf 0.1-4ubunt

[libreoffice-users] Re: Base questions

2014-08-05 Thread Alexander Thurgood
Le 05/08/2014 12:02, Wolfgang Keller a écrit : > > Bullshit. There are plenty of cross-platform RDBMSes that are not > implemented in this grotesque proprietary abomination that Java is. > My comment, or Sun's decision ? How many of those cross-platform RDBMs were : - available in 2004 (when t

[libreoffice-users] Re: Base questions

2014-08-04 Thread Alexander Thurgood
Le 04/08/2014 16:41, Paul D. Mirowsky a écrit : > Before I begin, I will plead ignorance of how these things really happen. > > It appears that what should be happening is that the database should > always be external, but whether it is placed inside the same folder. > > To the user, the interpre

[libreoffice-users] Re: Base clarity on external internal functionality

2014-08-04 Thread Alexander Thurgood
Le 04/08/2014 17:26, Paul D. Mirowsky a écrit : > It appears that external databases must use SQL to do things and that Base. Not for everything, but your mileage as to what you can get out of LibreOffice's UI varies considerably depending on the db backend. > > Does this mean that the front e

[libreoffice-users] Re: Base questions

2014-08-04 Thread Alexander Thurgood
Le 31/07/2014 21:22, dave boland a écrit : > 2. If they are not that reliable, what is the LO Base procedure to > create a split database? https://forum.openoffice.org/en/forum/viewtopic.php?t=54254 and the tutorial referred to in this post available from the same OpenOffice.org forum. Alex

[libreoffice-users] Re: Base problem

2014-08-04 Thread Alexander Thurgood
Le 04/08/2014 12:57, Yohann Valette a écrit : Hi Yohann, > I have a problem with Base, I created a macro but, if the file location > changes, the macro doesn't work, I wanted to know how to fix this problem > if possible.. > Which file location are you talking about : - the location of the mac

[libreoffice-users] Re: Base questions

2014-08-04 Thread Alexander Thurgood
Le 04/08/2014 16:15, dave boland a écrit : > That is my point. That is why Base needs to make setting up an external > db easy - like when the db is being created. Check one box for the > embedded model, another for the split/external model. Appropriate Help > infornation will be needed. While

[libreoffice-users] Re: Base questions

2014-08-04 Thread Alexander Thurgood
Le 04/08/2014 14:51, dave boland a écrit : Hi Dave, > How does switching to Firebird solve the issue of an embedded, all in > memory database? I would be happy if LO offered an option (when > creating a db) to use embedded model or the split model. > It doesn't, but Firebird wasn't chosen for

[libreoffice-users] Re: Schema in Calc

2014-07-30 Thread Alexander Thurgood
Le 30/07/2014 14:39, Paul a écrit : Unfortunately not trivial to implement because it relies on the driver and the underlying db to tell the truth about what it actually supports, in terms of relations, integrity constraints, etc. As this is problematic for many drivers at the best of times, havi

[libreoffice-users] Re: Schema in Calc

2014-07-30 Thread Alexander Thurgood
Le 30/07/2014 08:37, Pat Brown a écrit : Short answer : no. As Tom has pointed out, this is db design functionality, and not Calc, although nothing is stopping anyone from developing, say, an Addon or Extension that might be able to what you are looking for - certainly not trivial though, given

[libreoffice-users] Re: No database option

2014-07-30 Thread Alexander Thurgood
Le 30/07/2014 19:34, Jim Byrnes a écrit : Hi Jim, > > Just checked with Ubuntu's package manager and Base was in fact not > installed. Used it to install Base and now the option appears so I > should be able to proceed. Sort of surprised as I thought the entire > suite had been installed. Ubun

[libreoffice-users] Re: any working howto for accessing mysql/mariadb from libre office?

2014-07-20 Thread Alexander Thurgood
Le 20/07/2014 15:26, M. Fioretti a écrit : Hi Marco, > server: localhost > Try 127.0.0.1 instead of localhost, just to test > from > http://stackoverflow.com/questions/15827547/java-lang-classnotfoundexceptioncom-mysql-jdbc-driver > > I read that that message means "problem is not in the c

[libreoffice-users] Re: base error - no SDBC drive

2014-07-16 Thread Alexander Thurgood
Le 16/07/2014 13:17, Tom Davies a écrit : > Using an external back-end might get around the Java issue. MySql/MariaDb > and Postgresql don't need java do they? No, using an external backend does not get around the Java issue, if you want to use the built-in Pentaho LO report builder - this is al

[libreoffice-users] Re: Trimming Whitespace on Save

2014-07-16 Thread Alexander Thurgood
Le 16/07/2014 12:03, Ian Prideaux a écrit : Hi Ian, > What do I need to do, so that when I click the Save Record button, the > form automatically strips leading and trailing whitespace from the text > fields. I know that there's a trim function, but I can't figure out how > to tie it into the fo

[libreoffice-users] Re: File corruption on OSX and LO 4252

2014-07-16 Thread Alexander Thurgood
Le 16/07/2014 06:42, Owen Genat a écrit : Hi Owen, > > I would first try to reproduce the error without a USB external storage > device being a factor. I cannot recommend working directly from a USB > device. Ever. The risk of failure (in all contexts) seems to go up > considerably when doing so

[libreoffice-users] Re: File corruption on OSX and LO 4252

2014-07-15 Thread Alexander Thurgood
Le 16/07/2014 05:46, Alexander Thurgood a écrit : Note, that this problem is specific to LO 4252 on OSX, as mentioned in my original post. We are talking about a specific version of LO, on a specific OS, writing to its native format to an externally connected USB disk. Unless people have had the

Re: [libreoffice-users] File corruption on OSX and LO 4252

2014-07-15 Thread Alexander Thurgood
Hi Tom, Le 16/07/2014 00:57, Tom Davies a écrit : > Hi :) > Surely just go back to the last back-up or find a copy in emails or on > a usb-stick. Any chance of it being in a temp folder or auto-backup > or something? > It is corrupt in all of the places where a "backup/autorecovery" should be.

Re: [libreoffice-users] Re: base error - no SDBC drive

2014-07-15 Thread Alexander Thurgood
Hi Tom, Le 16/07/2014 04:28, Tom Cloyd a écrit : > I had it turned off, on the premise (read on the LO list a while back) > that if you didn't need it it was likely to cause problems needlessly. > It appears to be need for Base, at least for the hsqldb. > > I see that this problem is a recurrent

[libreoffice-users] File corruption on OSX and LO 4252

2014-07-15 Thread Alexander Thurgood
I encountered a most infuriating problem today when working with LO on OSX - file corruption when writing to an external disk drive. As I'm often having to work with different machines, and different OSes, I have an external FAT formatted LaCie hard drive to store my files on. This works great on

[libreoffice-users] Re: MySQL-JDBC-Connector

2014-07-08 Thread Alexander Thurgood
Le 04/07/2014 14:13, Heinrich Stöllinger a écrit : Hi Heinrich, Have you tried setting your codepage collation to UTF-8 in at least the driver parameters (you might have to force it too in the table). This vaguely rings a bell with a problem I once had. Alex -- To unsubscribe e-mail to: users

[libreoffice-users] Re: [MariaDB Announce] MariaDB Galera Cluster 10.0.12 GA and MariaDB 10.1.0 Alpha now available

2014-07-08 Thread Alexander Thurgood
Le 05/07/2014 21:55, Charles-H. Schulz a écrit : > HSQLDB has been replaced by Firebird... > No it hasn't, it is still considered, AFAIK, and thankfully so, experimental, and very much a "use at your own risk" option that needs to be specifically activated by the user, or did I miss something in

[libreoffice-users] Re: LOBase - Hyperlinks in Tables

2014-07-08 Thread Alexander Thurgood
Le 06/07/2014 16:36, Pat Brown a écrit : Hi Pat, > I do not see anything like this in Base. Is it possible to create such a > field and could someone please point me to where I could find instructions > on how to do so? 1) There is no such thing in LO Base as a default clickable URL field defin

[libreoffice-users] Re: base error - no SDBC drive

2014-07-08 Thread Alexander Thurgood
Le 06/07/2014 20:08, Tom Cloyd a écrit : Hi Tom, > Build ID: 14ed55896fdfcb93ff437b85c4f3e1923d2b1409, on Kubuntu Linux 14.04. > Check to see whether all of the LO components are installed. By default, 14.04 doesn't install the Base module and additional components. Alex -- To unsubscribe

[libreoffice-users] Re: which version has the best legacy importing?

2014-06-28 Thread Alexander Thurgood
Le 28/06/2014 15:23, Kracked_P_P---webmaster a écrit : > > Any idea which older version of LO would be the best to try? As I have > stated, as soon as I get a working floppy drive installed, then I will > know which legacy format I need to work with. It would be nice to know > which version of

[libreoffice-users] Re: Playing mp4 video's in Libreoffice Windows

2014-06-20 Thread Alexander Thurgood
Le 19/06/2014 12:55, Florian Reisinger a écrit : Hi Florian, > > You need to have the codec installed A VLC integration is planned... > Is it ? My understanding was that it was currently unworkable...did I miss something ? Alex -- To unsubscribe e-mail to: users+unsubscr...@global.li

[libreoffice-users] Re: displaying/editing a table through LO-Base

2014-05-18 Thread Alexander Thurgood
Le 16/05/14 21:26, Heinrich Stoellinger a écrit : Hi Heinrich, How about signing your PK ? Are the PKs in your other tables all unsigned INT ? Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsub

[libreoffice-users] Re: displaying/editing a table through LO-Base

2014-05-17 Thread Alexander Thurgood
Le 16/05/14 21:26, Heinrich Stoellinger a écrit : Hi Heinrich, >anschKosten FIXED (11,2) default 0, /* Anschaffungskosten > in EUR */ >repKosten FIXED (11,2) default 0, /* aufgelaufene > Reparaturkosten in EUR */ >abschreibung FIXED (11,2) default 0, /*

[libreoffice-users] Re: Need help with Base

2014-05-08 Thread Alexander Thurgood
Le 08/05/14 19:01, Wolfgang Keller a écrit : Hi Wolfgang, > The point is how to connect LO to a given, existing schema in a > PostgreSQL database. I take it that schema=myschema doesn't work as a key/value pair ? Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Pr

[libreoffice-users] Re: Generating Address Labels not possible on OS X

2014-05-04 Thread Alexander Thurgood
Le 02/05/14 14:45, Burghard W.V. Britzke a écrit : Hi Burghard, > I am Using LibreOffice 4.2.0.4 with german language on a OSX 10.9.2 box. > I would try either downgrading to 4.1.x or upgrading to a more recent version of 4.2.x. The latest "FRESH" version of LO is 4.2.3 The latest version of

[libreoffice-users] Re: Cannot use GraphicExportFilter from external python script

2014-05-04 Thread Alexander Thurgood
Le 03/05/14 00:11, tvi a écrit : Hi Thomas, Your question is very much dev related. Maybe you should raise it on the dev mailing list or the dev irc channel ? Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists

[libreoffice-users] Re: LibreOffice Base Runtime File

2014-04-27 Thread Alexander Thurgood
Le 27/04/14 03:07, tb a écrit : > > Does LibreOffice Base have a runtime file that would enable me to distribute > an application to users who do not have the full version of Base installed on > their computers? > No. You need a complete LO installation. Alex -- To unsubscribe e-mail

[libreoffice-users] Re: How to insert a field of a random integer in the range 5 to 20?

2014-04-26 Thread Alexander Thurgood
Le 25/04/14 22:37, samz a écrit : Hi, > Hello, > In LibreOffice Writer, how to insert a field of a random integer in the > range 5 to 20? This random integer changes every time I open the document. https://forum.openoffice.org/en/forum/viewtopic.php?f=20&t=16418 will give you a start if you wan

[libreoffice-users] Re: Native MySQL-Connector

2014-04-20 Thread Alexander Thurgood
Le 20/04/14 12:34, Heinrich Stoellinger a écrit : BTW, don't the Apache OpenOffice native connector extensions work for you ? Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guide

[libreoffice-users] Re: Native MySQL-Connector

2014-04-20 Thread Alexander Thurgood
Le 20/04/14 12:34, Heinrich Stoellinger a écrit : Hi Heinrich, > Hello, Does anybody know whether the native MySQL-connector for Windows > will ever > be ported to Linux/Mac-Versions of LO? The Linux distros provide their own version of the connector - well actually, it depends on the distro -

[libreoffice-users] Re: Dragon Medical2 & Libre

2014-04-18 Thread Alexander Thurgood
Le 16/04/14 20:05, Brian A. Colucci a écrit : Hi Brian, > Our one area of concern is with our medical, Open Document Templates. > As the user goes through the template field, using the next field key on > the Powermic2, when they begin to dictate into some of these fields the > text comes out in

[libreoffice-users] Re: Version 10.6.8

2014-04-18 Thread Alexander Thurgood
Le 18/04/14 05:46, tly...@telus.net a écrit : Hi Vivian, > I"m still using Snow Leopard as my favourite program wasn't updated for the > Mac. I've read the requirements for LibreOfice and it states that it is for > Snow Leopard and up. But I've downloaded it and when I try to open the app I >

[libreoffice-users] Re: Heartbleed

2014-04-18 Thread Alexander Thurgood
Le 18/04/14 11:59, Tanstaafl a écrit : > But again... in what way does Libreoffice utilize TCP/UDP connectivity? > What am I missing? Does it have a hidden built-in SSL client? > Errmm, when it is used in server (headless) mode and accepts connections ? I don't know whether this allows for SSL

[libreoffice-users] Re: Bullets & Numbering

2014-03-22 Thread Alexander Thurgood
Le 22/03/14 10:07, A a écrit : Hi, > I've tried various things, none of them will give me the above > structure. It refuses to "number" item 1h (or anything thereafter) > properly. Kevin, I read your article 2 and 3 which are very > informative. But I'm still unable to get it to behave. It wi

[libreoffice-users] Re: Connect Base to External HSQLDB

2014-02-08 Thread Alexander Thurgood
Le 08/02/14 15:07, Jean-Francois Nifenecker a écrit : Hi Jean-François, all : Having just re-tested with Mac OSX Mavericks, LO 4.2.0.3 and hsqldb 2.2.8, I was able to get this to work :-) Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffi

[libreoffice-users] Re: 2 things: Base and captcha

2013-11-27 Thread Alexander Thurgood
Le 27/11/13 21:38, Bob Muir a écrit : Hi Bob, > 1. > I am new to the field of data base and to LibreBase. > I need to get help (ask questions), but I do not find it easy to do via your > websites. > I went to http://ask.libreoffice.org/en/account/signin/?next=/en/ and try to > sign in, but get

[libreoffice-users] Re: Base; Setting up relations between tables

2013-11-27 Thread Alexander Thurgood
Le 27/11/13 15:24, Scott Castaline a écrit : Hi Scott, > What am I not doing? I'm thinking of changing one other field this way > and was doing this one to figure out doing it. From your description, it sounds like you have not set the correct bound field in the properties of your Combobox on yo

[libreoffice-users] Re: BASE refuse TIMESTAMPDIFF syntax

2013-11-19 Thread Alexander Thurgood
Le 19/11/13 10:23, polch a écrit : Hi Paul, According to this : https://forum.openoffice.org/en/forum/viewtopic.php?p=220192 you need to run your query in SQL Direct mode. Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-he

[libreoffice-users] Re: BASE refuse TIMESTAMPDIFF syntax

2013-11-19 Thread Alexander Thurgood
Le 19/11/13 10:23, polch a écrit : Hi Paul, It might help us a bit more if we knew which db engine you were using ? Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines +

[libreoffice-users] Re: Base; Setting up relations between tables

2013-11-17 Thread Alexander Thurgood
Le 17/11/13 06:32, Scott Castaline a écrit : Hi Scott, > So how would I do that in the graphical tool? I can't seem to get it to > work. I vaguely remember working with foreign keys and the sql statement > would refer to AlbumID from the parent as Album.AlbumID for both tables. > Wouldn't I also

[libreoffice-users] Re: Postgres and Calc

2013-11-12 Thread Alexander Thurgood
Le 11/11/13 14:59, Duncan Adams a écrit : Hi Duncan, > I am attempting to connect a query such as > select quantity from item_table where location_id = 1 and item_id = 1 > and owner_id = 1 > to a Libreoffice Calc cell for instance sheet1.d7 I don't see how you can do this absent the use of

[libreoffice-users] Re: Engaging users: initial results of the survey

2013-11-12 Thread Alexander Thurgood
Le 11/11/13 12:19, Charles-H. Schulz a écrit : Hi Charles, > Next time I'm sure you can join us in the weeks during which we > discussed the survey on the marketing and project's list :-) >> Gladly, but the main reason I'm not on, or only rarely follow, the marketing list, is because of what I

[libreoffice-users] Re: How can I create a database with grams and onzes

2013-10-30 Thread Alexander Thurgood
Le 30/10/13 05:30, carondelet moreno a écrit : > please send me details how can I create a databese using measurements, for > example, grams, onzes, etc. > Thanks Well those are units, but the database, I assume, will be storing integers, or even doubles, decimals or float values depending on you

[libreoffice-users] Re: Base/MySQL use

2013-10-30 Thread Alexander Thurgood
Le 30/10/13 18:03, Taylor Blake a écrit : Hi, > Can I (empty) the database from mySQL workbench, connect base and then > build it from there? Then copy the base file to the other computers so all > the forms and reports are available everywhere. > You can certainly use mysql as your backend a

[libreoffice-users] MySQL Native C Connector Extension for Linux 32, 64 and OSX 64 bit versions of LibreOffice - built against future LO 4.2

2013-10-14 Thread Alexander Thurgood
Just a heads up to let you all know that you know that if you : - can get your hands on a 64bit daily build of LO for OSX (this doesn't seem available anywhere I can find at the moment); - or a 32bit or 64bit Linux daily build ; you might want to try the mysql native C connector extensions I hav

[libreoffice-users] Re: Translating odf files using omegat

2013-09-13 Thread Alexander Thurgood
Le 13/09/13 13:52, Milos Sramek a écrit : Hi, > Since there are several such tags for nearly each sentence, translating > using OmegaT is not possible. I've checked if removing them manually > from the content.xml filed changes anything - no, the document remains > the same. > So, there is a way

[libreoffice-users] Re: the password of Libreoffice

2013-09-12 Thread Alexander Thurgood
Le 11/09/13 09:09, tangchao...@gmail.com a écrit : Hi, > I Forger My password of the Libreoffice file . > Who can tell me how to deal with it ? > Other than a brute force attack, with a massive dictionary of potential strings and something like "john the ripper" or some other such software, th

[libreoffice-users] Re: Address block in Base report

2013-09-12 Thread Alexander Thurgood
Le 10/09/13 19:02, Karen Dinse a écrit : Hi again, > We have created a Base database from Access 2003. One of the reports, based > on a query, is to print labels. The first line is for the name, second line Thinking about it, you would probably be better off using a label template and then usi

[libreoffice-users] Re: Address block in Base report

2013-09-12 Thread Alexander Thurgood
Le 10/09/13 19:02, Karen Dinse a écrit : Hi Karen, > Yes, the report will return a label showing the address or PO box on two > separate lines. However, we would like the PO box to show where the address > line would normally be. Seems like a function should work for this. If > address lin

[libreoffice-users] Re: Incorrect handling of time values in O 4.1.1

2013-09-10 Thread Alexander Thurgood
Le 10/09/13 17:40, Heinrich Stoellinger a écrit : Hi Heinrich, Fernand, > excuse - I thought it was francais (wallon)... > I just downloaded the latest MySQL Native Connector. It has in fact been > compiled only for 4.0. Since the treatment of date/time values has > apparently changed in 4.1, thi

[libreoffice-users] Re: Base: How to Duplicate a Record

2013-09-08 Thread Alexander Thurgood
Le 07/09/13 22:48, John Boyle a écrit : Hi John, > To Alex: How does that apply to Libre Office, or does it still? To the extent that OO Basic and LO Basic are substantially the same, the macro should work. Do note however, that LO4.1 changed the Basic structure for a date compared to what is us

[libreoffice-users] Re: Base: How to Duplicate a Record

2013-09-07 Thread Alexander Thurgood
Le 06/09/13 23:46, T Hopkins a écrit : Hi Tod, > I cannot find a method for duplicating a single record or row in a Base table > or form. I want to create new records that contain data from an existing > record. Any suggestions? > Look up clone / copy a record in Base in the openoffice.org

[libreoffice-users] Re: Base: Automatically Open a Form?

2013-09-07 Thread Alexander Thurgood
Le 06/09/13 23:49, Tod Hopkins a écrit : Hi Tod, > I am looking for a method to automatically opening default form when opening > a Base file. Any ideas? > There is/was an extension that provided a similar, if not identical "button press entry/menu page" - can't remember what it was called no

[libreoffice-users] Re: Ctrl+F Dialog Quirk

2013-09-06 Thread Alexander Thurgood
Le 06/09/13 17:33, CVAlkan a écrit : Hi, It is a known bug. https://bugs.freedesktop.org/show_bug.cgi?id=49853 https://bugs.freedesktop.org/show_bug.cgi?id=47634 One of many known focussing issues on various platforms. Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.

[libreoffice-users] Re: Broken links on api docs page

2013-09-06 Thread Alexander Thurgood
Le 06/09/13 17:02, Jim Byrnes a écrit : Hi Jim, I've read on the dev-list that forcing a reload of the browser cache (perhaps clearing it first) should make the problem go away. Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/ge

[libreoffice-users] Re: Broken links on api docs page

2013-09-06 Thread Alexander Thurgood
Le 06/09/13 17:02, Jim Byrnes a écrit : Hi Jim, > All through out the list, some work and some do not. Yes, I have seen this reported on the French users list too. The API docs were supposed to have been regenerated and updated yesterday to reflect changes in the API that have occurred between

[libreoffice-users] Re: LO Base - Check boxes not working after upgrade??

2013-09-06 Thread Alexander Thurgood
Le 06/09/13 11:36, Ian Whitfield a écrit : > > So how do we, or can we, report it or has it been reported by the French > Group. > https://www.libreoffice.org/get-help/bug/ Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-h

[libreoffice-users] Re: LO Base - Check boxes not working after upgrade??

2013-09-06 Thread Alexander Thurgood
Le 05/09/13 10:47, Ian Whitfield a écrit : Hi Ian, > Has anyone seen this effect or got any idea how to fix it please?? This has also been reported on the French users mailing list. Sounds like a bug to me. Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems

[libreoffice-users] Re: Suggestion: Change the zoom with Ctrl+ Plus(+) and Minus(-) Key shortcuts

2013-09-04 Thread Alexander Thurgood
Le 04/09/13 16:04, Alexander Thurgood a écrit : > > On Mac, this works in Writer/Calc/Draw/Impress (unless of course, you > don't have a mouse, but you can use the touchscreen instead). Forgot to mention that on Mac, we use the Cmd key instead of Ctrl. Alex -- To unsubsc

[libreoffice-users] Re: Weblog extension not working in 4.1?

2013-09-04 Thread Alexander Thurgood
Le 04/09/13 13:28, Tom Davies a écrit : Tom, > The chances are that they will be really happy to hear that people do like > and enjoy using their Extension. If they are able to make time to fix it for > the newer versions of LibreOffice then they are likely to do so. It might > mean they nee

[libreoffice-users] Re: Suggestion: Change the zoom with Ctrl+ Plus(+) and Minus(-) Key shortcuts

2013-09-04 Thread Alexander Thurgood
Le 04/09/13 11:42, logos a écrit : Can you not do this with the Ctrl and mouse scroll wheel forward/backward ? On Mac, this works in Writer/Calc/Draw/Impress (unless of course, you don't have a mouse, but you can use the touchscreen instead). LO Version: 4.1.1.2 Build ID: 7e4286b58adc75a14f6d8

[libreoffice-users] Re: How to show postgresql exception errors in 4.1 Base when using a form?

2013-09-04 Thread Alexander Thurgood
Le 03/09/13 22:29, Roger Nutbeam a écrit : Hi, > I have a form for entering some data. The data is checked using a trigger > function in postgresql. If an exception is raised by the function, nothing > is shown in the form. It just doesn't complete entering the data, i.e. move > to the next row i

[libreoffice-users] Re: Database error

2013-08-30 Thread Alexander Thurgood
Le 29/08/13 11:04, Andreas Kloss a écrit : Hi Andreas, > 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 charact

[libreoffice-users] Re: LO - 4.1.1-report-builder problem

2013-08-30 Thread Alexander Thurgood
Le 30/08/13 11:47, Heinrich Stoellinger a écrit : Hi Heinrich, > Having just installed the released LO 4.1.1 version, I still keep getting > the same error as under 4.1.1-RC2 when trying to run a report based on a > MySQL-Database view (I tend to assume that they are actually the same > anyway?).

[libreoffice-users] Re: Cross Platfrom Support Question

2013-08-26 Thread Alexander Thurgood
Le 24/08/13 11:21, Jay Ridgley a écrit : Hi Jay, > > "there were no regular installation files available and to make another > selection" > > She is running MAC OSX How should she proceed? > There is currently no fully functional mobile version of LibreOffice available for Android or iOS touc

[libreoffice-users] Re: Problem with definite integral

2013-08-21 Thread Alexander Thurgood
Le 21/08/13 15:15, Alexander Thurgood a écrit : Or alternatively : int_1^infty() Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http

[libreoffice-users] Re: Problem with definite integral

2013-08-21 Thread Alexander Thurgood
Le 21/08/13 11:40, Uwe Dippel a écrit : Hi Uwe, > I have yet to find a nice way to draw the vertical line that is usually > used in solving definite integrals; the one where one writes upper and > lower limits as sub and sup. > Can anyone suggest anything better than "|" which comes out looking

[libreoffice-users] Re: SQLException when using ADO driver and prepared statements

2013-08-21 Thread Alexander Thurgood
Le 21/08/13 13:35, mhaverin a écrit : Hi, > I tried that. The only difference when the "Run SQL command directly" button > is on is that I don't get the Parameter Input dialog. The errors stay the > same. Sounds like bug submission time then ;-) Alex -- To unsubscribe e-mail to: users+unsu

[libreoffice-users] Re: SQLException when using ADO driver and prepared statements

2013-08-21 Thread Alexander Thurgood
Le 20/08/13 07:54, mhaverin a écrit : Hi, > It doesn't seem to work. I tried SELECT "col1" FROM "tbl1" WHERE "col2" = :x > and just got a bunch of errors (listed below). I did some googling already > but didn't find anything yet. I have some actual work that has to be done so > I'm going to hav

[libreoffice-users] Re: SQLException when using ADO driver and prepared statements

2013-08-19 Thread Alexander Thurgood
Le 19/08/13 14:30, mhaverin a écrit : Hi, > DatabaseContext = createUnoService("com.sun.star.comp.sdbc.ado.ODriver") > Connection = DatabaseContext.connect("sdbc:ado:PROVIDER=sqloledb;DATA > SOURCE=myserver;INITIAL CATALOG=mydb;USER ID=user;PASSWORD=pwd", flatProp()) > Statement = Connection.pre

<    1   2   3   4   5   6   7   8   9   >