Pergunte aqui

Perfil de EasyTrieve - atividade

2019-09-19 22:09:39 +0200 Marcada como a melhor resposta How do I display the HSQLDB Embedded version?

How do I figure out which HSQLDB Embedded version is running inside my LO?

image description

It's not in Help | About.

Also, is "HSQDB" HyperSQL or Heidi SQL????

I'm running the latest LO version 5.2.3.3


Here's what I've learned so far...

== I suspect 5.2.3.3 is running an older version of HSQL because Tools | SQL... can't find this HSQL function:

 SELECT ROW_NUMBER() FROM ...

== There is a way to upgrade HSQL by splitting off the database best described here.

== I looked at this related question, but it fails to return an answer for me. Does this mean I have V 1.8? When I try the suggested solutions with Tools | SQL... here's what I get:

 SELECT * FROM "INFORMATION_SCHEMA"."SYSTEM_TABLES"

Executes successfully. But only returns something like this:

,INFORMATION_SCHEMA,SYSTEM_ALIASES,SYSTEM TABLE,the aliases defined within this database,,,,,,MEMORY,true,
,INFORMATION_SCHEMA,SYSTEM_ALLTYPEINFO,SYSTEM TABLE,a description of all non user-defined data types known to this database and the level of support for them in various capacities,,,,,,MEMORY,true,
,INFORMATION_SCHEMA,SYSTEM_AUTHORIZATIONS,SYSTEM TABLE,one row for each user and one row for each role ,,,,,,MEMORY,true,
etc...

SELECT * FROM "INFORMATION_SCHEMA"."SYSTEM_TABLE_CONSTRAINTS"

Executes successfully. But similarity only returns this:

,PUBLIC,SYS_FK_106,FOREIGN KEY,,PUBLIC,Products,NO,NO,
,PUBLIC,SYS_FK_161,FOREIGN KEY,,PUBLIC,Products,NO,NO,
,PUBLIC,SYS_FK_164,FOREIGN KEY,,PUBLIC,MediaContacts,NO,NO,
,PUBLIC,SYS_FK_180,FOREIGN KEY,,PUBLIC,Products,NO,NO,
,PUBLIC,SYS_PK_47,PRIMARY KEY,,PUBLIC,Products,NO,NO,
,PUBLIC,SYS_PK_49,PRIMARY KEY,,PUBLIC,Categories,NO,NO,
,PUBLIC,SYS_PK_51,PRIMARY KEY,,PUBLIC,MediaContacts,NO,NO,
,PUBLIC,SYS_PK_53,PRIMARY KEY,,PUBLIC,Companies,NO,NO,

SELECT * FROM "INFORMATION_SCHEMA"."TABLE_CONSTRAINTS";

Fails to execute: "Table not found"

SELECT * FROM "INFORMATION_SCHEMA"."SYSTEM_CHECK_CONSTRAINTS";

Executes successfully. But no results returned. ???


(Due to a bug in Ask.LibreOffice.org where code inside of a bulleted list does not display correctly, I used == rather than * for line prefixes above.)

2019-09-19 21:55:44 +0200 Medalha recebida  Autodidata (fonte)
2019-09-02 03:29:05 +0200 Resposta comentada updating fk of a record gives an error (libre base ver: 5.1.6.2)

@rajko, I would love to be able to help further with this right now, but am unable to due to other time constraints in m

2019-08-28 23:22:29 +0200 Resposta comentada How to work with frames

"DTP"? https://acronyms.thefreedictionary.com/DTP What does DTP stand for????

2019-08-16 18:24:09 +0200 Medalha recebida  Pergunta notável (fonte)
2019-08-16 18:24:09 +0200 Medalha recebida  Pergunta famosa (fonte)
2019-08-16 15:34:29 +0200 Resposta comentada How do I let Base jump to the last record of a table in a form?

@Ratslinger, also chopped out the clone line and it still works. Then added comment for the reason moveToInsertRow is n

2019-08-16 15:33:37 +0200 Resposta comentada How do I let Base jump to the last record of a table in a form?

@Ratslinger, also chopped out the clone line and it still works. Then added comment for the reason moveToInsertRow is n

2019-08-16 15:32:18 +0200 Resposta editada How do I let Base jump to the last record of a table in a form?

If you just want to move to the last record, without moving to the insert record (the one after the last record), then h

2019-08-16 15:32:03 +0200 Resposta editada How do I let Base jump to the last record of a table in a form?

If you just want to move to the last record, without moving to the insert record (the one after the last record), then h

2019-08-16 07:03:40 +0200 Resposta comentada How do I let Base jump to the last record of a table in a form?

@Ratslinger, Sorry, I forgot to extract the 2'nd half w/ the moveToInsertRow, then Last. Now it should work.

2019-08-16 07:02:30 +0200 Resposta editada How do I let Base jump to the last record of a table in a form?

If you just want to move to the last record, without moving to the insert record (the one after the last record), then h

2019-08-15 16:47:02 +0200 Pergunta editada How to fix :“Not Enough Stack Memory” when trying to load() with OfficeDatabaseDocument UNO service

How to fix :“Not Enough Stack Memory” when trying to load() with OfficeDatabaseDocument UNO service I try to familiarize

2019-08-15 16:41:41 +0200 Pergunta comentada Reports with one record on multiple/many pages.

By 'data' what do you mean? Do you have many multiple fields per record, or do you just have one really huge field per

2019-08-15 16:41:08 +0200 Pergunta comentada Reports with one record on multiple/many pages.

By 'data' what do you mean? Do you have many multiple fields, or do you just have one really huge field?

2019-08-15 16:24:18 +0200 Pergunta comentada I cant add records to my table

Not sure what your prob. is, but I've had similar frustrations with this, so understand your frustration. I don't use W

2019-08-15 16:18:15 +0200 Pergunta comentada MySQL DATE_ADD not recognized in datagrid

Generally, when something isn't working in my basic code, I try to create a simpler test case to try and divide and conq

2019-08-15 15:45:13 +0200 Resposta editada How do I let Base jump to the last record of a table in a form?

If you just want to move to the last record, without moving to the insert record (the one after the last record), then t

2019-08-15 15:44:58 +0200 Resposta editada How do I let Base jump to the last record of a table in a form?

If you just want to move to the last record, without moving to the insert record (the one after the last record), then t

2019-08-15 15:44:33 +0200 Resposta editada How do I let Base jump to the last record of a table in a form?

If you just want to move to the last record, without moving to the insert record (the one after the last record), then t

2019-08-15 15:44:10 +0200 Resposta editada How do I let Base jump to the last record of a table in a form?

If you just want to move to the last record, without moving to the insert record (the one after the last record), then t

2019-08-15 15:43:41 +0200 Respondeu uma pergunta How do I let Base jump to the last record of a table in a form?

If you just want to move to the last record, without moving to the insert record (the one after the last record), then t

2019-08-15 04:31:33 +0200 Medalha recebida  Resposta boa (fonte)
2019-08-12 21:23:45 +0200 Medalha recebida  Resposta legal (fonte)
2019-08-12 05:47:55 +0200 Resposta editada Base: Setting "Document Information" (in Main window)?

Update: Ratslinger says: "Edit the form, from menu - File ->Properties." My original answer: With Calc there is

2019-08-12 02:20:26 +0200 Pergunta comentada Found method in Linux to read MS Access mdb or accdb tables into LibreOffice Base

@Ratslinger, I haven't seen you in awhile. Before that you have been a foundation rock here! Are you ok?

2019-08-12 02:09:20 +0200 Resposta editada Base: Setting "Document Information" (in Main window)?

With Calc there is a direct way to edit this, via File | Properties. However, with Base this appears (at least to me)

2019-08-12 02:08:43 +0200 Resposta editada Base: Setting "Document Information" (in Main window)?

With Calc there is a direct way to edit this, via File | Properties. However, with Base this appears (at least to me)

2019-08-12 02:06:13 +0200 Resposta editada Base: Setting "Document Information" (in Main window)?

With Calc there is a direct way to edit this, via File | Properties. However, with Base this appears (at least to me)

2019-08-12 02:04:02 +0200 Respondeu uma pergunta Base: Setting "Document Information" (in Main window)?

With Calc there is a direct way to edit this, via File | Properties. However, with Base this appears (at least to me)

2019-08-12 01:47:26 +0200 Pergunta editada Base: Setting "Document Information" (in Main window)?

LO Base Main window Hi everyone, On the main window in LO Base, on the right hand side there is a pane where we can togg

2019-08-08 08:39:26 +0200 Medalha recebida  Pergunta popular (fonte)
2019-08-08 08:39:26 +0200 Medalha recebida  Pergunta notável (fonte)
2019-07-30 20:33:11 +0200 Resposta comentada Base as Front End w/multiple users

MySQL easily supports multi users at the same time. Things you need to think about are better described in the MySQL do

2019-07-30 20:26:53 +0200 Pergunta comentada Form filter freezes in BASE

Please report bugs: Help > Send Feedback.

2019-07-30 19:53:47 +0200 Pergunta comentada Why does Libre office mess up the margins on my pdf?

As far as the printing part of this Q, this depends on your OS, and then upon the tools you have available to print pdfs

2019-07-30 15:21:45 +0200 Resposta editada LibreOffice Calc converts date to clock face unicode character

Hello your problem seems to be based on a misconception of dates and times in Calc (and other spreadsheet applications)

2019-07-28 03:31:12 +0200 Resposta editada Calc: How to enter equal sign as text

Set the number format code for the respective cell to @ in advance. If you don't like that, and you don't expect Calc t

2019-07-28 00:32:25 +0200 Resposta editada Leaving Winows 7 Professional for Ubuntu

Some of this is fairly easy, like importing spread sheets. But learning Linux and moving from Access to Base is much ha

2019-07-28 00:05:18 +0200 Respondeu uma pergunta Leaving Winows 7 Professional for Ubuntu

Some of this is fairly easy. Learning Linux and moving from Access to Base is much harder. What I did was to first mig

2019-07-24 14:49:09 +0200 Resposta comentada Math calculations in PDF forms?

A pdf document is written in postscript. Postscript is a very powerful and full computer language. It is not only quit

2019-07-24 14:48:29 +0200 Resposta comentada Math calculations in PDF forms?

A pdf document is written in postscript. Postscript is a very powerful and full computer language. It is not only quit

2019-07-24 14:48:10 +0200 Resposta comentada Math calculations in PDF forms?

A pdf document is written in postscript. Postscript is a very powerful and full computer language. It is not only quit

2019-07-23 15:33:08 +0200 Pergunta editada Change default font and size in BASE?

Chnage default font and size in BASE? Hi all! Is there a way to change the default font and font size in BASE? Right n

2019-07-09 03:19:30 +0200 Pergunta comentada Why am I struggling to learn macros using LibreOffice basic and its API?

I put this together as I was learning macros for base. Some of it might help you. Over time it's had 11k views. The s

2019-06-26 22:38:25 +0200 Respondeu uma pergunta Where is the documentation for "Expert Configuration"?

One can read the source code, but it takes quite an expert.

2019-06-22 19:28:10 +0200 Pergunta comentada Autocorrect help file does not address ...

I know how frustrating it can be at first. But when you're new you don't yet know the lay of the land, and the jargon t

2019-06-22 19:16:22 +0200 Resposta comentada LO Base and PostgreSQL embedded

I'm familiar with connectors and connecting, as in Edit | Database | Connection type... What is attaching to a server,

2019-06-21 13:52:55 +0200 Pergunta comentada how i get system ip address using macro in openoffice

I suspect this might depend on your OS. What OS are you using?

2019-06-21 13:51:45 +0200 Pergunta editada how i get system ip address using macro in openoffice

how i get system ip address using macro in openoffice How do i get my system's IP address using a macro in LibreOffice (