Pergunte aqui

Perfil de patpend - atividade

2019-05-31 04:59:49 +0100 Medalha recebida  Pergunta notável (fonte)
2019-05-31 04:59:49 +0100 Medalha recebida  Pergunta famosa (fonte)
2018-12-12 17:48:00 +0100 Resposta comentada How to get SQL TRIGGER to display SQLSTATE message text in a Base form?

Thank you. BTW I could not get the form navigation control to work until I quit and restarted LO, even without first tr

2018-12-12 17:44:42 +0100 Marcada como a melhor resposta How to get SQL TRIGGER to display SQLSTATE message text in a Base form?

I'm trying to display a message box in an HSQLDB trigger block within a LibreOffice Base form and can't get it working.

I have a LO Base app using a split HSQLDB 2.3.2. It includes a table "checks" that has a boolean column "issued". When issued is "true" I want to prevent deletion of that row. So I created the following trigger to detect this condition and prevent deletion:

CREATE TRIGGER "delete_check" BEFORE DELETE ON "checks"
REFERENCING OLD AS oldrow

FOR EACH ROW WHEN (oldrow."issued" = true)
BEGIN ATOMIC
  SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Issued check cannot be deleted';
END;

When I use the built-in grid view and try to delete a row with the issued flag set, the message box DOES pop up as expected.

But running in a Base form and trying to delete the row using the navigation bar, the message box does not pop up. (In either case the row is not deleted, which is good because it means the trigger is working.)

How can I get the message box to display from an HSQLDB trigger block within an LibreOffice Base form?

2018-12-12 17:44:41 +0100 Medalha recebida  Acadêmico (fonte)
2018-12-12 17:38:03 +0100 Medalha recebida  Pergunta popular (fonte)
2018-12-11 21:24:57 +0100 Pergunta editada How to get SQL TRIGGER to display SQLSTATE message text in a Base form?

How to get SQL TRIGGER to display SQLSTATE message text in a Base form? I'm trying to display a message box in an HSQLDB

2018-12-11 21:24:57 +0100 Medalha recebida  Editor (fonte)
2018-12-11 21:24:17 +0100 Pergunta editada How to get SQL TRIGGER to display SQLSTATE message text in a Base form?

How to get SQL TRIGGER to display SQLSTATE message text in a Base form? I'm trying to display a message box in a HSQLDB

2018-12-11 21:21:47 +0100 Perguntou How to get SQL TRIGGER to display SQLSTATE message text in a Base form?

How to get SQL TRIGGER to display SQLSTATE message text in a Base form? I'm trying to display a message box in a HSQLDB

2018-04-12 11:01:33 +0100 Medalha recebida  Pergunta boa (fonte)
2018-04-09 14:21:04 +0100 Medalha recebida  Pergunta boa (fonte)
2017-09-03 23:29:34 +0100 Medalha recebida  Torcedor (fonte)
2017-07-19 14:22:58 +0100 Resposta comentada How do I get cmd-V paste to work in Base OSX?

Thanks for the response. There is no other text in this row to the right of "Cmd+V". I checked in the main window (opt

2017-07-15 10:24:18 +0100 Medalha recebida  Pergunta notável (fonte)
2017-07-14 17:28:06 +0100 Medalha recebida  Pergunta popular (fonte)
2017-07-14 15:37:21 +0100 Perguntou How do I get cmd-V paste to work in Base OSX?

How do I get cmd-V paste to work in Base OSX? The command-V keyboard shortcut for paste doesn't work on Base forms runni

2017-02-01 17:13:54 +0100 Medalha recebida  Estudante (fonte)
2016-01-04 18:36:14 +0100 Medalha recebida  Pergunta popular (fonte)
2016-01-04 18:36:14 +0100 Medalha recebida  Pergunta notável (fonte)
2016-01-04 18:36:14 +0100 Medalha recebida  Pergunta famosa (fonte)
2015-08-26 21:02:07 +0100 Perguntou Base: HSQLDB to Firebird migration for existing databases

Do any tools exist for migrating existing HSQLDB Base apps to Firebird? In the alternative, what are the current best practices for manual conversion?

2015-08-26 21:01:48 +0100 Perguntou When will LO Base use embedded HSQLDB 2.x?

Are there any plans to update the embedded HSQL engine from 1.8 to 2.x? It would greatly enhance development to have access to important functions, such as date_add. Work-arounds may exist in some cases but these are not always suitable in the target application. While it's possible to use HSQLDB 2.x in split mode, this too has drawbacks in added complexity and diminished ability to manipulate table designs during development. Is there a roadmap to embedded HSQL 2.x or are we forever at 1.8?