Re: [Firebird-devel] how to use "set bind" in F4

2020-03-25 Thread Steve Bailey
Hi,  >>  Subject:Re: [Firebird-devel] how to use "set bind" in F4 >>  Date:25 March 2020 08:40 >>  From:Norbert Saint Georges  >>  To: >> >>  Ok, I'll say how I do it, but it's not the best way at all, really not. >>  I downloa

Re: [Firebird-devel] how to use "set bind" in F4

2020-03-25 Thread Mark Rotteveel
On 2020-03-25 09:18, Steve Bailey wrote: I have downloaded Firebird-4.0.0.1817_x64.zip but I am not sure how to deploy it. Do I just copy it over the 1436 installation (except for conf files)? There were changes between the beta 1 release and the current snapshots of Firebird 4. I'd recommend

Re: [Firebird-devel] how to use "set bind" in F4

2020-03-25 Thread Norbert Saint Georges
Ok, I'll say how I do it, but it's not the best way at all, really not. I download the two versions (32x & 64x) which I decompress in each in a temporary sub-folder. For the 64x version, after stopping the FB4 service, I copy the whole folder without the .conf or security4.fdb in the FB4 insta

Re: [Firebird-devel] how to use "set bind" in F4

2020-03-25 Thread Steve Bailey
Hi,  >>  Steve Bailey a écrit : >>  > So, where do I get 1815 from? >> >>  http://web.firebirdsql.org/download/snapshot_builds/win/4.0/ >> >>  to day, 1817 :-) Thanks. My current (1436) installation was installed using the downloaded Windows executable installer - recommended for first-time user

Re: [Firebird-devel] how to use "set bind" in F4

2020-03-24 Thread Norbert Saint Georges
Steve Bailey a écrit : So, where do I get 1815 from? http://web.firebirdsql.org/download/snapshot_builds/win/4.0/ to day, 1817 :-) -- Norbert Saint Georges http://tetrasys.fi Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] how to use "set bind" in F4

2020-03-24 Thread liviuslivius
Go to download snapshots fb4Regards,Karol Bieniaszewski nullFirebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] how to use "set bind" in F4

2020-03-24 Thread Steve Bailey
Hi,  >>  Steve Bailey a écrit : >>  > ( I am using WI-T4.0.0.1436 Firebird 4.0 Beta 1 on Windows 10.) >> >>  you need to update the version of Firebird 4 currently 1815. >>  In your version, 1436, this was not yet implemented. Ok, thanks. However, before responding to this thread I did check at

Re: [Firebird-devel] how to use "set bind" in F4

2020-03-24 Thread Norbert Saint Georges
Steve Bailey a écrit : ( I am using WI-T4.0.0.1436 Firebird 4.0 Beta 1 on Windows 10.) you need to update the version of Firebird 4 currently 1815. In your version, 1436, this was not yet implemented. -- Norbert Saint Georges http://tetrasys.fi Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] how to use "set bind" in F4

2020-03-24 Thread Steve Bailey
Hi,  >>  'SET BIND OF TIME ZONE TO LEGACY I have tried to execute the above SQL with no success. I tried from iSQL, from IBExpert and from a test Delphi app. Each time I got the error:"Invalid token.Dynamic SQL Error.SQL error code = -104.Token unknown - line 1, column 5.BIND." Also, I cannot fi

Re: [Firebird-devel] how to use "set bind" in F4

2020-03-24 Thread Gregor Kobler via Firebird-devel
Thanks a lot it helped Sent from Yahoo Mail. Get the app On Tuesday, March 24, 2020, 3:22:46 PM GMT+1, Norbert Saint Georges wrote: Gregor Kobler via Firebird-devel a écrit : > Hello > How can i use the clause > SET TIME ZONE BIND { NATIVE | LEGACY } > I ise Delphi Rio 10.3.3 with F

Re: [Firebird-devel] how to use "set bind" in F4

2020-03-24 Thread Norbert Saint Georges
Gregor Kobler via Firebird-devel a écrit : Hello How can i use the clause SET TIME ZONE BIND { NATIVE | LEGACY } I ise Delphi Rio 10.3.3 with FireDAC. Should i made it as a parameter somewhere at the connection component? Or should i run it as a SQL-Statement? How can i set this bind, i have no

Re: [Firebird-devel] how to use "set bind" in F4

2020-03-24 Thread Dimitry Sibiryakov
24.03.2020 14:41, Gregor Kobler via Firebird-devel wrote: How can i use the clause As described in documentation: a) Set compatibility level in firebird.conf; b) Issue needed statements in attachments or set in DPB; c) Issue the statements in OB CONNECT trigger. -- WBR, SD. Firebird-De

Re: [Firebird-devel] how to use "set bind" in F4

2020-03-24 Thread Alex Peshkoff via Firebird-devel
On 2020-03-24 16:41, Gregor Kobler via Firebird-devel wrote: Hello How can i use the clause SET TIME ZONE BIND { NATIVE | LEGACY } I ise Delphi Rio 10.3.3 with FireDAC. Should i made it as a parameter somewhere at the connection component? Or should i run it as a SQL-Statement? How can i set

[Firebird-devel] how to use "set bind" in F4

2020-03-24 Thread Gregor Kobler via Firebird-devel
Hello How can i use the clause SET TIME ZONE BIND { NATIVE | LEGACY } I ise Delphi Rio 10.3.3 with FireDAC. Should i made it as a parameter somewhere at the connection component? Or should i run it as a SQL-Statement? How can i set this bind, i have no idea. Thanks for any hint Gregor Firebird-De