[firebird-support] How to determine Role of attached user?

2015-05-25 Thread Stefan Heymann li...@stefanheymann.de [firebird-support]
Hallo all, when I call SELECT * FROM MON$ATTACHMENTS (logged in as the database owner), the MON$ROLE field always shows 'NONE', even when the user is logged in with a specific role. Is there a way to find out the role another user (with a specifid attachment_id) is logged in? Using Firebird

[firebird-support] How to CAST float to integer with error?

2015-05-25 Thread brucedickin...@wp.pl [firebird-support]
Hello, is it possible by using CAST or in any other way to get database error when casting such number to integer? SELECT CAST('13.245' AS INTEGER) FROM RDB$DATABASE This gives 13 but instead I would like to get an error because precision is lost. However, I would like to NOT get an error

[firebird-support] Backup Restore NOT NULL Columns

2015-05-25 Thread Hugo Eyng hugoe...@msn.com [firebird-support]
Hello. 1 - I created a column NOT NUL in a table (ALTER TABLE MYTABLE ADD NEW_COLUMN INTEGER NOT NULL). There were already some records in the table. FB didn´t raise any warning or exception. 2 - I created a backup file from MYDB.FDB using gbak. FB didn´t raise any warning or exception. 3- I

[firebird-support] Firebird 2.5x on Windows 2012 with BitLocker Encrypted HDD, RAID 1

2015-05-25 Thread firebirdbest...@yahoo.com [firebird-support]
Does anyone do this? Are there any problems?

Re: [firebird-support] How to determine Role of attached user?

2015-05-25 Thread 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]
Hello Stefan, Hallo all, when I call SELECT * FROM MON$ATTACHMENTS (logged in as the database owner), the MON$ROLE field always shows 'NONE', even when the user is logged in with a specific role. Is there a way to find out the role another user (with a specifid attachment_id) is logged

Re: [firebird-support] Backup Restore NOT NULL Columns

2015-05-25 Thread 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]
Hugo, Hello. 1 - I created a column NOT NUL in a table (ALTER TABLE MYTABLE ADD NEW_COLUMN INTEGER NOT NULL). There were already some records in the table. FB didn´t raise any warning or exception. 2 - I created a backup file from MYDB.FDB using gbak. FB didn´t raise any warning or