Re: [firebird-support] Changing collation

2017-06-28 Thread Tomasz Tyrakowski t.tyrakow...@sol-system.pl [firebird-support]
On 27.06.2017 at 19:39, Tomasz Tyrakowski t.tyrakow...@sol-system.pl [firebird-support] wrote: > Is it possible to change the collation of a varchar column in place > (without making a temporary column, copying data, dropping the original > column, making it anew and copying the data back)? Would

[firebird-support] Triggers - One big or more smaller?

2017-06-28 Thread Gabor Boros mlngl...@bgss.hu [firebird-support]
Hi All, The table have a BEFORE UPDATE trigger. Now I need a check before the existing trigger code and raise an exception if needed. I can write the check into the existing trigger before the existing code. But can create a new trigger with a lower position than the existing one. Is there any

Re: [firebird-support] Re: witch vresion of Firebird to choose for Delphi 7 and IBX 7.09

2017-06-28 Thread Louis Kleiman lklei...@sstms.com [firebird-support]
I have used both IBX and FireDAC with the latest Firebird 3.0 as well. Yes, you need to ensure that the correct client DLL is used (including renaming for IBX as others have mentioned), but so far, everything else is just fine in my usage. On Fri, Jun 23, 2017 at 6:26 PM safirh...@yahoo.fr [fireb

Re: [firebird-support] Re: witch vresion of Firebird to choose for Delphi 7 and IBX 7.09

2017-06-28 Thread Vishal Tiwari vishuals...@yahoo.co.in [firebird-support]
Another way to connect to firebird database. Watch out with my video:Delphi Connectivity With Firebird Database | | | | || | | | || Delphi Connectivity With Firebird Database For any further communication, kindly mail to "vishuals...@gmail.com". All valuable sug

Re: [firebird-support] Triggers - One big or more smaller?

2017-06-28 Thread 'livius' liviusliv...@poczta.onet.pl [firebird-support]
Hi, >>practical benefit to breaking up triggers? 1. separate code logically like procedure 2. you can simply disable it without altering content 3. simplify editing by minimize toxicity regards, Karol Bieniaszewski -Oryginalna wiadomość- From: Gabor Boros mlngl...@bgss.hu [firebird-supp

[firebird-support] OT : Documentation Funding 2017 Reached half of the Goal , We need more help to reach the target

2017-06-28 Thread map...@gmail.com [firebird-support]
Documentation Funding 2017 Reached half of the Goal , We need more help to reach the target https://www.firebirdsql.org/en/doc-funding-2017/ https://www.firebirdsql.org/en/doc-funding-2017/

Re: [firebird-support] Triggers - One big or more smaller?

2017-06-28 Thread Dalton Calford dcalf...@distributel.ca [firebird-support]
I prefer more smaller triggers with a specified firing order, along with code at the beginning of the trigger that checks to see if the trigger should fire or not - this allows you to disable a trigger within the scope of a single transaction ie. (a) Update master table that trigger checks - t

Re: [firebird-support] Re: witch vresion of Firebird to choose for Delphi 7 and IBX 7.09

2017-06-28 Thread safirh...@yahoo.fr [firebird-support]
thanks for your answer. my question is about gds32.dll , if i have interbase and firebird installed in the same machine , i think that this dll must be in system32 folder , using IBX components , i think that i am oblige to use gds32.dll . is there any conflict betwene interbase gds32.dll , and

Re: [firebird-support] Re: witch vresion of Firebird to choose for Delphi 7 and IBX 7.09

2017-06-28 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
28.06.2017 19:44, safirh...@yahoo.fr [firebird-support] wrote: > is there any conflict betwene interbase gds32.dll , and firebird gds32.dll > .? Yes. They are quite different and Firebird client won't work with Interbase server good. Contrary is true as well: Interbase client will have pr

Re: [firebird-support] Re: witch vresion of Firebird to choose for Delphi 7 and IBX 7.09

2017-06-28 Thread Louis Kleiman lklei...@sstms.com [firebird-support]
So, the answer to the question is that yes, the DLLs are server specific. But, they don't have to be in System32. Typically, you can put a DLL in the same folder as the parent EXE. You should also be able to put it in a folder in the path, but I doubt the path is a good solution when needing to u

Re: [firebird-support] Changing collation

2017-06-28 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Tue, Jun 27, 2017 at 1:39 PM, Tomasz Tyrakowski t.tyrakow...@sol-system.pl [firebird-support] < firebird-support@yahoogroups.com> wrote: > , > > Is it possible to change the collation of a varchar column in place > (without making a temporary column, copying data, dropping the original > column