Re: [firebird-support] deploy Windows Application to access Firebird database

2016-08-28 Thread Alain Bastien alainbast...@gmail.com [firebird-support]
Does it apply to remote servers also such as www.myserver.com:/opt/database/fbdata.fdb The release note README file in the embbeded zip says: // 2.2. Database access Client access can be only via the local protocol, i.e. *NOT a TCP/IP connection string that includesthe server

RE: [firebird-support] Help needed with grouping, GROUP BY and LIST()

2016-08-28 Thread 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
Mike, What’s performance like? Sean From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: August 28, 2016 5:25 PM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] Help needed with grouping, GROUP BY and LIST() Sean, Have a look at my

Re: [firebird-support] Help needed with grouping, GROUP BY and LIST()

2016-08-28 Thread Mike Ro miker...@gmail.com [firebird-support]
Sean, Have a look at my reply to your second question, about using CTE, that will be part of your answer for this problem as well. FYI: LIST() doesn't observe ORDER BY... Thanks to your hint and example CTE I was able to get my query fully working as follows. Sorry, there are a couple of

Re: [firebird-support] After update trigger: the same values for new.somefiled and old.somefield

2016-08-28 Thread setysvar setys...@gmail.com [firebird-support]
Den 28.08.2016 12:55, skrev 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]: > I'm using Firebird 2.5.2.26539. Any chance that another trigger is changing the value? >>> I was thinking that myself, but Patrick said that it was the "old" value >>> which >> was being changed

RE: [firebird-support] After update trigger: the same values for new.somefiled and old.somefield

2016-08-28 Thread 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
> >>> I'm using Firebird 2.5.2.26539. > >> > >> Any chance that another trigger is changing the value? > > > > I was thinking that myself, but Patrick said that it was the "old" value > > which > was being changed to the "new" value. > > Right. Perhaps NEW is changed to OLD? Patrick?? Please

Re: [firebird-support] After update trigger: the same values for new.somefiled and old.somefield

2016-08-28 Thread Thomas Steinmaurer t...@iblogmanager.com [firebird-support]
Hello Sean, >>> For some reason they both have the new value and I can't figure out why. >>> If I didn't misread all the articles, I've found, completely, then >>> they should be different, shouldn't they? >>> >>> >>> I'm using Firebird 2.5.2.26539. >> >> Any chance that another trigger is