Frage stellen

Ratslinger's Profil - Aktivität

2020-01-19 20:54:32 +0100 Kommentierte Frage ALTER table statement error: table/column not found.

Hello, What is the database you are applying this to? Since this is an existing table, is this the primary key and the

2020-01-19 19:27:15 +0100 Überarbeitete Antwort BASIC Calc: How to work with various Libraries ?

Hello, These errors are related. The first is because ConnectDatabase is not accessible & the second because in th

2020-01-19 19:19:04 +0100 Überarbeitete Antwort BASIC Calc: How to work with various Libraries ?

Hello, These errors are related. The first is because ConnectDatabase is not accessible & the second because in th

2020-01-17 19:43:30 +0100 Überarbeitete Antwort HOW do I assign the result from a query to a variable in LO Base?

Hello, Just to give an example of one of many ways to do this, I created a VERY basic Firebird Base file (HSQLDB would

2020-01-17 05:53:28 +0100 Kommentierte Frage Nested CONCAT and COALESCE

@Dazzer, Probably but I have no specifics. This may be difficult using (small) fee as a basis. There are many example

2020-01-17 04:58:41 +0100 Überarbeitete Antwort Nested CONCAT and COALESCE

Hello, The problem is syntax. Even in your question you change dramatically from: COALESCE ( "Guest_Preferred_Name",

2020-01-17 03:22:10 +0100 Kommentierte Antwort Searching for data [BH40-Base Handbook p.200]

Just to clarity, in the sample the two could have been main forms each instead of a main and a sub.

2020-01-17 01:51:36 +0100 Kommentierte Antwort Searching for data [BH40-Base Handbook p.200]

Firebird does not need JRE so you probably have the wrong JRE installed or the settings in 'Tools-Options-LibreOffice-Ad

2020-01-17 01:50:38 +0100 Überarbeitete Antwort Searching for data [BH40-Base Handbook p.200]

Hello, The text box is not associated with any SQL itself. It's main purpose, unlike the list box, is to enter partial

2020-01-16 00:35:35 +0100 Überarbeitete Antwort Any Base guru tell me, a confessed newbie why the date is stuck on 12/1899?

Hello, This appears to be a bug. Please report here -> Bugzilla You can currently enter a correctly displayed date

2020-01-16 00:35:10 +0100 Überarbeitete Antwort Any Base guru tell me, a confessed newbie why the date is stuck on 12/1899?

Hello, This appears to be a bug. Please report here -> Bugzilla You can currently enter a correctly displayed date

2020-01-14 06:04:05 +0100 verliehene Abzeichen  Tolle Antwort (Quelle)
2020-01-14 05:59:20 +0100 Überarbeitete Antwort UNPIVOT syntax in Basex

Hello, To start, here is a link to the HSQLDB documentation (v1.8 included with LO Base) -> http://www.hsqldb.org/do

2020-01-14 04:48:56 +0100 Überarbeitete Antwort UNPIVOT syntax in Basex

Hello, To start, here is a link to the HSQLDB documentation (v1.8 included with LO Base) -> http://www.hsqldb.org/do

2020-01-13 23:13:26 +0100 Überarbeitete Antwort UNPIVOT syntax in Basex

Hello, To start, here is a link to the HSQLDB documentation (v1.8 included with LO Base) -> http://www.hsqldb.org/do

2020-01-13 06:55:28 +0100 Kommentierte Antwort Signing multiple signature lines

The post is the question - An answer is an answer to the question posted. Otherwise it should be a comment. Posting as

2020-01-13 06:45:44 +0100 Kommentierte Antwort Signing multiple signature lines

The post IS the question - An answer is an answer to the question. Otherwise it should be a comment.

2020-01-13 05:45:27 +0100 Kommentierte Antwort Signing multiple signature lines

Please forgive me, but if this is a question, why is it an answer?

2020-01-12 03:25:00 +0100 Überarbeitete Antwort Sharing data between queries and macros

Hello, My tests (first use of temp table) shows this to work quite well except for one small glitch (describe later).

2020-01-12 03:02:57 +0100 Überarbeitete Antwort Sharing data between queries and macros

Hello, My tests (first use of temp table) shows this to work quite well except for one small glitch (describe later).

2020-01-12 02:53:50 +0100 Überarbeitete Antwort Sharing data between queries and macros

Hello, My tests (first use of temp table) shows this to work quite well except for one small glitch (describe later).

2020-01-12 01:18:25 +0100 Überarbeitete Antwort Sharing data between queries and macros

Hello, My tests (first use of temp table) shows this to work quite well except for one small glitch (describe later).

2020-01-12 01:16:10 +0100 Überarbeitete Antwort Sharing data between queries and macros

Hello, My tests (first use of temp table) shows this to work quite well except for one small glitch (describe later).

2020-01-11 22:23:28 +0100 Kommentierte Antwort Sharing data between queries and macros

A quick look at the PostgreSQL documentation seems to indicate a different process there. Will try testing this later.

2020-01-11 22:13:40 +0100 Kommentierte Antwort Sharing data between queries and macros

A quick look at the PostgreSQL documentation seems to indicate a different process there. Will try testing this later.

2020-01-11 21:15:36 +0100 Überarbeitete Antwort Sharing data between queries and macros

Hello, My tests (first use of temp table) shows this to work quite well except for one small glitch (describe later).

2020-01-11 20:53:58 +0100 Überarbeitete Antwort Sharing data between queries and macros

Hello, My tests (first use of temp table) shows this to work quite well except for one small glitch (describe later).

2020-01-11 20:33:22 +0100 Überarbeitete Antwort Sharing data between queries and macros

Hello, My tests (first use of temp table) shows this to work quite well except for one small glitch (describe later).

2020-01-11 20:26:11 +0100 Überarbeitete Antwort Sharing data between queries and macros

Hello, My tests (first use of temp table) shows this to work quite well except for one small glitch (describe later).

2020-01-10 01:20:09 +0100 Kommentierte Frage Sharing data between queries and macros

Personally I would use Firebird or PostgreSQL server. Both appear to have Temp tables and available in 32-bit for Linux

2020-01-09 23:18:53 +0100 Kommentierte Frage Sharing data between queries and macros

Probably. Embedded databases are not multi-user capable. They are complete within the .odb of Base. You have stated t

2020-01-09 21:16:46 +0100 Kommentierte Antwort Base crashes when editing reports

@carltonmatthew, This doesn't actually answer the question. It should be a comment. I also disagree with your stateme

2020-01-09 20:56:50 +0100 Überarbeitete Antwort LibreOffice does not find Java

Hello, With Lubuntu 1604 system is 32 bits you may find this answer by @rbscebu to work -> How do I get Base to work

2020-01-09 02:03:09 +0100 Kommentierte Frage How can I enter an IF/Then statement in a Libre Base query w/o using SQL?

Please keep main question short and place further explanations in details. Now you are missing some things. You don't

2020-01-09 00:53:02 +0100 Kommentierte Frage How can I enter an IF/Then statement in a Libre Base query w/o using SQL?

Please keep main question short and place further explanations in details. Now you are missing some things. You don't

2020-01-09 00:44:32 +0100 Überarbeitete Frage How can I enter an IF/Then statement in a Libre Base query w/o using SQL?

How can I enter an IF/Then statement in a Libre Base query w/o using SQL? Can I put it in a field like I do with simple

2020-01-09 00:44:16 +0100 Überarbeitete Frage How can I enter an IF/Then statement in a Libre Base query w/o using SQL?

How can I enter an IF/Then statement in a Libre Base query w/o using SQL? Can I put it in a field like I do with simple

2020-01-08 07:59:10 +0100 Überarbeitete Antwort Link between Calc sheets in separate files and use it as database in Base

Hello, I am certainly not proficient in Calc but took a look at this because of Base. Either I am missing something he

2020-01-08 07:34:31 +0100 Überarbeitete Antwort Link between Calc sheets in separate files and use it as database in Base

Hello, I am certainly not proficient in Calc but took a look at this because of Base. Either I am missing something he

2020-01-08 06:11:58 +0100 Überarbeitete Antwort Link between Calc sheets in separate files and use it as database in Base

Hello, I am certainly not proficient in Calc but took a look at this because of Base. Either I am missing something he

2020-01-07 00:28:05 +0100 Kommentierte Antwort handling of special characters in SQL

What is shown in the answer is a query using the same syntax in your question. Simply select Create Query in SQL View f

2020-01-06 18:42:24 +0100 Überarbeitete Antwort handling of special characters in SQL

Hello, Use SQL[Native] for Type of list contents or save as Query (turn on Run SQL command directly) and use that. Bot

2020-01-06 18:24:44 +0100 Überarbeitete Antwort handling of special characters in SQL

Hello, Use SQL[Native] for Type of list contents or save as Query (turn on Run SQL command directly) and use that. Bot

2020-01-06 18:17:47 +0100 Überarbeitete Antwort libreoffice base requires an absolute url to display images

Hello, Actually not certain Base is the one requiring the absolute URL or if it is Windows Photo Viewer. In Base when

2020-01-06 18:16:44 +0100 Überarbeitete Antwort libreoffice base requires an absolute url to display images

Hello, Actually not certain Base is the one requiring the absolute URL or if it is Windows Photo Viewer. In Base when

2020-01-06 06:03:33 +0100 Kommentierte Antwort Labels are repeated across page

Please only post as an answer when actually answering the original question. It should actually be posted as a comment

2020-01-06 02:33:00 +0100 Kommentierte Antwort When trying to submit a new record to a table in Base, error code -1 is received. How to fix?

Again, the best thing here may be for you to post a sample. Just edit the question an use the "Paperclip'" icon in the

2020-01-06 01:51:29 +0100 Kommentierte Antwort libreoffice base requires an absolute url to display images

No hidden option to my knowledge. So instead of continuing to guess as to how you are doing something, please explain w

2020-01-05 23:31:44 +0100 Überarbeitete Antwort handling of special characters in SQL

Hello, Use SQL[Native] for Type of list contents or save as Query and use that. Both work.

2020-01-05 04:03:51 +0100 Kommentierte Antwort How to create a modeless ( non modal) dialog

@Mike Kaganski, No. In Basic simply use the execute method. In fact, removed the setVisible in the Python code (which