AW: AW: [firebird-support] How to interprete gstat-results

Hi Thomas, I will study this :) Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Gesendet: Donnerstag, 14. April 2016 16:12 An: firebird-support@yahoogroups.com Betreff: Re: AW: [firebird-support] How to interprete gstat-results Hi Olaf, > Database

[firebird-support] Update with group by

Hello, each record gets a barcode number (generated with a generator), everything is fine. But if the Position Number is the same, both records should get the same value. How can I realize this? Update table a set field = gen_id(xxx,1) where field is not null group by pos? Thanks.

Re: [firebird-support] Connecting to Firebird database from two or more pc with same username

On Thu, Apr 14, 2016 at 3:17 AM, Luigi Siciliano luigi...@tiscalinet.it [firebird-support] wrote: > >If a user try to connect from two or more PC with same username, > Firebird accepts the connection but is safe without problems or is best > to avoid like

Re: AW: [firebird-support] How to interprete gstat-results

Hi Olaf, > Database "D:\INTERBASE\IFLS.GDB" > > Database header page information: > >Flags 0 > >Generation 2939162 > >System Change Number0 > >Page size 4096 You might consider increasing to 8K, especially when

[firebird-support] Re: Firebird 2.5.4 - CentOS - mon$remote_address 0.0.0.0

Solution found in this post : Yahoo! Groups https://beta.groups.yahoo.com/neo/groups/firebird-support/conversations/topics/127886 https://beta.groups.yahoo.com/neo/groups/firebird-support/conversations/topics/127886 Yahoo! Groups

AW: [firebird-support] How to interprete gstat-results

Hello Thomas.. Database "D:\INTERBASE\IFLS.GDB" Database header page information: Flags 0 Generation 2939162 System Change Number0 Page size 4096 ODS version 12.0 Oldest

Re: [firebird-support] How to skip a trigger in the same trigger?

2016. 04. 14. 14:00 keltezéssel, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] írta: > 14.04.2016 13:57, Gabor Boros gaborbo...@yahoo.com [firebird-support] wrote: >> I have TBL_MASTER, TBL_DETAIL(this contains ISDEFAULT). You suggest a >> TBL_DETAIL_DEFAULTS table? > > No, I

Re: [firebird-support] How to interprete gstat-results

> Hello @ll, > > > > we are using firebird 3.0 RC2 and have some questions about open > transactions. (Clients connect over odbc) The gstat output gives 7 > transactions between the oldest and the current transaction, if we look into > the monitoring table, we see only 10 transactions. The

Re: [firebird-support] How to skip a trigger in the same trigger?

14.04.2016 13:57, Gabor Boros gaborbo...@yahoo.com [firebird-support] wrote: > I have TBL_MASTER, TBL_DETAIL(this contains ISDEFAULT). You suggest a > TBL_DETAIL_DEFAULTS table? No, I suggest to add DefaultDetail field into TBL_MASTER referencing default record in TBL_DETAIL. -- WBR,

[firebird-support] How to interprete gstat-results

Hello @ll, we are using firebird 3.0 RC2 and have some questions about open transactions. (Clients connect over odbc) The gstat output gives 7 transactions between the oldest and the current transaction, if we look into the monitoring table, we see only 10 transactions. The "oldest one" we

Re: [firebird-support] How to skip a trigger in the same trigger?

2016. 04. 14. 13:27 keltezéssel, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] írta: > You'd better to remove IsDefault field at all and create a reference to > default record > in other table. I have TBL_MASTER, TBL_DETAIL(this contains ISDEFAULT). You suggest a

Re: [firebird-support] How to skip a trigger in the same trigger?

Hello Gabor, >>> First question: why do you have an UPDATE in a BEFORE UPDATE >> trigger on ? >> >>The table have many fields and a UNIQUE constraint with four fields, one >>the ISDEFAULT from it (only one default accepted for groups of rows >>depend on the other three fields (which included

Re: [firebird-support] How to skip a trigger in the same trigger?

Hello Gabor, >> Hi, >> >> First question: why do you have an UPDATE in a BEFORE UPDATE >> trigger on ? > >The table have many fields and a UNIQUE constraint with four fields, one >the ISDEFAULT from it (only one default accepted for groups of rows >depend on the other three fields (which

Re: [firebird-support] How to skip a trigger in the same trigger?

14.04.2016 13:24, Gabor Boros gaborbo...@yahoo.com [firebird-support] wrote: > The table have many fields and a UNIQUE constraint with four fields, one > the ISDEFAULT from it (only one default accepted for groups of rows > depend on the other three fields (which included also in the UNIQUE) >

Re: [firebird-support] How to skip a trigger in the same trigger?

2016. 04. 14. 13:09 keltezéssel, 'Martijn Tonies (Upscene Productions)' m.ton...@upscene.com [firebird-support] írta: > Hi, > > First question: why do you have an UPDATE in a BEFORE UPDATE > trigger on ? The table have many fields and a UNIQUE constraint with four fields, one the ISDEFAULT

Re: [firebird-support] How to skip a trigger in the same trigger?

Hi, First question: why do you have an UPDATE in a BEFORE UPDATE trigger on ? With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! Hi All, I have a BEFORE

[firebird-support] How to skip a trigger in the same trigger?

Hi All, I have a BEFORE UPDATE trigger for MYTABLE1 with an IF ... UPDATE MYTABLE1 and after an IF ... INSERT INTO MYTABLE2 in it. If the UPDATE MYTABLE1 executed the trigger fire himself and the INSERT executed twice. How to skip it? RDB$SET_CONTEXT/RDB$GET_CONTEXT is a good solution? I

Re: [firebird-support] Connecting to Firebird database from two or more pc with same username

> On 14/04/2016 08:26, 'Thomas Steinmaurer' t...@iblogmanager.com > [firebird-support] wrote: >> >> With a single user you basically can't distinguish people on the >> server side through CURRENT_USER etc. >> > We use one Firebird user for the web server, and then one each for each > of several

Re: [firebird-support] Connecting to Firebird database from two or more pc with same username

On 14/04/2016 08:26, 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] wrote: With a single user you basically can't distinguish people on the server side through CURRENT_USER etc. We use one Firebird user for the web server, and then one each for each of several batch

Re: [firebird-support] Connecting to Firebird database from two or more pc with same username

> Hello, > > Il 14/04/2016 09.26, 'Thomas Steinmaurer' t...@iblogmanager.com > [firebird-support] ha scritto: >> >> I guess you mean with the same Firebird user name? Or are you using >> Windows trusted authentication? >> > > Oops, sorry. I mean the same Firebird username. > I notice that in

Re: [firebird-support] Connecting to Firebird database from two or more pc with same username

Hello, Il 14/04/2016 09.26, 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] ha scritto: I guess you mean with the same Firebird user name? Or are you using Windows trusted authentication? Oops, sorry. I mean the same Firebird username. I notice that in an LAN with three

Re: [firebird-support] Connecting to Firebird database from two or more pc with same username

> Hello, > If a user try to connect from two or more PC with same username, > Firebird accepts the connection but is safe without problems or is best > to avoid like the pest? I guess you mean with the same Firebird user name? Or are you using Windows trusted authentication? In general this

[firebird-support] Connecting to Firebird database from two or more pc with same username

Hello, If a user try to connect from two or more PC with same username, Firebird accepts the connection but is safe without problems or is best to avoid like the pest? Thanks. -- Luigi Siciliano --