Re: [firebird-support] Re: Firebird 2.5 (64 bit), strange SQL result

2012-05-07 Thread Thomas Steinmaurer
> --- In firebird-support@yahoogroups.com, Alexandre Benson Smith > wrote: >> >> Em 7/5/2012 21:51, trskopo escreveu: >>> Hi all, >>> >>> I run sql statement via flamerobin, the statment is like this : >>> >>> SELECT * FROM M_INT_FRM a >>> where a.ID_TRS_TYP = 100 >>> >>> It will returns : >>> >>

[firebird-support] cannot attach to password database

2012-05-07 Thread Tom Munro Glass
I have a datalogging application installed at around 80 sites running 24x7 on CentOS 5, FB 2.1.4 Classic. There are typically 2 or 3 clients, one of which is constantly acquiring data and storing it in the database. The database is usually 2-3GB. This is all working extremely well, but I have noti

[firebird-support] Re: Firebird 2.5 (64 bit), strange SQL result

2012-05-07 Thread trskopo
--- In firebird-support@yahoogroups.com, Alexandre Benson Smith wrote: > > Em 7/5/2012 21:51, trskopo escreveu: > > Hi all, > > > > I run sql statement via flamerobin, the statment is like this : > > > > SELECT * FROM M_INT_FRM a > > where a.ID_TRS_TYP = 100 > > > > It will returns : > > > > ID

Re: [firebird-support] Firebird 2.5 (64 bit), strange SQL result

2012-05-07 Thread Alexandre Benson Smith
Em 7/5/2012 21:51, trskopo escreveu: > Hi all, > > I run sql statement via flamerobin, the statment is like this : > > SELECT * FROM M_INT_FRM a > where a.ID_TRS_TYP = 100 > > It will returns : > > ID ID_DIV_LC SCT_INI ID_TRS_TYP FRM_INI > > 4 8 MP

[firebird-support] Firebird 2.5 (64 bit), strange SQL result

2012-05-07 Thread trskopo
Hi all, I run sql statement via flamerobin, the statment is like this : SELECT * FROM M_INT_FRM a where a.ID_TRS_TYP = 100 It will returns : ID ID_DIV_LC SCT_INI ID_TRS_TYP FRM_INI 4 8 MP 100PO 5 9 MN 100PO 6

[firebird-support] SV: substring

2012-05-07 Thread Poul Dige
Try Select substring('Mahesh/pra' from 9 for 1) Kind regards Poul Fra: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] På vegne af Mahesh Pratihari Sendt: 7. maj 2012 16:44 Til: firebird-support@yahoogroups.com Emne: [firebird-support] substring Hi , Could you plea

[firebird-support] substring

2012-05-07 Thread Mahesh Pratihari
Hi , Could you please help me how to get the reverse substring in Firebird like in SQL SELECT SUBSTRING('Mahesh/pra',9,1) Which will returns 'r' in SQL , but in firebird in is returning null values, Please help me Thanks, Mahesh Pratihari Sonata Software Limited Phone : +9

RE: [firebird-support] RE: Unique foreign key for child tables

2012-05-07 Thread Rick Debay
Clever. I'll take a look at it. > What isn't prevented is addition of parentless children, but you didn't > mention that. Sad, but it's allowed. -Original Message- From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Svein Erling Tysvær Sent: S

[firebird-support] Re: Slow Commit - Email found in subject

2012-05-07 Thread philippe makowski
aalliana [2012-05-07 15:17] : > Is it safe to just disable the barriers bit or should I use ext 3 filesystem? from http://kernel.org/doc/Documentation/filesystems/ext4.txt : When comparing versus ext3, note that ext4 enables write barriers by default, while ext3 does not enable write barr

[firebird-support] Re: Slow Commit - Email found in subject

2012-05-07 Thread aalliana
Thanks Sean, Somehow the thread got split, I'm not sure why. New box has ext4 with the barrier bit set. On the other part of the thread I got adviced to check this parameter. It surely helped performance to disable it. Is it safe to just disable the barriers bit or should I use ext 3

[firebird-support] Database shut down question

2012-05-07 Thread Tomasz Tyrakowski
Hi, According to the gfix manual (http://www.firebirdsql.org/manual/gfix-dbstartstop.html), in a normal shut down mode "unlimited connections can be made by the SYSDBA or the database owner". Unfortunately, that's not the whole truth. Any user can connect with the RDB$ADMIN role (of course, on