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 "D:\I
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.
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 the pest?
>
Firebird keeps track of
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
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
https://beta.groups.yahoo.com/neo/groups/firebird-supp
Thank you Ed !
That solved my problem !
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 transa
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 sugges
> 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 "
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, SD.
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
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
TBL_DETAIL_DEFAU
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 also
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 included
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)
> valu
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 from
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
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 never
> 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
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 processes,
> 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
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 user
> 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
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
--
24 matches
Mail list logo