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
--- 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
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
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
>
>
>
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
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
--- 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
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
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"
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
10 matches
Mail list logo