POST_EVENT to trigger from application

[ertan.k...@gmail.com]

Hello,

I am using FirebirdSQL 2.5.9.latest Win32.

Is it possible to use POST_EVENT not in a trigger but in application object calling a query to the database?

Thanks & Regards,

Ertan

[Karol Bieniaszewski]

Hi

 

You can post event from stored procedure, so yes.

 

Regards,

Karol Bieniaszewski

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/0994edde-d577-4ab6-9f98-cc750ae5c02bn%40googlegroups.com.

 

[Dimitry Sibiryakov]

ertan.k...@gmail.com wrote 02.09.2023 22:50:
> Is it possible to use POST_EVENT not in a trigger but in application object
> calling a query to the database?

EXECUTE BLOCK should work as well.

--
WBR, SD.

[Ertan Küçükoglu]

Hi,

I could not make it work EXECUTE BLOCK. Just wanted to provide feedback. Below is what I get using ISQL

SQL> set term ^;
SQL> execute block as post_event 'abc'; end^
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 1, column 18
-post_event

Did I miss something?

Thanks & Regards,

Ertan

'Dimitry Sibiryakov' via firebird-support <firebird...@googlegroups.com>, 3 Eyl 2023 Paz, 00:33 tarihinde şunu yazdı:

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/3c8a129c-a17c-4b8e-cc39-5c5426ed1f10%40ibphoenix.com.

[Dmitry Yemanov]

03.09.2023 02:43, Ertan Küçükoglu wrote:
>
> I could not make it work EXECUTE BLOCK. Just wanted to provide feedback.
> Below is what I get using ISQL
>
> SQL> set term ^;
> SQL> execute block as post_event 'abc'; end^
> Statement failed, SQLSTATE = 42000
> Dynamic SQL Error
> -SQL error code = -104
> -Token unknown - line 1, column 18
> -post_event
>
> Did I miss something?

Yes, BEGIN after AS.


Dmitry

[Ertan Küçükoglu]

Yes. My bad.

Thanks for the heads up.

Dmitry Yemanov <fire...@yandex.ru>, 3 Eyl 2023 Paz, 10:21 tarihinde şunu yazdı:

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/00f5a989-e2d1-ba2d-bdbd-fcf1d8c85412%40yandex.ru.