Ask Your Question

hermanv's profile - activity

2020-08-24 14:57:39 +0200 received badge  Notable Question (source)
2020-07-23 21:03:04 +0200 commented answer When making a query in base on a table from an ods file, I cann't define any fucntions to the queried fields

I've read your recommendation and it makes sense, but I cann't use it straightaway, because the spreadsheet in question

2020-07-23 21:01:15 +0200 answered a question When making a query in base on a table from an ods file, I cann't define any fucntions to the queried fields

I've read your recommendation and it makes sense, but I cann't use it straightaway, because the spreadsheet in question

2020-07-23 14:19:11 +0200 received badge  Popular Question (source)
2020-07-22 10:42:02 +0200 asked a question When making a query in base on a table from an ods file, I cann't define any fucntions to the queried fields

When making a query in base on a table from an ods file, I cann't define any fucntions to the queried fields LibreOffice

2020-05-31 11:07:41 +0200 received badge  Famous Question (source)
2020-04-04 14:36:48 +0200 received badge  Famous Question (source)
2020-03-05 17:02:14 +0200 received badge  Notable Question (source)
2020-02-11 08:35:41 +0200 received badge  Famous Question (source)
2019-12-31 19:10:57 +0200 received badge  Popular Question (source)
2019-12-11 07:18:14 +0200 received badge  Famous Question (source)
2019-12-09 00:19:36 +0200 marked best answer Operation in a sql in a macro

In the SQL tool this works OK insert into "Ledenarchief" ("archlidid","Naam") select "lidid" + 1000 ,"Naam" from "Leden" where "Datum ontslag" is not null or "datum overlijden" is not null When I want to do this in a macro (first time I do this), like

SQL = "INSERT INTO ""Ledenarchief"" " & _
"(""archlidid"" " & _
",""OKRAlidnr"" " & _
",""Naam"" " & _
") " & _
"SELECT" & _
" ""lidid"" "+1000" " & _
",""OKRAlidnr"" " & _
",""Naam"" " & _
"FROM ""Leden"" " & _
"WHERE ""Leden"".""Datum ontslag"" "is not null" "or" ""Leden"".""datum overlijden"" "is not null""

I get error BASIC syntax error. Unexpected symbol: ???. and the "+1000" is hightlighted. So I must have made a mistake somewhere, but I ddon't get it. Someone can help??

2019-11-24 19:47:15 +0200 received badge  Notable Question (source)
2019-11-24 12:14:29 +0200 received badge  Commentator
2019-11-21 18:08:31 +0200 received badge  Popular Question (source)
2019-11-08 01:40:03 +0200 received badge  Notable Question (source)
2019-11-07 21:07:38 +0200 received badge  Popular Question (source)
2019-10-16 00:45:40 +0200 received badge  Notable Question (source)
2019-09-21 15:48:37 +0200 received badge  Enthusiast
2019-09-20 09:57:39 +0200 commented answer Error Invalid data type for setstring

Bug 127657 submitted.

2019-09-19 20:21:42 +0200 edited answer Error Invalid data type for setstring

I never used leading zero's, so that's not the point. In the mean time I tried to cast the month expression to varchar(2

2019-09-19 20:20:26 +0200 answered a question Error Invalid data type for setstring

I never used leading zero's, so that's not the point. In the mean time I tried to cast the month espression to varchar(2

2019-09-19 16:26:54 +0200 received badge  Popular Question (source)
2019-09-18 09:52:38 +0200 asked a question Error Invalid data type for setstring

Error Invalid data type for setstring LibreOffice Base 6.3 using Firebird. I have a table "Gezinnen" with 3 columns: gez

2019-07-07 12:44:10 +0200 received badge  Famous Question (source)
2019-04-30 10:52:12 +0200 commented answer Where to find libreoffice-postgresql

Now all is fine, I can connect.

2019-04-30 10:20:56 +0200 commented answer Where to find libreoffice-postgresql

Well, TDF is the place I got my installed version from. And I can definitely confirm: when I open a new database, select

2019-04-29 10:54:02 +0200 commented answer Where to find libreoffice-postgresql

Hehe, I took your lead and found the Postgresql catalog at here and that points to https://wiki.documentfoundation.org/P

2019-04-28 19:06:05 +0200 received badge  Notable Question (source)
2019-04-28 11:30:52 +0200 answered a question Where to find libreoffice-postgresql

The data are in a postgres database (I know its name, user and password) The postgres Jdbc connector seems to be missin

2019-04-28 11:29:52 +0200 received badge  Popular Question (source)
2019-04-25 17:07:52 +0200 asked a question Where to find libreoffice-postgresql

Where to find libreoffice-postgresql I am using Mageia 6, and it usually provides a complete LibreOffice installation in