RE: [firebird-support] FB3 alter domain colltion

2018-05-17 Thread 'Primoz Jenko' primoz.je...@domplan.si [firebird-support]
Hi! From FB manual, FB 2.5.x: What ALTER DOMAIN Cannot Alter * If the domain was declared as an array, it is not possible to change its type or its dimensions; nor can any other type be changed to an ARRAY type. * In Firebird 2.5 and lower, the NOT NULL constraint can be neither enabled

Re: [firebird-support] Doubts about Firebird in Linux....

2018-05-17 Thread 'Ismael L. Donis Garcia' sli...@natio.co.cu [firebird-support]
I'm running Firebird 2.5.8 on Devuan Jessie with ext4 and works very well Best Regards -- Ismael Devuan User : http://distrowatch.com/table.php?distribution=devuan >- Original Message - >From: Omacht András aoma...@mve.hu [firebird-support] >To: firebird-support@yahoogroups.com >Sent: Th

[firebird-support] New Firebird Admin tool called FireBolt. Replaces FlameRobin on Windows Server 2016

2018-05-17 Thread firebirdbest...@yahoo.com [firebird-support]
I'm a long time FlameRobin user and Firebird lover. After a server upgrade, I found that FlameRobin doesn't run on Windows Server 2016. Here's the cure: New Firebird admin tool called FireBolt. Replaces FlameRobin. Get your copy here: https://www.jetlyt.ca/ Learn more here: https://

Re: [firebird-support] FB3 alter domain colltion

2018-05-17 Thread 'livius' liviusliv...@poczta.onet.pl [firebird-support]
Hi, >>There is no way to change the default collation without dropping the domain >>and recreating it with the desired attributes. >>Perhaps tool like IBExpert could do this – alter and set collation? Not sure. this was for FB2.5 where users could modify system tables but now in FB3 it is proh

Re: [firebird-support] Bulk upload options

2018-05-17 Thread fabia...@itbizolutions.com.au [firebird-support]
Hi This article explains the solutions to Bulk upload, http://www.firebirdfaq.org/faq209/ Like Firebird FAQ already thought of many issues Cheers, Fabian - Original Message - From: "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]" To: Sent: Wednesday, May 16, 2018 7:1

Re: [firebird-support] Doubts about Firebird in Linux....

2018-05-17 Thread Aldo Caruso aldo.car...@argencasas.com [firebird-support]
Hi András,   if your file system has barrier enabled ( ext4 by default has it ), ant you set forced writes ON, then massive updates will be very slow. You should decide between setting FW On or using a file system with barrier activated.     There has been a thread in this forum about this p

Re: [firebird-support] Firebird ADO.NET: ExecuteNonQuery Returns -1 On Successful Insert

2018-05-17 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
Steve Naidamast wrote: > I am using the Firebird 2.5 Embedded Edition with the Firebird > ADO.NET provider version 5.5 or 5.7. I am not sure which, since it > has been so long since I set up the references for my project and > the assembly being used is not taken from the actual provider > librar

RE: [firebird-support] FB3 alter domain colltion

2018-05-17 Thread 'Primoz Jenko' primoz.je...@domplan.si [firebird-support]
Hi, we have 2.05, tough. So I am not sure for 3.x. Sorry. Well, if you install IBExpert or some similar tool, you would be able to see immediately. Best regards, Primoz From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Thursday, May 17, 2018 5:58 PM To: f