Ask Your Question

Quarto Die's profile - activity

2019-05-15 14:57:04 +0200 marked best answer How to update multiple fields in LO Base?

I would like to update several fields from table2 into table 1 in LIBRE OFFICE BASE using SQL based on the equivalence of one ID field in both tables. I have tried the following solutions which I found online and most seem to have failed when the sql sequence met the first parentheses except for the Merge attempt which failed on its own. Here is what I have tried and the results - DOES ANY ONE HAVE ANYTHING THAT WORKS?:

Try #1 UPDATE table1 t1 SET (t1.column1, t1.column2) = (SELECT t2.column1, t2.column2 FROM table2 t2 WHERE t1.id = t2.id) WHERE EXISTS ( SELECT 1 FROM table2 t2 WHERE t1.id = t2.id )

----*Failed: Unexpected token: ( in statement [update "T1" set (]

Try #2

UPDATE (SELECT t1.id, t1.column1, t1.column2, t2.column1, t2.column2 FROM table1 t1, table2 t2 WHERE t1.id = t2.id) SET t1.column1 = t2.column1, t1.column1 = t2.column1

-----Failed* Unexpected token: ( in statement [UPDATE (]

Try #3

merge into t2 t2 using (select * from t1) t1 on (t2.user_id = t1.user_id) when matched then update set t1.c1 = t2.c1 , t1.c2 = t2.c2

---- Failed: Unexpected token: MERGE in statement [merge]

Try#4

update t1 set (c1, c2, c3) = (select c1, c2, c3 from t2 where t2.user_id = t1.user_id) where exists (select * from t2 where t2.user_id = t1.user_id)

----*Failed: Unexpected token: ( in statement [update "T1" set (]

Try#5

update table1 t1 set ( t1.column1, t1.column2 ) = ( select t2.column1, t2.column2 from table2 t2 where t2.column1 = t1.column1 ) where exists ( select null from table2 t2 where t2.column1 = t1.column1 );

---Failed * ERROR MESSAGE "t1" set (]

DOES ANYONE HAVE AN SQL COMMAND THAT WOULD WORK WITH BASE IN THIS INSTANCE? THANK YOU!

2019-03-10 01:23:06 +0200 received badge  Famous Question (source)
2019-03-01 13:42:01 +0200 received badge  Notable Question (source)
2019-03-01 13:41:34 +0200 received badge  Notable Question (source)
2019-02-26 23:29:12 +0200 commented answer Is there a maximum number which a Base field can handle?

Thank you in effect, that does seem to work and the DOUBLE seems to be able to compute with numbers in Calculations.

2019-02-26 22:39:29 +0200 received badge  Popular Question (source)
2019-02-26 20:14:40 +0200 received badge  Popular Question (source)
2019-02-26 20:14:40 +0200 received badge  Notable Question (source)
2019-02-26 20:13:41 +0200 received badge  Notable Question (source)
2019-02-26 19:04:40 +0200 edited question Is there a maximum number which a Base field can handle?

Is there a maximum number which a Base field can handle? In Libre Office Base Version: 6.1.5.2 on Linux Mint 19.1 I am

2019-02-26 19:04:34 +0200 edited question Is there a maximum number which a Base field can handle?

Is there a maximum number which for a Base field? In Libre Office Base Version: 6.1.5.2 on Linux Mint 19.1 I am trying

2019-02-26 19:02:49 +0200 edited question Is there a maximum number which a Base field can handle?

Is there a maximum number which for a Base field? In Libre Office Base Version: 6.1.5.2 on Linux Mint 19.1 I am trying

2019-02-26 18:41:55 +0200 asked a question Is there a maximum number which a Base field can handle?

Is there a maximum number which for a Base field? In Libre Office Base Version: 6.1.5.2 on Linux Mint 19.1 I am trying

2019-02-26 18:41:54 +0200 asked a question Is there a maximum number which for a Base field?

Is there a maximum number which for a Base field? In Libre Office Base Version: 6.1.5.2 on Linux Mint 19.1 I am trying

2019-02-26 18:41:50 +0200 asked a question Is there a maximum number which for a Base field?

Is there a maximum number which for a Base field? In Libre Office Base Version: 6.1.5.2 on Linux Mint 19.1 I am trying

2019-02-26 02:34:51 +0200 received badge  Popular Question (source)
2019-02-25 23:18:12 +0200 edited question Why is my Table data invisible except when highligted?

Why is my Table data invisible except when highligted? In LibreOffice 6.1.5.2 working on Linux Mint 19.1 in one databas

2019-02-25 23:00:12 +0200 edited question Why is my Table data invisible except when highligted?

Why is my Table data invisible except when highligted? In Libre Office 6.1.5.2 working on Linux Mint 19.1 in one databa

2019-02-25 22:59:46 +0200 asked a question Why is my Table data invisible except when highligted?

Why is my Table data invisible except when highligted? In Libre Office 6.1.5.2 working on Linux Mint 19.1 in one databa

2019-01-04 01:48:04 +0200 commented answer Cannot open reprorts in LibreOffice Version: 6.0.7.3

Yes effectively, I downloaded version 6.1.4.2 and they work again. Thank you!

2019-01-04 01:46:39 +0200 marked best answer Cannot open reprorts in LibreOffice Version: 6.0.7.3

I have just switched to Libre Office BuilVersion: 6.0.7.3 Build ID: 1:6.0.7-0ubuntu0.18.04.2d ID: 1:6.0.7-0ubuntu0.18.04.2, and to Linux Mint 19.1 Cinnamon from 18.3. I am using a split-database. All seems to be working more or less correctly with the changeover, but now I cannot any longer open any reports I previously made and which formerly opened under my previous version of libre office 5.? and Linux Mint 18.3. The only message I get when attempting to open a report is: The document "document name" could not be opened. Can anyone help me. I see someone had a similar problem some years back, but it doesnt seem to be my problem. I have tried this with some databases which are not split and seem to have the same problem.

2019-01-04 01:39:09 +0200 commented question Cannot open reprorts in LibreOffice Version: 6.0.7.3

I am working in the 64 bit version of Mint and L.O.

2019-01-04 01:38:36 +0200 edited question Cannot open reprorts in LibreOffice Version: 6.0.7.3

Cannot open reprorts in LibreOffice Version: 6.0.7.3 I have just switched to Libre Office BuilVersion: 6.0.7.3 Build ID

2019-01-04 00:03:27 +0200 commented question Cannot open reprorts in LibreOffice Version: 6.0.7.3

I should note this is a 64-bit system of 19.1 Cinnamon and L.O.

2019-01-03 23:48:23 +0200 asked a question Cannot open reprorts in LibreOffice Version: 6.0.7.3

Cannot open reprorts in LibreOffice Version: 6.0.7.3 I have just switched to Libre Office BuilVersion: 6.0.7.3 Build ID

2019-01-03 23:48:21 +0200 asked a question Cannot open reprorts in LibreOffice Version: 6.0.7.3

Cannot open reprorts in LibreOffice Version: 6.0.7.3 I have just switched to Libre Office BuilVersion: 6.0.7.3 Build ID

2018-12-13 12:51:39 +0200 received badge  Famous Question (source)
2018-08-31 04:17:50 +0200 received badge  Famous Question (source)
2018-06-29 21:12:39 +0200 received badge  Popular Question (source)
2018-06-27 19:51:47 +0200 edited question How to make week and day concur in LibreOffice Base?

How to make week and day concur in LibreOffice Base? I am working on a split database in Libre Office Base Version: 5.4.

2018-06-27 19:51:46 +0200 commented question How to make week and day concur in LibreOffice Base?

e.g. Sunday, January 21, 2018, is listed as last day in the 3rd week in the year, but as day number 1. On my Linux syst

2018-06-27 19:51:08 +0200 commented question How to make week and day concur in LibreOffice Base?

e.g. Sunday, January 21, 2018, is listed as last day in the 3rd week in the year, but as day number 1. On my Linux syst

2018-06-27 19:16:53 +0200 asked a question How to make week and day concur in LibreOffice Base?

How to make week and day concur in LibreOffice Base? I am working on a split database in Libre Office Base Version: 5.4.

2018-06-26 20:16:56 +0200 received badge  Famous Question (source)
2018-03-20 19:15:43 +0200 received badge  Famous Question (source)
2017-12-23 02:29:07 +0200 received badge  Famous Question (source)
2017-10-16 02:11:06 +0200 received badge  Famous Question (source)
2017-09-23 19:25:13 +0200 received badge  Famous Question (source)
2017-07-31 16:11:30 +0200 received badge  Notable Question (source)
2017-07-27 17:16:07 +0200 received badge  Popular Question (source)
2017-07-26 02:01:49 +0200 received badge  Popular Question (source)
2017-07-25 21:43:23 +0200 commented answer Cannot add new records into a table created like another.

Thank you for the information and clarification.