Re: [libreoffice-users] definition of flat/relational database
I think the (incorrect) definition that is being used is whether LO manipulates files directly or talks to a database engine. I don't think there is a dBase or FoxBase engine. I'm pretty sure there is a Visual FoxPro engine (John doesn't mention VFP, whyzatt then? ;) ), however it'll be a Windoze only thing I expect. So, to answer the original question, LO is calling dBase files flat because it can't access a database engine for them and it won't do any engine work itself. A flat database? Errr, can't think of one, although I know there have been such things. You only had to ask ;) 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] definition of flat/relational database
Thank God Linux came arround when it did... I am still waiting for a database program that will allow me to create applications I feel your pain. I was a professional VFP developer and have now moved to Linux and have the same problem. However, I am wondering if the one solid lump approach is the only way to go or if a collection of pieces will do the job as well (or better?) The pieces in Base are actually (potentially) pretty good). I'm hoping to get some time to develop this idea in the not-too-distant future. C, or its derivatives, would be a very poor database 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 List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Fill Writer document with MySQL Query.
Very easy to do. Use Base to map to the data you want. If all the fields aren't one table then create a query that does generate the data you want and save the query. Use the mailmerge facility to create a document and connect to the data you want. Create fields for the data fields. Run 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 Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] definition of flat/relational database
Dan, As I said in my response above, the distinction that LO is making is database engine call or manipulate file directly. If it manipulates files directly it does it with simple, slightly extended, text manipulation. LO has no database functionality itself, for such functions it can only make calls to a database engine (ie another program) when it has anything other than simple single file manipulation to do. DBase (for example) has no engine that LO can call to. Flat file databases are those where there is no ability to relate different tables. In that respect, outside its correct environment, I suppose you could say that dBase files are flat, but that is because of the lack of correct environment rather than any shortcoming in the files themselves. That, I think, points to flat file being a misleading term, not only because it's not just to do with the file, 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 -- 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Base stuck in Read Only mode??
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-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Base stuck in Read Only mode??
In article 5152bfd4.7050...@telkomsa.net, Ian Whitfield wrote: Thanks Mark I think you are right!! I DON'T see a Primary Key!! (I'm sure I DID set it!!) BUT - If I try to set it in Base it does not accept the setting. If I try in MyAdmin to set my first column (RecordID) as Primary I get the error #1062 - Duplicate entry '' for key 'PRIMARY' I can not see any Primary Key in the list of fields So I ran .. SELECT EXISTS( SELECT 1 FROM information_schema.columns WHERE table_schema = 'FedSaintsNew' and table_name='TABLE 2' and column_key = 'PRI' ) As HasPrimaryKey I get HasPrimaryKey 0 What is stopping me setting the key or how do I get round this??!! Hi Ian, Are you saying that phpMyAdmin doesn't show a primary key? But won't let you enter one? That sounds very odd. Personally I would do most of the setup in phpMyAdmin rather than Base. 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Base data-loss and other problems
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-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Calc bug?
I'm not a frequent Calc user, so this might be just plain wrong, however... With a very wide table I can (as is standard in most GUIs) go a page right (or probably left) at a time by clicking in the scrollbar between the end stop and the current position indicator. However, if the column wider than the Calc window, this doesn't work. The cell is placed with its left side at the left of the window and and further page clicking to continue scolling doesn't move the page. The page can be moved by using the arrow at the end of the scrollbar, or by dragging the position indicator. 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/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] HSLQLDB syntax
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-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] eastern font in new version
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: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Uninstall Anaphraseus (LibO 3.6 on Mac)
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 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] SQL statement in Base query
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, I think, that Base does some pre-processing to check the SQL, which causes a problem, particularly in this context (non-standard SQL). Although there are some helpful points to it are there enough? 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: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Other SQL question as it affects Base
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 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] BASE SQL problem
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: 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] BASE SQL problem
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) limited sense. It (my stored query) doesn't work when I call it from a Writer document. Worse than that it doesn't work in a silent, partial, sense! :-( Not very happy about that. I wish they would drop all the pre-processing and the extremely stupid query designer. I think it's REALLY important to have tools like this, so less able people can use more powerful application. However, the tools mustn't stop the more able from using the application. 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: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Other SQL question as it affects Base
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 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Other SQL question as it affects Base
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 that is guaranteed to hand out successive numbers, and then you can use that to do the arithmetic you've done already. You'd want another table that stores the current value of your counter, and your entry data process would get the next number for your next entry and update the table. You could do it by finding the maximum number already allocated in your table and add one (or whatever). If you're prepared to bet the ranch on having one reading every month without fail, you could find the lowest date and then generate an integer singly increasing index on month's since first date. That'd be two more SQL selections. The problem with what you've done is that there's no guarantee that it'll continue to work. It probably will, by the looks of it, but it's only a fortunate side effect of something that is not guaranteed. In a business environment you'd get fired for something like that, and quite rightly! In an amateur environment, you're getting away with it, which might be good enough for you. The next alternative is pulling the data in date order (yes, I know it's almost certainly in date order already, but if you don't make sure then you can never enter historical data [you're sure to miss entry for some reason some day]), and then run through the table doing the sum between last month's data and this month's. Of course, if you do ever enter data out of order the first strategy here won't work, or you'd have to manually reallocate your sequence numbers. 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: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Other SQL question as it affects Base
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. Your strategy is based on the specific values of those numbers. That's not what table primary keys are intended for in the relational database model. As I said in my previous post, it sort of works, and happens to work reliably enough for you in your situation. That's fine. You say you're a mathematician. Does coincidental relationship bear mathematical scrutiny as a general strategy in that context? 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: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Cannot access my database file!
I suspect Dan is saying that memory per object needs to be bigger than the biggest picture you've got in there. For future reference, it's not a good idea to store big binary data, or, imnvho, any binary data, in database tables, certainly not in the hsqldb tables that LO uses as internal. 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/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Mailmerge from query broken in 3.4.6?
Using a mailmerge document that worked fine in the previous version (no, I don't know the number, but very recent, I'm getting updates through the Fedora repos) hardly works at all now. The document is an address sheet with three of images. It uses hidden paragraphs for almost every line, and the images. The data navigator shows the correct data, the result of a query. Mailmerge gets the first line of the address correct, and nothing else. Some fields appear as field names (eg Address1)(yes, I do have View Fieldnames turned off), some fields appear as data from a row (always 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-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Mailmerge from query broken in 3.4.6?
Ok, a little more information, because I've now fixed the problem and have a bit more idea of the scope of the mess, which is huge, I'd say. This mailmerge is linked to a query in a MySQL database. My query couldn't use the query wizard (Andreas won't be surprised). In coding the query I wrote the field names in camelcase (eg Address1, PersonName), the actual database fields are all in lowercase. Changing this made the mailmerge show data. However, the query worked prior to that, and in fact the hidden paragraph conditions worked correctly, even though they were also in camelcase. Interestingly, calculated fields given camelcase names with AS work! Uncalculated fields given names (eg `Address1` AS `Address1`) don't. Interestingly, again, it seems that some conditional statements don't work the way they used to, either. Am I talking complete rubbish here, or are others 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/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Mailmerge from query broken in 3.4.6?
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. I'm certainly not aware that SQL makes any distinction. The query with single quotes, is producing the correct results (as verified against a separate system). I only do this run once every couple of months so I don't rememebr the conversations, but I don't think mailmerge can use a view, can it? Yeah, I've seen what they've done to camelcase. I've not seen any camels with lower case heads... ;-) I can't imagine that the Fedora repo has caused a problem either. 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: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Mailmerge from query broken in 3.4.6?
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. Really it shouldn't accept case-incorrect fieldnames, so at least it's halfway to being good, it's just that that progression broke my code :-( Thanks for the other references too. 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: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Mailmerge from query broken in 3.4.6?
Thanks for that Girvin. In fact my query does have the quotes around field names. I've included it at the bottom here. I haven't noticed any difference between ` (backtick) or either usual type of quotation mark either. I appear to be using the MySQL JDBC driver, com.mysql.jdbc.Driver, 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`.`Surname` ) ) ) AS `PersonName`, `people`.`PersonId`, `issues`.`iId` AS `iiID`, `issues`.`Issue`, `people`.`LastIssue`, `subscription`.`iId` AS `subiId`, `subscription`.`Type`, `subscription`.`AdType`, `subscription`.`Delivery`, `subscription`.`Issues`, `subscription`.`StartingAt`, `address`.`Company` AS `Co`, `Address1` AS `Address1`, `Address2`, `Address3`, `City`, LTRIM( `Area` ) AS `Area`, `Country`, `PostalCode`, `sent`.`iId` AS `SendId`, `sent`.`NumberSent`, LEFT( `textvalues`.`Text`, 1 ) AS `Text`, LastIssue=Issue AND Type=2 AS RenewalDue FROM `people` JOIN `subscription` ON `people`.`iId` = `subscription`.`iPeopleId` JOIN `sent` ON `sent`.`iSubId` = `subscription`.`iId` JOIN `issues` ON `sent`.`iIssueId` = `issues`.`iId` JOIN `address` ON `people`.`iId` = `address`.`iParentId` JOIN `textvalues` ON `textvalues`.`Id` = `subscription`.`Type` WHERE `issues`.`Issue` = '74' AND `sent`.`sent` = 0 AND `Delivery` = 1 AND `textvalues`.`Field` = 'CBOSUBTYPE' ORDER BY `FirstName`, `Surname` -- 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Mailmerge from query broken in 3.4.6?
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 archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Import XML files?
I've got an XML file (I've generated myself, programmatically). I thought it ought to be easy to import it in LO (3.4.6), somehow. I thougth Calc would be a good bet, but it just gives me General I/O error. Base does the same. The website (help.libreoffice.org/Common/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/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] documentation for LO base
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 List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Import XML files?
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-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Update SQL does nothing using Run SQL directly button
And, as a stylistic suggestion, don't use a separate field for transaction year, calculate it from transaction date. The reason is that you've created a new classs of issue for yourself by doing this, keeping two fields in step. In general it's best to store basic data and calculate 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://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Import XML files?
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... -- 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Import XML files?
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://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] documentation for LO base
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, spreadsheets or drawing packages. 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: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Base - need to re-point a form
Is this after you've switched to using a different copy? It sounds like you have had read/write access in the past, is that right? If so, what changed? How do you know it's read only? If your form won't let you change the data it's a local issue, if you can save but it makes no difference 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 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Cannot add primary key after saving without primary key.
Whilst it is recommended that every table should have a primary key field, as far as I know HSQLDB is the only engine to enforce this by refusing to allow changes to tables not having one. I certainly think that the code ought to be fixed so that database engines that require the field 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 archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Base Form behavior.
Hank Alper wrote: I have observed some strange behavior, however,when using the triangular widgets in the navigation bar at the bottom of the forms. For example, when I open a form which maintains tables currently containing 201 records, the navigation bar indicates 1 of 41 records.As I click 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 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Base Compact and Shutdown
Even if it existed, I would be quite surprised if such a thing is necessary for MySQL. Looking through the (5.1) manual, the only references to compact (as a verb) as to do with dumping data and a storage structure option. There is nothing (that I can see) listed for it as a shutdown option. 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 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Base Report Builder
If you really need to rely on your data keeping its coherency and consistency, my advice would be not to use the default hsqldb/ODB pair that is provided as the default. It is a shame really, as hsqldb in itself, certainly in its 2.0 version, is a capable db engine. It is just the integration 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 -- 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Base Report Builder
And to allay your fears a little Hank, the job of moving your *data* to a new back end can be as easy as dragging and dropping tables. Setting up the new back end might introduce you to some new ideas so it might take a little to get your head around it, but once that's done it might 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...@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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Development of Extensions for LibreOffice
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 guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] MariaDB 5.5.33 Now Available
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 List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Good mailmerge, well done mailmerge... Errr, not quite
I was amazed to find that the save document option at the end of the mailmerge will save directly to a pdf file if I put that in as the file extension. Unfortunately, the first page is portrait when all the rest are (correctly) landscape :-( Has anyone else had this problem or have I done 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 archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Good mailmerge, well done mailmerge... Errr, not quite
Err, what settings do you mean? I tried this twice. Both times only the first sheet was landscape, all the others were portrait, which is the layout of the Writer merge document. What settings should I check? It's a mailmerge of a single address sheet with a query that holds (at the moment) 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://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Good mailmerge, well done mailmerge... Errr, not quite
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 + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Good mailmerge, well done mailmerge... Errr, not quite
I think that is what Anne-ology is alluding to. Ah, ok, I didn't know that, thanks. However, the situation is that if I save the output of the mailmerge directly as a pdf (good LO, I didn't know that was a possibility) I get this behaviour, whereas if I save the exact same mailmerge output as an odt document and then save *that* as a pdf, all the pages are, correctly, landscape. It is a single page document that I mailmerge from, tho' I s'pose that could still have a first page options set. However, the fact that there is a difference between the two different save strategies, 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-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Company Move: Need to Know
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 that you're merging? How are you accessing it? It sounds like you know what you're doing with data in general, so it might just be an LO-related issue. Incorrectly accessing that data often results in not merging. When you say none of the merge fields merged, what, precisely, happened? Sorry, I don't have time for more. 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 + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] RTF support
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...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Given up spellchecking?
Writer seems to have stopped spellchecking, even though I have the standard dictionary set correctly (I think, to English -UK), and all the other language options I can find being set correctly, and in fact set the same way as before it (recently) stopped spell checking. A manual spell check finds no errors whatsoever (I've put some in, to make sure), there are no words underlined in red to indicate misspelling, and if I put in an incorrectly spelled word, LO doesn't complain. More than that, each time I access the dialog (sic :-) ) to set the hyphenating, it presents itself 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 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/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Given up spellchecking?
Hi Both (all in fact) This seems to be the crux of it. On my system Ubuntu/Pinguy 11.04, LO 3.4.1) the spell checker is Hundspell. Hunspell isn't appearing in the list of Available language modules, whereas it does on my Windoze setup. It looks like it's been vaped. But how do I get 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 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/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Given up spellchecking?
Hi Tom, Thanks for taking the time with this one. I am sure it's something to do with just settings. There was a thread about it a few months ago. Webmaster at Kracked Press had a good answer but i can't find the thread. I'll have a look. I don't know if this is it but in Tools - Options - LibreOffice - Paths is AutoCorrect set at something like /home/username/.libreoffice/3/user/autocorr Yup. Although there are no files in that directory. Perhaps that's not important. Also in Tools - Options - LibreOffice - Language Settings - Languages there are 4 drop-downs. The top one often reverts to English (USA) I can't get it to say anything else. Where can a reset a language to give me more options for this dropdown? I've reset the locale language in Fedora, that doesn't seem to do it! :-( But i think they all 'should' be on Default - English (UK) ecept currency which 'should' by Default - GBP Default doesn't seem to be an option, they're all countries currencies. Mine is set to GBP. In the top box of the 3 boxes in Tools - Options - LibreOffice - Language Settings - Writing Aids I have Hunspell SpellChecker ticked. This seems to be the crux of it. Hunspell doesn't appear in that box, and I don't see any way to add it, from this dialogue anyway. In the middle box i have 4 dictionaries ticked standard [ALL] soffice [ALL] technical [ALL] IgnoreAllList [ALL] I have added a couple of dictionaries, but I have these you mention too. In the bottom box i have ticked check spelling as you type along with most of the rest of them except Check words with numbers and Hyphenate without inquiry. Yup, pretty much my setup too. I have CC'd the message directly to you in the hope that you get the attached 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/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Footnote page space (Writer)
This obviously really caught the general interest... Not. I've looked a little further, and it seems to be a fixed limit, 9.99 cm maximum space for footnotes, despite the default option when suggests most of the page could be available. I tried changing the display units to inches, in case the spinner in the footnote space dialogue was just limited to one digit before the decimal place and two after it, but no, when the inch is the unit of display the maximum space that can be set for footnotes is three point something, which looks suspiciously like 9.99 centimetres. This isn't very 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... -- 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Given up spellchecking?
I had a look at this and it really is in the too hard category. Loads of files and directories where you mention, just trying to work out which ones should and shouldn't be hanging around was making my head hurt. On the other hand, the speel chucker is quite useful. I'll have apply myself 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...@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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Footnote page space (Writer)
Hi Tom, Err, wot? Never mind, it's very much a document so I'm sticking with Writer. I`m actually using the context menu (right click on the page) and selecting page from there, but it comes to the same dialogue. Ok, a bit more research and some interesting results. Another document, just the default page size (A4, 8.27 x 11.69 inches with 0.79 inch margins all round) has a different, seemingly random, size. The maximum footer size I can put in is 8.01 inches, or 20.36 cm, so at least that dispels the one figure plus two decimal places idea. My real document is set up as 4.53x7.32 (WxH) with margins of 0.65, 0.95, 0.98 and 1.01 (I know, but that`s what the book I`m replicating appears to look like). The largest footnote space I can specify is 3.93. Header is on but not footer. I can`t see anywhere that defines the space the header will occupy. The spacing 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/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] LibreOffice 3.4.2 Spellcheck Not Working....
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 archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] installing issues fedora 14
It might be a good idea to upgrade to Fedora 15. The Live Upgrade does it on the fly, and worked perfectly for me at least. I think you'll find that LibreOffice isn't in the Fedora14 repositories, which will be where your package maanger is looking, but it is in the F15 ones. I'm relatively 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 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] LibreOffice-Base CPU usage
To be clear, Don only needs to have the Java box ticked when opening Base AND using a backend that requires Java, like HSQL. As for your second paragraph, I suspect you meant but opening WRITER won't... ? If so, the answer is probably no. LO isn't a collection of unrelated apps, it's a suite, 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... -- 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Base - using external database tables
I think the simple answer to your question (Is this the same in LO) is yes. But, as others have suggested, it is because you haven't quite got the right way of looking at it. Using a database rather than a spreadsheet allows you to group things according to the content of the data rather than where it is. With a database you can pull out any of subset of your data by selecting a group according to one of it's unique factors, for example select all phone numbers from people in the advanced group (for example) because you have a field in your data for advanced group, not because all those people are in a separate file. I've worked on large databases written by so-called professionals which used tables to separate data, and it is almost always just slower and more complicated than arranging the data better. I'd guess from some of the things you've said in your last mesage that you've read Mariano Casanova's Step by Step guide to Base. It has a very good section on organising data that I think will make your life much easier. In general it looks like Base (either LO or OOO) only accesses one database at a time. You probably want to stop thinking so much about 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... -- 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Base slowness and Java update
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 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Base: creating a dropdown field form
Here is where I think we're getting mixed up. The contents of the combobox. I want the contents of the ComboBox to be Singstar 80s, Singstar 90s, Singstar Amped that's it. I don't want to fill it is the contents of another table or field. I just want to enter in a choices literally. This is the problem I'm having. Very simple situation. If the contents of the combobox isn't a property of your list of tracks/discs/whatever, what use is it? If it's something to do with your data, then it's got to be in your data. If it's in your data, pull it out and populate the combobox 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 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] testing out 2 new large word list English dictionaries.
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://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] testing out 2 new large word list English dictionaries.
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...@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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] 98, 000+ word list British dictionary, hyphen, thesaurus dictionary
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://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Changing date on a chart
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 archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Changing data on a chart
Hi John, I'm aware my answer was a little short, sorry. I've spent most of my time writing databases rather than using LO, which means I don't know about putting a chart on a base document, however the easy way (I'd guess) is to set up a spreadsheet that asks for and pulls the data required, 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://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Base can't open databases
It's hard to think of a situation that would truly benefit from the data being in an odb. Specific database engines manipulate their own data much better than... Almost anything. You can do by extracting the data from your current database and putting it into HSQL. I believe Base does 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://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Base can't open databases
If I'm not mistaken (although I might be and I haven't got the time to go back and check) and odb file is effectively a zip file with various things in it. As Tom said, LO ( Ooo, of course) really doesn't have a database section. It has a gateway to a database, in fact different adapters for various databases. This is really very sensible in most ways. It just talks to a database engine that is specifically built to do the data work and just gives back results. I believe HSQL is a cut down database, on the basis that a lot of the bells and whistles of a full database engine 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... -- 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Base can't open databases
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 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Base/SQL help
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? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Multiple select field in Base forms
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 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Multiple select field in Base forms
Hi Marni, Thanks for that. Still looks a bit vague, but I haven't seen the form yet, I'll have a look later. This is basic database stuff that any database can/should do. The effort of making them do it for end users will be the difference between them. As I said, unless someone else beats 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 guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Multiple select field in Base forms
In general terms, Jay's given you the answer. To be a little more specific, here's an outline. You have a music table. It has columns id (some people would call it musicid), integer will probably be ok title composer arranged publisher name of collection file number (what's this? Is it vital?) Instrument notes (hmmm, probably, if this pertains only and necessarily to a specific piece of music) You have an instrument table. It fields id (those same people would probably call it instrumentid), integer instrument Then, to associate instruments with pieces of music you'd have an instrumentLink table. It's fields are id (instrumentlinkid) integer musicid integer instrumentidinteger Then, when you want to know which instruments are required for a specific piece of music you ask SELECT title, instrument FROM music JOIN instrumentlink ON instrumentlink.musicid = music.id JOIN instrument ON instrument.id = instrumentlink.instrumentid And then similarly for seasons occasions. To come back to what I suspect was the actual thrust of your initial post, I think (think being very operative here) you can have a multi-select dropdown box, so you can scrap the (very untidy) other and additional boxes for instruments. I think you can get LO to handle setting each relevant line in such a dropdown box when the links are already made. I think you'll need to write a little bit of code to crete those links when you're setting up a piece 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... -- 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] UNSUBSCRIBE
Forums usually allow the hard-core mailing-list fans to subscribe to one, many or all threads in the forum so the net result would be about the same for you. It really isn't the same. You've got to go to the forum to see what the conversation is to then subscribe to a thread. All the time. And even if it does email you about messages in a thread, you have to go to the forum to reply, and sometimes to view the message too. A mailing list delivers it all to your own mailbox and then you can have your evil way with it there. I'm not arguing against changing to forums (although I'm 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 Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Base question - report exception on faultless query
I'm trying to produce a report based on a query, trying to being the operative phrase. I have a query, it works just fine. I use the report wizard to produce a report based on the query (I haven't worked out how to do that manually yet). It presents me with the correct fields. I've arranged them the way I want them, at least in a very basic form 'cos I'm still testing. Running the report gives me four errors, SQL status S1000 An error occurred while creating the report, An exception of type com.sun.star.lang.WrappedTargetException was caught. (Alright, that was info, not strictly 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? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Base question - report exception on faultless query
Hi Dan, Thanks for your reply. Yes, it was a bit short on details, but I thought there were enough, obviously not. I had the query set for Do not analyze, which I thought would stop Base from inspecting the SQL, but apparently not. I'm using MySQL via the jDBC... Thingy. In fact the piece it was complaining about was where I was using CAST, incorrectly, to match a text field containing numbers to a numeric field. Funnily enough MySQL by itself was able to cope with this and execute the query correctly, but Base decided to interfere. It also fails to understand the MySQL TRIM 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...@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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Base question - report exception on faultless query
Hi Dan, Ok, here's the query. SELECT CONCAT(people.Title, ' ', LTRIM(people.Firstname), ' ', LTRIM(people.Surname)) AS PersonName, people.PersonId, issues.iId AS iiID, issues.Issue, people.LastIssue, subscription.iId AS subiId, subscription.Type, subscription.AdType, subscription.Delivery, subscription.Issues, subscription.StartingAt, address.Company, Address1, Address2, Address3, City, Area, Country, PostalCode, sent.iId AS SendId, sent.NumberSent, textvalues.Text FROMpeople JOIN subscription ON people.iId = subscription.iPeopleId JOIN sent ON sent.iSubId = subscription.iId JOIN issues ON sent.iIssueId= issues.iId JOIN addressON people.iId = address.iaParentId JOIN textvalues ON textvalues.Id= subscription.Type WHERE issues.Issue = '70' AND textvalues.Field = 'CBOSUBTYPE' ORDER BYFirstName, Surname It's producing an address list of subscribers to the next (here hard-coded as '70', until I find out how to pass a parameter to a query from a report, or at least in conjunction with a report) to print address sheets. 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/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Not printing Base fields
I *want* to omit empty fields from my report. I'm using the report writer to print address labels (sheets really, but it's largely the same thing). I want to print name, company, address lines 1, 2 3, tc. If there's no company name I want the whole line omitted. I don't mean don't print any 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-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Not printing Base fields
Hidden fields are the answer. Ah, yes. But that then puts me in your boat, not being able to mailmerge from a query. I suppose, if the view things turns out not to work, a function/produced/thing could be written that ran the query, exported the results to a csv file with a name that had 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-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Mail Merge print from Query instead of table.
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 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] LO Base - calculating dates
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 Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] LO Base - calculating dates
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://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] create mailmerge with spreadsheet librecalc without using libre base ! pls help how to do it TQ
Wow! Just to be absolutely crystal clear, when you say If you need some fixed filters (for instance all rows where name, zip, city and address are not empty), then you may add a query to the database document and use the query instead of the table. You are saying that it is possible 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... -- 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Mailmerge, working, fairly well, but...
Ok, I've got mailmerge working, fairly well, ish. It seems a little unhelpful that the view field names overrides conditional hidden paragraphs, completely nullifies their effect even on printing it seems. It cetainly should nullify their effect during edit, but not printing imnvho. Anyway, what I need now is conditional hidden graphics according to database field. Not pick a graphic, just show a selected graphic if a database field is a certain value. In case you're wondering, this is so I can print either a first clas stamp image or second, depending whether the address 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? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Mailmerge, working, fairly well, but...
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: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Mailmerge, working, fairly well, but...
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-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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Mailmerge, working, fairly well, but...
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/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Mailmerge, working, fairly well, but...
Hi Fernand, I'm quite happy with the (idea of the) macro solution, I was just interested if there was another simpler/easier one. I really don't want to put images in a table, particularly in this case where the picture is either 'A' or 'B', although I s'pose if I can get it there as a result 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...@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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Mailmerge, working, fairly well, but...
In article 4f342906.5010...@nouenoff.nl, Cor Nouws wrote: If there are few available pictures to choose from, it could work with conditional hidden paragraphs. Only two pictures, a first class stamp or a second class stamp, according to whether the address is outside or inside the UK, so it's very simple in that respect. So, you're saying that I put the anchor point in a paragraph and making the paragraph hidden will hide the picture? If that's right it should be fairly simple. A bit of a nuisance because the two stamps will appear in (very) slightly different places on the page (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 + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Mailmerge, working, fairly well, but...
In article jh1c19$53k$1...@dough.gmane.org, Alex Thurgood wrote: Agreed, but can you set it up to make the paragraph as invisible depending on whether or not you have a varchar string ? No, that's not quite my question. There will *always* be a picture, and it is either a picture of a first class stamp or a second class one. But I want whichever stamp it is to appear in (almost) the same place according to destination (international or domestic). See my answer to Cor below. I had thought the anchor point was outside the paragraph structure, but that appears not to be the case, 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 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Tell me it's not true
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/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Tell me it's not true
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...@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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Tell me it's not true
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 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Tell me it's not true
That'll be a good stopgap, thanks. What I'm trying to do is migrate slowly over from the dBase (VFP really) application that (I wrote that) runs one of our businesses, so just producing output with LO while still using FoxPro would be good. I'll have a look at the code, but it looks like 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/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Tell me it's not true
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 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Tell me it's not true
Create a brand new database (relational, embedded HSQLDB). Drag the table icons from your dBase connection into the new database. Doing this now. It lets me select all tables, but when I drag then it only brings over one :-( And HSQL seems to require index names to be unique at the database 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://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Tell me it's not true
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/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Parameterised query
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: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Tell me it's not true
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 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Tell me it's not true
Hi Drew, Not really...Also, normally one would allow the tool to generate unique index names - for example creating a FK relation will automatically create required indexes, adding a PK to a table also. I'm a little surprised. Although I've got over twenty years of database development experience, it is largely in FoxPro (a dBase improvement), although with a little of a few others. I've not seen, and certainly wouldn't want, an insistence on automatically named indices. And sorry if this is off track - but I just want to be sure that you are referring to index names and not column names Yes, I'm definitely talking about index names. I took up Andreas' idea of importing my dbase-type files into an HSQL LO database. It didn't realise the tables already had primary key fields. I usually call these iId (as integer ID fields), and so want an index (called iId) on each 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 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Tell me it's not true
@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 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Parameterised query
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 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Tell me it's not true
A database component without databases would be as interesting as a spreadsheet without references. That's true, but e-letter was talking about adding spreadsheet-type facilities, not taking away database-type ones. In view of the previous thread, and general experience, suggesting 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 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
