Pergunte aqui

Perfil de lucky67 - atividade

2020-09-09 18:50:57 +0200 Marcada como a melhor resposta Problem with Base split database after upgrading

I've just upgraded to Windows 10 and so upgraded to Libreoffice Version: 5.1.4.2 (Build ID: f99d75f39f1c57ebdd7ffc5f42867c12031db97a) I have a split database - it is relatively new. It was made using the wizard here https://forum.openoffice.org/en/forum.... There is a table in it that is basically just an archive - it was originally in Access 02 -it was a bit of a faff to get it into Base -I can't remember how I did it. And a completely new table which I was using. I was happily entering data using a form into the new table and then decided I needed to make a query. When I opened the queries there were 3 queries already there called Query 1-3. They were about system tables or something - don't think I made them? But I guess I could when I was trying to get the archive table into that file. I deleted them -but I've since got them back. I tried to copy and paste my 'in use' new table -basically just temporarily whilst I faffed with the query - to protect it. I couldn't - it didn't like any of the names I tried to call it. I decided to close without saving. Both table names appear but when I click on them they disappear and I get this message 'integrity constraint violation: unique or index violation; SYSTEM_TABLES table: system:SYSTEM_TABLES The form is still there -when I click on it it says the table doesn't exist... Then when I go back to the table view both tables aren't there... It keeps crashing LO I have another independent split database -with no old tables in and that seems to be fine -no mysterious queries or disappearing tables....

Any advice before I roll back to Libre Office 4 and/or Windows 7?

2020-09-03 06:27:17 +0200 Medalha recebida  Pergunta notável (fonte)
2020-09-02 14:18:12 +0200 Medalha recebida  Pergunta famosa (fonte)
2020-08-29 14:31:24 +0200 Resposta comentada Add a value dependant on day of week in calc

Thank you! This worked perfectly...I was doing lots of 'IF' and getting errors or the wrong value...

2020-08-29 14:31:16 +0200 Medalha recebida  Torcedor (fonte)
2020-08-29 12:39:45 +0200 Perguntou Add a value dependant on day of week in calc

Add a value dependant on day of week in calc I want to be able to add a value to a column that depends on the day of the

2020-08-17 22:49:58 +0200 Marcada como a melhor resposta Libre office mail merge email and gmail/googlemail problem

This is to help anyone else who comes across this problem - I've had a problem for a couple of years now and finally got it working for me again. LO version Version: 6.2.8.2 (x64), Windows 10 Home.

Gmail settings
First make sure access for less secure apps is turned ON in gmail. Even if you have turned it on before, it turns itself OFF every so often so check it is still on before you test/send. (https://myaccount.google.com/lesssecu...) I have both POP and IMAP enabled in gmail anyway -so not sure which you need - think it is IMAP (gmail; settings;forwarding and POP/IMAP)

LO Writer Open a writer doc, then Tools, Options, LO writer, Mail merge emails

Use the exact name you use on your Gmail account

This I think is the important bit Email address - it is important to use @googlemail not @gmail if that the address associated with your google account.

Outgoing server settings - in google IMAP settings it says to use smtp.gmail.com But DON'TIf you have a @googlemail address - use smtp.googlemail.com

Then SSL ticked, port 465 Server authentication - the outgoing mail server requires separate authentication, user name is full google mail address (again @googlemail if that is what your address is) and gmail password.

And hopefully that will work for you too!

Be aware that if you haven't said the server needs authentication and try 'test settings' it will seem to show no problems, but your emails won't send. You need Test settings to show successful network and outgoing server connections after saying server authentication is required.

2020-08-17 22:48:04 +0200 Marcada como a melhor resposta Is it me? Base firebird weird edit table behaviour.

Trying to edit tables in base using firebird is driving me insane. I just wanted to make a few changes to an existing database. Will contain all new data so thought that wouldn't be a problem. Copy the database, delete all the records, add in a few fields to existing tables. Import new data from calc, new form, add in extra data. Done. Not so.
First I know how to work round the error message that the field can't be changed and should it be replaced glitch. (Click yes and nothing seems to happen, close the table and reopen and it will have been deleted) Then you need to add in a new field. (And if you want a field to be a specific place, not at the end for importing data etc you have to use SQL to move the column/field. In the edit table view it doesn't appear to have moved. If you close it and open the table as a data view it has moved,close and open in edit view and it has now moved.
Create primary key when copying a table definition creates a primary key that isn't autogenerated. To get it to be you have to go through the delete and replace the field performance. And sometimes you have exit the file/database all together to see that the changes have been made. This is something I find that I have to keep doing as you can't rename tables in firebird and trying to edit my tables is causing me so much grief I want to retain 'backup' versions and try and retain the table names (have queries set up using them). I did get to a point where I thought I could import the data but then couldn't reinstate my relationships (think because the primary IDS in some of the tables were no longer autogenerated). Then had problems because I was trying to edit tables containing data, so I've had to delete it and go back.
But what is really driving me insane is in edit table view if you select a field and use 'delete' in the box on the left hand side (where you can set a primary key) it deletes the field beneath the one highlighted. At first I didn't realise this was happening - hence me needing to add in more new fields. You can delete by selecting the field text, deleting which seems to leave an empty field - until you close and reopen and it has gone.
Now I've tried to set two adjoining fields as primary keys and one of the fields moved down the field list. Which is going to cause me problems when I try and import the data ...so use SQL to move it back, close the table, reopen etc etc . Please tell me there is an easier way.... thinking maybe using HSQLDB then exporting back to firebird??? or????

Update - having closed down the db ... (more)

2020-08-17 22:47:40 +0200 Marcada como a melhor resposta display list of table properties firebird base

I can find a way of doing this using HSQLDB but not firebird. I think I ideally want an information_schema (?) I found some SQL to do it from a firebird site but it crashed when I tried to run it in LO (under tools, SQL). I found a different query/statement, which did run but it didn't give me the table properties, just the field names of all my tables. I want a text or sql list of the fields and their properties from individual tables. I'm having problems setting up relationships and think something like this might be helpful, help me find out the discrepancies. (also I had the relationships working in another almost identical database so I could compare the information from that with the one I am having problems with.) Thanks

2020-08-17 22:47:12 +0200 Resposta comentada display list of table properties firebird base

Thanks - it worked. (think run SQL directly helped) I'd rather It was text - I can only see it as a table. Also the fi

2020-08-17 21:23:57 +0200 Medalha recebida  Pergunta popular (fonte)
2020-08-17 03:07:57 +0200 Resposta comentada display list of table properties firebird base

Thanks - they seem to be the same as the ones I tried. It was the second one that caused the crash (think it might just

2020-08-17 02:02:22 +0200 Perguntou display list of table properties firebird base

display list of table properties firebird base I can find a way of doing this using HSQLDB but not firebird. I think I i

2020-08-17 01:51:10 +0200 Resposta comentada Is it me? Base firebird weird edit table behaviour.

Thanks! I'll report it as a bug...using your description above. (I think most of my problems are with the display not ac

2020-08-17 01:15:34 +0200 Resposta comentada Is it me? Base firebird weird edit table behaviour.

Thanks again for your answer. Not sure about what you are saying about the wrong field being deleted - although when I d

2020-08-16 07:36:05 +0200 Medalha recebida  Pergunta notável (fonte)
2020-08-16 06:40:12 +0200 Pergunta editada Is it me? Base firebird weird edit table behaviour.

Is it me? Base firebird weird edit table behaviour. Trying to edit tables in base using firebird is driving me insane.

2020-08-16 06:04:42 +0200 Resposta comentada Is it me? Base firebird weird edit table behaviour.

I'll add a further update to my first post to explain a bit better - I was really at the end of my patience - hence the

2020-08-16 05:24:15 +0200 Medalha recebida  Pergunta popular (fonte)
2020-08-15 19:26:22 +0200 Perguntou Is it me? Base firebird weird edit table behaviour.

Is it me? Base firebird weird edit table behaviour. Trying to edit tables in base using firebird is driving me insane.

2020-08-08 16:16:47 +0200 Medalha recebida  Pergunta famosa (fonte)
2020-08-07 11:39:41 +0200 Perguntou Send email 'form' to be edited by recipient via mail merge?

Send email 'form' to be edited by recipient via mail merge? HELP Thought I'd got this worked out and I haven't. And now

2020-06-11 19:43:12 +0200 Medalha recebida  Pergunta notável (fonte)
2020-06-03 14:47:47 +0200 Medalha recebida  Pergunta famosa (fonte)
2020-06-03 14:47:47 +0200 Medalha recebida  Pergunta notável (fonte)
2020-05-28 04:54:02 +0200 Medalha recebida  Pergunta popular (fonte)
2020-05-27 14:51:36 +0200 Respondeu uma pergunta Libre office mail merge email and gmail/googlemail problem

Meant to do this straight away and got distracted ...my question is the answer... Hope this helps someone - since I star

2020-05-27 12:02:20 +0200 Perguntou Libre office mail merge email and gmail/googlemail problem

Libre office mail merge email and gmail/googlemail problem This is to help anyone else who comes across this problem - I

2019-11-21 10:15:31 +0200 Medalha recebida  Patrulheiro (fonte)
2019-11-20 22:44:39 +0200 Medalha recebida  Pergunta notável (fonte)
2019-11-20 12:13:51 +0200 Marcada como a melhor resposta Add Vat to some items but not others in a column...

This isn't desperately important but I am sure there must be a way to do this and if I knew how I think I could use the idea for other things I do. It would be useful knowledge for me to have...

At the moment I have columns with the unit cost, no of units, total exc vat amount, then a 'vat' column containing 1 or 1.2 (1 is for zero rated, 1.2 is for liable for 20% VAT) Then an inc Vat column which is just the total ex vat column multiplied by the Vat column. Which gives the right numbers - it works... However it is easy to read the VAT column as the no of units column. (So 1 unit not 5 etc) I was just going to hide the Vat column -but then it also needs to be obvious whether I thought the item was liable for VAT or not. I could do some background colour or add an additional column containing Zero or 20% for info, not included in any calculations. But I am sure there is a way to do something like =G3 * (if E3 = '20%' 1.2 , if E3 = "Zero" 1)
Is there? C:\fakepath\Temp eg VAT sheet.ods

2019-11-20 12:13:51 +0200 Medalha recebida  Acadêmico (fonte)
2019-11-19 23:43:54 +0200 Pergunta comentada Add Vat to some items but not others in a column...

(test to see if I now get email notifications)

2019-11-19 23:33:43 +0200 Medalha recebida  Pergunta popular (fonte)
2019-11-19 23:23:27 +0200 Medalha recebida  Palpiteiro
2019-11-19 23:07:05 +0200 Pergunta editada Add Vat to some items but not others in a column...

Add Vat to some items but not others in a column... This isn't desperately important but I am sure there must be a way t

2019-11-19 23:01:16 +0200 Pergunta editada Add Vat to some items but not others in a column...

Add Vat to some items but not others in a column... This isn't desperately important but I am sure there must be a way t

2019-10-28 18:32:28 +0200 Medalha recebida  Pergunta popular (fonte)
2019-09-25 19:43:05 +0200 Perguntou Mail merge emails , googlemail - not working

Mail merge emails , googlemail - not working I used to be able to do this - I try again every so often and give up.. I h

2019-08-22 18:52:52 +0200 Medalha recebida  Pergunta famosa (fonte)
2019-06-30 17:15:42 +0200 Resposta comentada Base -HSQL to Firebird migration and disappearing tables/data

And as to having a back up - I do!!! Just had issues restoring the split database from the backup once so try not to use

2019-06-30 17:10:17 +0200 Resposta comentada Base -HSQL to Firebird migration and disappearing tables/data

Ok - thanks For now, for this, I will wait until the issues are ironed out. For the big database I will do as you say wh

2019-06-30 17:02:28 +0200 Resposta comentada Base -HSQL to Firebird migration and disappearing tables/data

Sorry - I did think it was odd as an answer but didn't see a comment bit...if I delete it and put it as a a comment now

2019-06-30 16:52:41 +0200 Respondeu uma pergunta Base -HSQL to Firebird migration and disappearing tables/data

Ok - thanks For now, for this, I will wait until the issues are ironed out. For the big database I will do as you say

2019-06-30 15:58:32 +0200 Medalha recebida  Pergunta notável (fonte)
2019-06-30 10:25:39 +0200 Medalha recebida  Pergunta popular (fonte)
2019-06-30 00:17:26 +0200 Perguntou Base -HSQL to Firebird migration and disappearing tables/data

Base -HSQL to Firebird migration and disappearing tables/data Updated to Version: 6.2.4.2 (x64) Build ID: 2412653d852c