[Firebird-devel] [FB-Tracker] Created: (CORE-4598) 'set bail on' command is ignored when script is run "inside" ISQL using 'IN ' (rather than from command line switch, i.e. isql -i

2014-11-06 Thread Pavel Zotov (JIRA)
'set bail on' command is ignored when script is run "inside" ISQL using 'IN ' (rather than from command line switch, i.e. isql -i ) -

Re: [Firebird-devel] SET TRANSACTION option to disable replication

2014-11-06 Thread Dimitry Sibiryakov
06.11.2014 19:24, Mark Rotteveel wrote: > I don't really understand why you would want to disable replication for > a single transaction. There may be a number of reason. The main one is that this transaction is performed by replicator and I don't want changes to be bounced back in bidirectio

[Firebird-devel] [FB-Tracker] Created: (CORE-4597) 'show exception' command hangs on empty database

2014-11-06 Thread Pavel Zotov (JIRA)
'show exception' command hangs on empty database Key: CORE-4597 URL: http://tracker.firebirdsql.org/browse/CORE-4597 Project: Firebird Core Issue Type: Bug Reporter: Pavel Zotov

Re: [Firebird-devel] Odp: Adding/removing NOT NULL from column in one DDL

2014-11-06 Thread Jiří Činčura
That’s my escape plan. Currently still hoping for “direct” solution. :) -- Mgr. Jiří Činčura Independent IT Specialist -- Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebi

Re: [Firebird-devel] SET TRANSACTION option to disable replication

2014-11-06 Thread Mark Rotteveel
On 6-11-2014 16:40, Dimitry Sibiryakov wrote: > Hello, All. > > I wonder if SQL standard says something about syntax of transaction's > option for > disabling replication of changes made by this transaction? There is no such option, the syntax is: ::= SET [ LOCAL ] TRANSACTION ::=

[Firebird-devel] SET TRANSACTION option to disable replication

2014-11-06 Thread Dimitry Sibiryakov
Hello, All. I wonder if SQL standard says something about syntax of transaction's option for disabling replication of changes made by this transaction? -- WBR, SD. -- Firebird-Devel mailing list, web interfac

[Firebird-devel] Odp: Adding/removing NOT NULL from column in one DDL

2014-11-06 Thread liviusliv...@poczta.onet.pl
Hi, Try execute block this will be "one" statement if this is your point about "one" Regards, Karol Bieniaszewski - Reply message - Od: "Jiří Činčura" Do: "For discussion among Firebird Developers" Temat: [Firebird-devel] Adding/removing NOT NULL from column in one DDL Data: czw., l

Re: [Firebird-devel] Adding/removing NOT NULL from column in one DDL

2014-11-06 Thread Jiří Činčura
> This will be available in Firebird 3. I know, but that's not what I asked for. I'm looking for "some" way. I was trying: alter table aaa_test drop constraint ( select rc.rdb$constraint_name from rdb$relation_constraints rc join rdb$check_constraints cc on rc.rdb$constraint_nam

Re: [Firebird-devel] Adding/removing NOT NULL from column in one DDL

2014-11-06 Thread Thomas Steinmaurer
Hi, > Is there a way to add/remove NOT NULL to a column using single DDL command in > Firebird (2.5 for the start)? I'm tuning support for Entity Framework > Migrations in .NET provider and this is one case. This will be available in Firebird 3. Regards, Thomas -

[Firebird-devel] Adding/removing NOT NULL from column in one DDL

2014-11-06 Thread Jiří Činčura
Hi, Is there a way to add/remove NOT NULL to a column using single DDL command in Firebird (2.5 for the start)? I'm tuning support for Entity Framework Migrations in .NET provider and this is one case. -- Mgr. Jiří Činčura Independent IT Specialist

Re: [Firebird-devel] Thanks for all the fish!

2014-11-06 Thread marius adrian popa
Sad day indeed , And i'm left speachless We can only thank for your contribution to the Firebird and Lazarus world Yesterday i saw one of your marvels http://free-pascal-lazarus.989080.n3.nabble.com/Lazarus-ANN-Visual-Query-tool-for-SQLDB-Zeos-IBX-td4039061.html On Thu, Nov 6, 2014 at 12:15 PM, R

[Firebird-devel] Thanks for all the fish!

2014-11-06 Thread Reinier Olislagers
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Cross-posted to FPC db-core and Lazarus dev list; please keep confidential. Hi all, Unfortunately, I was diagnosed with (probably fatal) metastatic colon cancer a bit over 6 years ago. Since then, despite health difficulties, I've found a lot of d