Re: [libreoffice-users] definition of flat/relational database

2013-03-03 Thread Mark Stanton
;) Regards Mark Stanton -- For unsubscribe instructions e-mail to: users+h...@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

Re: [libreoffice-users] definition of flat/relational database

2013-03-04 Thread Mark Stanton
application environment imnvho. Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette

Re: [libreoffice-users] Fill Writer document with MySQL Query.

2013-03-04 Thread Mark Stanton
the mailmerge and step something-or-other (four?) gives you opportunity to save your results, save the mailmerged result as separate Writer documents. Simples! Regards Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org

Re: [libreoffice-users] definition of flat/relational database

2013-03-06 Thread Mark Stanton
, but also because, at least in the beginning, many databases didn't store their data in operating-system-recognisable files. So, my suggestion is to remove the term flat file and instead refer to calls to a relational database system engine or direct file manipulation. Regards Mark Stanton

Re: [libreoffice-users] Base stuck in Read Only mode??

2013-03-27 Thread Mark Stanton
The usual reason for Base being in read only mode is not having defined a primary key for your tables. Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how

Re: [libreoffice-users] Base stuck in Read Only mode??

2013-03-27 Thread Mark Stanton
. Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@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

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

2013-05-10 Thread Mark Stanton
How are we to see this thread in the marketing list Tom? Just joining the list won't give it, will it? Regards Mark Stanton One small step for mankind... -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how

[libreoffice-users] Calc bug?

2013-07-11 Thread Mark Stanton
. Checking actions to write this message pretty much confirms it for me. Or have I made a mistake? Regards Mark Stanton One small step for mankind... -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe

Re: [libreoffice-users] HSLQLDB syntax

2013-07-14 Thread Mark Stanton
Google When you spell it right, with just those two words you'll get, if it's the same as for me, 116k hits. Mark Stanton One small step for mankind... -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how

Re: [libreoffice-users] eastern font in new version

2013-08-02 Thread Mark Stanton
All quiet on the eastern font, then... :-) Mark -- 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:

Re: [libreoffice-users] Uninstall Anaphraseus (LibO 3.6 on Mac)

2012-07-23 Thread Mark Stanton
Anaphraseus not working? It *seems* to be working here, but that might be because I'm not sure what to expect from it. I, too, get the complaint on closing a document (which I've reported to the author), but it doesn't seem to cause a problem, does it? Regards Mark Stanton One small step

Re: [libreoffice-users] SQL statement in Base query

2012-07-24 Thread Mark Stanton
In article 500ea6e8.4030...@gmail.com, Jay Lozier wrote: Actually most users of different backend db will be familiar with the SQL version of that backend. What users need are two things: a connector between Base and the backend and instructions on connecting to that backend. The problem is,

Re: [libreoffice-users] Other SQL question as it affects Base

2012-07-29 Thread Mark Stanton
Keys are intended for the internal workings of the database, they are not meant to be used like this. What you want is the WHERE clause, or occasionally the HAVING clause, matching or excluding rows based on their data. Keys are NOT data and should not be used as such. Regards Mark Stanton

[libreoffice-users] BASE SQL problem

2012-07-29 Thread Mark Stanton
BASE's pre-processing, of MySQL at least, prevents the perfectly legal SQL field specifier field1 = field2 AS ConditionName Does it really need to pre-process, or is this more a shortcoming of its pre-processing? Regards Mark -- For unsubscribe instructions e-mail to:

Re: [libreoffice-users] BASE SQL problem

2012-07-29 Thread Mark Stanton
Hi! It works when you turn off the parser (direct SQL mode) but then you don't have an editable record set anymore. Ah yes, silly me. Because it complained that it had to use SQL view I assumed it was in SQL mode, it wasn't. Yes, selecting SQL mode got it to work, but only in a (too)

Re: [libreoffice-users] Other SQL question as it affects Base

2012-07-30 Thread Mark Stanton
As far as I remember it's explicitly stated in the SQL definitions Id fields should not contain data entered by users You can't rely on them not least because often they're automatically generated by the system. They bear no necessary relationship to the data. Mark -- For unsubscribe

Re: [libreoffice-users] Other SQL question as it affects Base

2012-07-30 Thread Mark Stanton
Ok, this is, then, quite an interesting idea. The problem is that you've got nothing reliable in your data to relate one date to the next (by the looks of it). You're only taking readings at roughly monthly intervals. A good, purely SQL, solution to this would be to code a stored procedure

Re: [libreoffice-users] Other SQL question as it affects Base

2012-07-31 Thread Mark Stanton
I'm listening very closely. Your strategy is based on the assumption that consecutive readings have consecutive primary keys. Not even just being in the right order, they have to be consecutive integers for your strategy to work. This elevates the primary key from internal workings to data.

Re: [libreoffice-users] Cannot access my database file!

2012-08-25 Thread Mark Stanton
. Store names of files not the files themselves. You can get trouser pockets big enough for beach balls, but it's not a great idea. Regards Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org

[libreoffice-users] Mailmerge from query broken in 3.4.6?

2012-09-28 Thread Mark Stanton
the same one) that isn't even in the result set... This is very peculiar. Is this is a known issue? Surely not. Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how

[libreoffice-users] Re: Mailmerge from query broken in 3.4.6?

2012-09-28 Thread Mark Stanton
finding similar things? Regards Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org

Re: [libreoffice-users] Mailmerge from query broken in 3.4.6?

2012-09-28 Thread Mark Stanton
Hi Dan, The only language I'm aware of that has a difference between single and double quotes is PHP, and that's only between what it does with strings rather than whether it recognises them as strings or not. I expect there will be some, my preference is single to reduce screen clutter.

Re: [libreoffice-users] Mailmerge from query broken in 3.4.6?

2012-09-28 Thread Mark Stanton
If we're not a database, and we're not a mailmerge engine, we're running out of functionality... :-s I've managed to get it doing this non-trivial task without error, so I'm fairly pleased. I haven't got the pinpoint accuracy requirement, so I don't know if it's playing me about there.

Re: [libreoffice-users] Mailmerge from query broken in 3.4.6?

2012-09-28 Thread Mark Stanton
, which *may* be new since I last ran this query, so it might be Java causing the problem. It'll get to the top of my todo list eventually ;-) Mark Stanton One small step for mankind... SELECT LTRIM( CONCAT( `people`.`Title`, ' ', LTRIM( `people`.`Firstname` ), ' ', LTRIM( `people

Re: [libreoffice-users] Mailmerge from query broken in 3.4.6?

2012-09-29 Thread Mark Stanton
Thanks Don, I'll have a scout about. Regards Mark -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List

[libreoffice-users] Import XML files?

2012-10-03 Thread Mark Stanton
/About_Import_and_Export_Filters) suggests it ought to be doable but gives no details whatsoever. Anyone got any pointers I could use? Regars Mark Stanton -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe

Re: [libreoffice-users] documentation for LO base

2012-10-04 Thread Mark Stanton
As well as existing guides by Andrew Pitonyak and others. Mark -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette

Re: [libreoffice-users] Import XML files?

2012-10-04 Thread Mark Stanton
Have you tried with a recent release of LibO? 3.4.6 is pretty old It's the current release from the Fedora repo. Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing

Re: [libreoffice-users] Update SQL does nothing using Run SQL directly button

2012-10-04 Thread Mark Stanton
subsidiary data from it, don't store subsidiary data. Regards Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http

Re: [libreoffice-users] Import XML files?

2012-10-04 Thread Mark Stanton
Thanks for that Steve. It looks like this is saying that OO/LO needs a specific template for a specific input, is that the case? I hope not, XML is supposed to be a self defining file format surely? A general importer ought to be easy, no? Regards Mark Stanton One small step for mankind

Re: [libreoffice-users] Import XML files?

2012-10-04 Thread Mark Stanton
Ok, I'll put it on the list. Visual FoxPro (for example) has a built in function, XMLTOCURSOR, which takes a string or filename and produces a table. Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http

Re: [libreoffice-users] documentation for LO base

2012-10-04 Thread Mark Stanton
Question: How many people do you know use Base, or have tried to use Base? Whilst there is some quite valid criticism of Base, I don't think answering this question says as much about Base as it does about the general usage of databases. They are less familiar than word processors,

Re: [libreoffice-users] Base - need to re-point a form

2012-10-18 Thread Mark Stanton
presumably thems who are administering the MySQL have set something. Often the reason for having read only access through Base is that the table in question doesn't have a primary key defined, but if you've had write access before and nothing else has changed that would be unlikely. Regards Mark

Re: [libreoffice-users] Cannot add primary key after saving without primary key.

2012-10-23 Thread Mark Stanton
shouldn't allow table creation without it. Regards Mark Stanton -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List

Re: [libreoffice-users] Base Form behavior.

2012-12-06 Thread Mark Stanton
my way toward the end It should (?) be easy to find the number of rows without having a big time consuming operation to do it, database engine APIs often provide a function for this. Yes, please put in a change request. Regards Mark Stanton One small step for mankind... -- For unsubscribe

Re: [libreoffice-users] Base Compact and Shutdown

2012-12-31 Thread Mark Stanton
. It's the difference between an embedded database file and a database engine. MySQL is a database engine. You only need to send it requests and get answers back from it. Otherwise it does all its own housekeeping and management. You don't tell it to compact its data. Regards Mark Stanton

Re: [libreoffice-users] Base Report Builder

2013-01-21 Thread Mark Stanton
with AOO/LO that is one of the root causes of many of the problems that users experience. Isn't hsqldb *still* a (relatively) good choice, as long as it is installed and used *external* to Base? That does of course mean it's still not the default setting. Regards Mark Stanton

Re: [libreoffice-users] Base Report Builder

2013-01-27 Thread Mark Stanton
not be hugely difficult. It's possible, of course, that there will be some little niggling problems that need to be resolved manually, but it's possible that the move can go relatively smoothly and easily. Regards Mark Stanton -- For unsubscribe instructions e-mail to: users+h

Re: [libreoffice-users] Development of Extensions for LibreOffice

2013-02-04 Thread Mark Stanton
Qt isn't a programming language Tom, it's a UI framework (written in C++). Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting

Re: [libreoffice-users] MariaDB 5.5.33 Now Available

2013-09-19 Thread Mark Stanton
Fedora has also switched. Mark Stanton One small step for mankind... -- 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

[libreoffice-users] Good mailmerge, well done mailmerge... Errr, not quite

2014-01-31 Thread Mark Stanton
something wrong? Regards Mark Stanton One small step for mankind... -- 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

Re: [libreoffice-users] Good mailmerge, well done mailmerge... Errr, not quite

2014-02-01 Thread Mark Stanton
) 223 rows. This is LO 4.1.4.2 under Fedora 19 x86_64 Mark Stanton One small step for mankind... -- 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

Re: [libreoffice-users] Good mailmerge, well done mailmerge... Errr, not quite

2014-02-02 Thread Mark Stanton
Doh! I meant, of course, only the first sheet was *portrait* all the others were, correctly, *landscape*. Regards Mark -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines +

Re: [libreoffice-users] Good mailmerge, well done mailmerge... Errr, not quite

2014-02-04 Thread Mark Stanton
, surely, indicates a bug. Doncha think? Sounds like no-one else has come across this behaviour though. Regards Mark Stanton One small step for mankind... -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how

Re: [libreoffice-users] Company Move: Need to Know

2014-04-03 Thread Mark Stanton
Hi Sqwuiddy, I think you'd be best hiring someone in for a few days to help you with this. There are several questions that need answers to help further. In general you should be ok on many of these things, I'm not certain about all of them. Nested IF statements do work. Where is the data

Re: [libreoffice-users] RTF support

2011-07-01 Thread Mark Stanton
I don't (entirely) disagree with you on the dirty trick front. But what an interesting world we live in when an unpleasantly dirty trick like that is seen as a legitimate tool... Mark Stanton One small step for mankind... -- Unsubscribe instructions: E-mail to users+h

[libreoffice-users] Given up spellchecking?

2011-07-22 Thread Mark Stanton
as English (USA), however many times I set it to English (UK). This is LO 3.3.2, under Fedora (15). It was working until very recently. A large proportion of KDE has updated in the last couple of days, but I don't see that this should have a bearing on this part of LO. Any ideas? Regards Mark

Re: [libreoffice-users] Given up spellchecking?

2011-07-23 Thread Mark Stanton
it back? I've been wandering around the filesystem looking for something that sounds like spelling, but I can't find it. The edit option on that dialogue edits the available modules. Those are the ones that insist in being in English (US) even when I change them to English (UK). ? Regards Mark

Re: [libreoffice-users] Given up spellchecking?

2011-07-25 Thread Mark Stanton
screen-shots that way in case they look completely different from yours. Nope, not got that. Im haste Mark Stanton One small step for mankind... -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe

[libreoffice-users] Re: Footnote page space (Writer)

2011-08-02 Thread Mark Stanton
good. I don't mind it not suppling what I want, it is after all a little unusual (I'm trying to mimic the layout of the nineteenth century book that the text comes from), but LO suggests that it will do what I want while clear refusing to do it. :-( Mark Stanton One small step for mankind

Re: [libreoffice-users] Given up spellchecking?

2011-08-03 Thread Mark Stanton
to it when I've got some time free (hah!). If the next Fedora repository update doesn't clear it up, maybe I'll just remove it completely and reinstall to see if that'll do it. :-( Thanks Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h

Re: [libreoffice-users] Footnote page space (Writer)

2011-08-03 Thread Mark Stanton
to footnote contents is a paltry 0.04 ? Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org

Re: [libreoffice-users] LibreOffice 3.4.2 Spellcheck Not Working....

2011-08-12 Thread Mark Stanton
Not working here. LO 3.3.3, Fedora 15 (Linux) Mark Stanton -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List

Re: [libreoffice-users] installing issues fedora 14

2011-08-14 Thread Mark Stanton
new to Linux too and tried to install LO by downloading the file from the LO website and installing that, I have some problems now because of it (perhaps), so I'd recommend the F15 - LO route. Best regards Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail

Re: [libreoffice-users] LibreOffice-Base CPU usage

2011-09-18 Thread Mark Stanton
, at least inasmuch as it only has one set of options for some things, like using Java. It looks to me like these options are stored at the user level so he could set up a second user, bit of a nuisance but that could do it I think. Mark Stanton One small step for mankind

Re: [libreoffice-users] Base - using external database tables

2011-10-13 Thread Mark Stanton
files since the concept doesn't help very much in most of the context of what you want to do. As a last note, I'm using a MySQL backend under Fedora and no, it's not fast. I'll look into why, but I wonder if it's the JSQL interface too. Regards Mark Stanton One small step for mankind

Re: [libreoffice-users] Base slowness and Java update

2011-10-14 Thread Mark Stanton
I think you will find that most of the industry, and nearly all of the open source community will be very unlikely to believe what Oracle says on this subject. It would be wise to consider that they may have a point. Mark Stanton One small step for mankind... -- For unsubscribe

Re: [libreoffice-users] Base: creating a dropdown field form

2011-10-29 Thread Mark Stanton
with it. If it isn't in your data, even if you type it in manually, how are you going to use it? At a wild guess, you've got codes in your data representing these categories. If that's the case, create a lookup table and put your code/text correspondences in there. Or have I guessed wrong? Mark

Re: [libreoffice-users] testing out 2 new large word list English dictionaries.

2011-11-02 Thread Mark Stanton
So, since I do actually use my Writer setup in my business, is it going to be easy to revert to my current working dictionary/thesaurus if I want? Regards Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http

Re: [libreoffice-users] testing out 2 new large word list English dictionaries.

2011-11-06 Thread Mark Stanton
Sorry to hear you (?) have been ill. I think you'll find Brian was just pulling your leg about your use of English, rather than asking you anything about specific word counts. Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h

Re: [libreoffice-users] 98, 000+ word list British dictionary, hyphen, thesaurus dictionary

2011-11-08 Thread Mark Stanton
I'd be happy to have the largest list you can comfortably make. Will it be easy to switch between them if I need or want to? Best regards Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http

Re: [libreoffice-users] Changing date on a chart

2011-12-09 Thread Mark Stanton
Use a database. Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List

Re: [libreoffice-users] Changing data on a chart

2011-12-11 Thread Mark Stanton
, and then you're back into familiar territory. Sorry, it's a pet peeve of mine, using a spreadsheet as a database. Don't mind me, just getting grumpy :-( Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http

Re: [libreoffice-users] Base can't open databases

2011-12-14 Thread Mark Stanton
actually store that data in the .odb file. Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http

Re: [libreoffice-users] Base can't open databases

2011-12-14 Thread Mark Stanton
aren't required by small applications. Hence it's a small, fast database, without it's own data storage, I imagine, since the data for it *is* kept in the odb file. I hope someone will correct me if I'm wrong in the technical details here. Regards Mark Stanton One small step for mankind

Re: [libreoffice-users] Base can't open databases

2011-12-15 Thread Mark Stanton
Hi Alex, Hmm, I wouldn't say cut down, it is actually rather good, I understand that it *is* good. As I understand it the cut-down-ness contributes to the good-ness, or at least that was part of the design goal. Mark Stanton One small step for mankind... -- For unsubscribe instructions

Re: [libreoffice-users] Base/SQL help

2012-01-03 Thread Mark Stanton
The SQL is something like SELECT TOP 2 * FROM yourtable ORDER BY counter, DESC WHERE ip = selected ip depending, as Jay says, on your SQL engine. Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems

Re: [libreoffice-users] Multiple select field in Base forms

2012-01-13 Thread Mark Stanton
Hi Marni, I think that what you are wanting should be doable, but you're not clear enough for me to be more helpful. Can you give a clear example of what you want to do and then perhaps I/we can help you out better. Regards Mark Stanton One small step for mankind... -- For unsubscribe

Re: [libreoffice-users] Multiple select field in Base forms

2012-01-14 Thread Mark Stanton
me to it, I'll have a stab at it later (I'm also a musician, so that might help :-) ) Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting

Re: [libreoffice-users] Multiple select field in Base forms

2012-01-15 Thread Mark Stanton
of music. Entirely resist the thought that some things are so fixed (seasons, for example) that you don't need a table and you can hard code them. Next thing you know you'll be up on a high place being shown all the peoples of the earth. Does that do it? Mark Stanton One small step for mankind

Re: [libreoffice-users] UNSUBSCRIBE

2012-01-20 Thread Mark Stanton
not very keen on them for the same reasons that Brad puts forward), I'm just reiterating that they REALLY are very different in the way one interacts with them. Regards Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org

[libreoffice-users] Base question - report exception on faultless query

2012-01-26 Thread Mark Stanton
speaking an error I s'pose), and two errors that both say Syntax error in SQL expression. What SQL expression would that be then? Since my query runs correctly? Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems

Re: [libreoffice-users] Base question - report exception on faultless query

2012-01-27 Thread Mark Stanton
function, although LTRIM is recognised. Again this is with Analyze set to NO. This seems incorrect to me. However, this has resolved the issue for me and I can now get it to work. Regards Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h

Re: [libreoffice-users] Base question - report exception on faultless query

2012-01-27 Thread Mark Stanton
. It's originally from my own (Visual FoxPro) application that runs our magazine subscriptions. It's now in transition to LO :-) Regards Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org

[libreoffice-users] Not printing Base fields

2012-01-27 Thread Mark Stanton
text, I mean omit the whole line, so there is no space between name and the first address line. Is this possible with LO Base? Mark Stanton -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how

Re: [libreoffice-users] Not printing Base fields

2012-01-27 Thread Mark Stanton
already been registered for the mailmerge wizard, and then run the mailmerge. Bit of a long way round :-( Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how

Re: [libreoffice-users] Mail Merge print from Query instead of table.

2012-01-27 Thread Mark Stanton
I thought it was better practice to use Queries than Tables to build report/forms/mail-merge from and then print the result? That's his whole point. Mailmerge doesn't appear to be able to use queries. Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail

Re: [libreoffice-users] LO Base - calculating dates

2012-01-28 Thread Mark Stanton
I think (without actually having tried it) that just adding numbers to a date field will do what you want, so your date field+365 should give you the year in advance date Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org

Re: [libreoffice-users] LO Base - calculating dates

2012-01-30 Thread Mark Stanton
Use MySQL with PERIOD_ADD(P,N) to add N months to the date P Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http

Re: [libreoffice-users] create mailmerge with spreadsheet librecalc without using libre base ! pls help how to do it TQ

2012-02-02 Thread Mark Stanton
to mailmerge using a query to supply the data? I know that's what it looks like you said, but there's just been a long thread here that concluded this was not possible, so I'm just checking. If so, is it new (3.4.5) functionality? Regards Mark Stanton One small step for mankind

[libreoffice-users] Mailmerge, working, fairly well, but...

2012-02-05 Thread Mark Stanton
is outside the UK. Since the graphic isn't in a paragraph it looks like that strategy won't work, and I can't see another way of doing it at the moment. Macros? TIA Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems

Re: [libreoffice-users] Mailmerge, working, fairly well, but...

2012-02-07 Thread Mark Stanton
Thanks Fernand, I'll go look. Regards Mark -- For unsubscribe instructions e-mail to: users+h...@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:

Re: [libreoffice-users] Mailmerge, working, fairly well, but...

2012-02-09 Thread Mark Stanton
Yup, same here. I found nice manuals, but all just basic ones (not Basic), and no macros. The forum post looks like it's got some useful ones, but no conditional pictures, unless I missed that. Regards, and thanks Mark Stanton One small step for mankind... -- For unsubscribe instructions e

Re: [libreoffice-users] Mailmerge, working, fairly well, but...

2012-02-09 Thread Mark Stanton
The thing that started this thread though was my need for conditional pictures. Can that be done without macros? Regards Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help

Re: [libreoffice-users] Mailmerge, working, fairly well, but...

2012-02-09 Thread Mark Stanton
of a query it might be just about bearable. What I'd really like is an image control with a conditional display expression. I may try to produce one, but not for a while I think. Regards Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h

Re: [libreoffice-users] Mailmerge, working, fairly well, but...

2012-02-09 Thread Mark Stanton
(one paragraph up or down), but I also don't care about such trivia. Regards Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines

Re: [libreoffice-users] Mailmerge, working, fairly well, but...

2012-02-09 Thread Mark Stanton
, and y'all seem to be saying that hiding or showing the paragraph that the anchor is in will hide or show the picture anchored to it. If that's right, then that is my solution. It would be much nicer to have an image field that could be conditionally hidden... Mark Stanton One small step

[libreoffice-users] Tell me it's not true

2012-02-27 Thread Mark Stanton
When I select the dBase connector it seems to say that queries cannot contain more than one table. Tekll me it's not true... Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help

Re: [libreoffice-users] Tell me it's not true

2012-02-28 Thread Mark Stanton
Thanks Andreas, Unfortunately this isn't for a form, it's for a report. Mebbe I'll start having a look at that code, being on Linux you're other suggestion doesn't help me :-( Regards Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h

Re: [libreoffice-users] Tell me it's not true

2012-02-28 Thread Mark Stanton
I'm only talking about the dBase connector. It sounds like there may be more to it than that from Andreas' reply, but I don't think it's anything major to worry about, except the dBase connector :-( I'll have a look Mark Stanton One small step for mankind... -- For unsubscribe instructions

Re: [libreoffice-users] Tell me it's not true

2012-02-28 Thread Mark Stanton
you're saying it's a slightly wider scope than just dBase. Don't hold your breath :-) Regards Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe

Re: [libreoffice-users] Tell me it's not true

2012-02-28 Thread Mark Stanton
Thanks for that Andreas, Hmmm, that document is nearly nine years old, nothing's happened with file based database access since then? Ok, might as well start at the deep end I suppose. Any pointers gratefully received, and in the meantime I'll start digging. Mark Stanton One small step

Re: [libreoffice-users] Tell me it's not true

2012-02-29 Thread Mark Stanton
level not the table level, is that right? Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http

Re: [libreoffice-users] Tell me it's not true

2012-02-29 Thread Mark Stanton
perhaps able to include some aspects of the spreadsheet paradigm to data manipulation. That's an interesting thought. What sorts of aspects do you have in mind? Mark Stanton -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org

[libreoffice-users] Re: Parameterised query

2012-02-29 Thread Mark Stanton
B*m! :-( Fixed it. Wrong SQL mode selected, it seems. Sorry. Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more

Re: [libreoffice-users] Tell me it's not true

2012-02-29 Thread Mark Stanton
Yes - It's one at a time. Hmm, a shame but plausible. And HSQL seems to require index names to be unique at the database level not the table level, is that right? Yes. Isn't that a little... Non-standard? Mark Stanton One small step for mankind... -- For unsubscribe instructions

Re: [libreoffice-users] Tell me it's not true

2012-02-29 Thread Mark Stanton
table. I can't do that in HSQL. I know there's an idea that index names should include table names, which would completely eradicate the issue, it's just that I don't agree :-) It's a (perhaps) interesting discussion point rather than a problem though. Thanks for the info Mark Stanton One small

Re: [libreoffice-users] Tell me it's not true

2012-02-29 Thread Mark Stanton
@Mark Stanton, Would you please visit us at http://user.services.openoffice.org/en/forum/index.php next time? Coo, look at that! A busy Base forum. I really much prefer stuff that arrives in my mailbox, but yes, I will visit there. Thanks (again) Andreas. Mark Stanton One small step

Re: [libreoffice-users] Parameterised query

2012-02-29 Thread Mark Stanton
Hi Fernand, ?Isssue_Num (3s) ? greetz Fernand Thanks, but nope. The name Issue_Num, just identifies a parameter, it doesn't have to match the name of any field. The problem was the wrong SQL mode. Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail

Re: [libreoffice-users] Tell me it's not true

2012-02-29 Thread Mark Stanton
that spreadsheet users sometimes want to make the jump to databases but find it difficult, I'm interested in thoughts about facilities that would help bridge that gap. Particularly as I'm starting to do some Base development... Cheers Mark Stanton One small step for mankind... -- For unsubscribe

  1   2   >