[firebird-support] kind of deletion detection in "before delete trigger"

Hi everybody, I wonder whether or not Firebird has a feature in "before delete trigger" to detect kind of record deletion, I mean that I need to distinguish a record deletion by cascade operation or by regular delete. Thank you very much. Regards, Tjioe Hian Pin

[firebird-support] Re: Trigger, check whether a cascade or user caused action

--- In firebird-support@yahoogroups.com, "firebirdsql" wrote: > > I have an after update/delete trigger and would like to know if the trigger > was triggered by a cascade update/delete OR a user. Is this possible? > I posted an almost similar case today, in my case I just want to distinguish c

[firebird-support] Re: Does Firebird have a way to reference similar named fields? (Like MONTH_1 thru MONTH_120)

I think you have 2 options: 1. normalize the table to have 2 fields "Month Number" & "Month Value", then you can search record by "Month Number" for updating "Month Value" 2. use PSQL statement: EXECUTE STATEMENT, you can read about it in Firebird-2.5-LangRef-Update.pdf --- In firebird-suppor

[firebird-support] Re: Does Firebird have a way to reference similar named fields? (Like MONTH_1 thru MONTH_120)

000 0 > > Is there somewhere I can post attachments? If so then I could post the full > stored procedure and an excel file that was generated by it. > > So any other ideas how to modify this stored procedure? > > Mike > > >

[firebird-support] singleton table with many fields

Hi all, I have a table that always contains 1 record and have about 50 fields with various type. It's function is to store system parameters and is accessed very frequent from application and also from database triggers and stored procedures. Is it wise to utilize a singleton table like this, o

[firebird-support] Re: singleton table with many fields

m 16/7/2013 00:03, thp_pkmi escreveu: > > Hi all, > > > > I have a table that always contains 1 record and have about 50 fields with > > various type. It's function is to store system parameters and is accessed > > very frequent from application and also from dat

[firebird-support] Re: Decimal Field prompt "Arithmetic overflow" error for larger size or scale decimal numbers

--- In firebird-support@yahoogroups.com, wrote: > > Hi. I have some users which prefer decimal to be larger size, and some prefer > decimal scale larger. However firebird only support 18 size for the whole > decimal. But when some data contain larger number or longer precision by > perform ar

[firebird-support] request for DML SQL feature

Hi everybody, I'm not sure this is a right site to ask for request for DML SQL, but I can stand any critics for this possible wrong post. I want to request a feature for firebird DML ie: ALTER TABLE .. ALTER FIELD POSITION [BEFORE|AFTER] .. I'm sure this would be a big help in adding new fields

Re: [firebird-support] How can I prevent that my database can be opened with another security.fdb.

Dear all, Though I don't have the same question as Roland, information below by Virna Constantin (costel...@yahoo.com) is very useful.Thanks every one. Regards,Tjioe Suggestion event studies "on connect" 1. an application with minimum rights connects to the database 1 '. in table "mon$attachmnts"

Re: [firebird-support] Exists function

Hi Martin, Thank you for yor concern. I don't explore the source code of firebird, but I guess your opinion is  correct. Regards,Tjioe Hian Pin On Friday, 9 December 2016, 21:13, "Köditz, Martin martin.koed...@it-syn.de [firebird-support]" wrote:   Hi,   I think the answer is simpl