質問する

patpend's profile - activity

2019-05-31 04:59:49 +0200 バッジを受け取った  卓越した質問 (source)
2019-05-31 04:59:49 +0200 バッジを受け取った  有名な質問 (source)
2018-12-12 17:48:00 +0200 コメント付き回答 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 +0200 ベストアンサーマーク 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 +0200 バッジを受け取った  学者 (source)
2018-12-12 17:38:03 +0200 バッジを受け取った  人気の質問 (source)
2018-12-11 21:24:57 +0200 編集された質問 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 +0200 バッジを受け取った  編集者 (source)
2018-12-11 21:24:17 +0200 編集された質問 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 +0200 質問をする 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 +0200 バッジを受け取った  良い質問 (source)
2018-04-09 14:21:04 +0200 バッジを受け取った  ナイス質問 (source)
2017-09-03 23:29:34 +0200 バッジを受け取った  サポーター (source)
2017-07-19 14:22:58 +0200 コメント付き回答 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 +0200 バッジを受け取った  卓越した質問 (source)
2017-07-14 17:28:06 +0200 バッジを受け取った  人気の質問 (source)
2017-07-14 15:37:21 +0200 質問をする 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 +0200 バッジを受け取った  生徒 (source)
2016-01-04 18:36:14 +0200 バッジを受け取った  卓越した質問 (source)
2016-01-04 18:36:14 +0200 バッジを受け取った  有名な質問 (source)
2016-01-04 18:36:14 +0200 バッジを受け取った  人気の質問 (source)
2015-08-26 21:02:07 +0200 質問をする 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 +0200 質問をする 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?