> SYSDBA users can see other connected users using monitoring tables
> but is it possible to implement such feature for non-SYSDBA users? Are
> there event/triggers that act uppon connecting and disconnecting and
> which can insert usual database records. Triggers no MON$ tables are
> not suit
Dne 31. 1. 2017 v 10:14 Köditz, Martin martin.koed...@it-syn.de
[firebird-support]:
> does anybody know an elegant statement to create random dates? It
> would be perfect to define a range.
select DATEADD(FLOOR(365*RAND()) DAY TO DATE'2016-1-1') from rdb$database;
RAND() returns DOUBLE PRECISIO
> I have a query with a between operator on a non-indexed varchar(30)
field – currently on FB 2.5 :
>
> … where MYFIELD between ’AHH00091/2017’ and ’AHH00141/2017’
>
> I would expect 51 records from 91 to 141 all ending with /2017 but
> surprisingly, records ending with /2016 or /2015, etc.
> We're in the process of changing an application that accesses a Firebird
> database file from a regular application to a windows
> service. For legacy reasons this uses the Firebird embedded DLL (fbclient)
> for version 1.5.6. The code that attempts to connect to
> this file always succeeds
> I have a huge table to import - tens millions of rows.
> From my experience, it is not good practice to commit job after importing
> everything, because import of rows can become slower and
> slower.
> So, i decided to make commit after every 50.000 rows. So far so good.
There is no reason to