Re: Re: [firebird-support] Steps to Set Wait/No Wait Transaction

2017-01-13 Thread Vishal Tiwari vishuals...@yahoo.co.in [firebird-support]
Thank You. Let me check. On Friday, 13 January 2017 1:13 PM, "liviuslivius liviusliv...@poczta.onet.pl [firebird-support]" wrote:   Hi, dbClick on IBTransaction component and you got Transaction editor - and there you have all valuesgoogle for each value regards,Karol Bieniaszewski 

Re: [firebird-support] Firebird : join table from two database

2017-01-13 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 12-1-2017 21:44, startx252...@yahoo.fr [firebird-support] wrote: > What is the way to make a join from 2 tables in two respective database > (in same server) ? > > ex : > > Db1 > TableA > > > Db2 > TableB > > > how can i make somethink like this : > > SELECT tA.MATRICRS, tB.name, tB.age > FROM T

Re: [firebird-support] Time zones

2017-01-13 Thread Stefan Heymann li...@stefanheymann.de [firebird-support]
There are requests to implement Time zones in Firebird: http://tracker.firebirdsql.org/browse/CORE-694 http://tracker.firebirdsql.org/browse/CORE-909 These two are in the "Optional features" list for Firebird 4: https://www.firebirdsql.org/en/planning-board/ Best Regards Stefan -- Stefan H

[firebird-support] Re: Time zones

2017-01-13 Thread Tim Ward t...@telensa.com [firebird-support]
On 12/01/2017 14:09, Tim Ward wrote: > Sorry if this is a really basic question, but some time spent > searching has failed to find for me the definitive detailed > documentation on exactly how Firebird handles time zones (I'm > particularly interested, to start with, in using CURRENT_TIMESTAMP

[firebird-support] Re: Time zones

2017-01-13 Thread Tim Ward t...@telensa.com [firebird-support]
However what I'm actually seeing is as follows. (1) Set a Linux machine to "Brazil/East". Check this using the "date" command line command. (2) Confirm that select CURRENT_TIMESTAMP from rdb$database does report the Brazilian local time as expected. (3) Next, I've got a table with a TIMESTAMP

Re: [firebird-support] Re: Time zones

2017-01-13 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
13.01.2017 13:09, Tim Ward t...@telensa.com [firebird-support] wrote: > I just don't believe this. Can anyone make any other suggestion as to > what is going on? Is timezone on your Linux set globally or for each current user environment independently? -- WBR, SD. -

Re: [firebird-support] Re: Time zones

2017-01-13 Thread Tim Ward t...@telensa.com [firebird-support]
On 13/01/2017 14:04, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 13.01.2017 13:09, Tim Ward t...@telensa.com [firebird-support] wrote: >> I just don't believe this. Can anyone make any other suggestion as to >> what is going on? > Is timezone on your Linux set globally or

Re: [firebird-support] Re: Time zones

2017-01-13 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
13.01.2017 16:46, Tim Ward t...@telensa.com [firebird-support] wrote: > One thing I've now noticed is that running the trigger by updating a > record via isql gives the correct, Brazilian, answer. If you are running isql and connected to database in embedded mode, your current environment is