[firebird-support] Re: GROUP BY odd results - can someone explain please?

Thanks for the replies. - Same results with ISQL + CTE - FB version 2.1.3.18185 SS on Windows 2008 Server R2 (on a VM) - will validate the db when possible. Database info ODS Version 11.1 Page Size 8192 Pages 163560 Size on Disk 1.25GB SQL Dialect 3 Default Character Set NONE

Re: [firebird-support] How to retrieve list of users granted with the admin role

Thanks Mark, I've tried executing fbsvcmgr (from the MS DOS prompt) but both action_display_user_adm and action_display_user are always returning no for the adm column. [WI-T3.0.0.30809 Firebird 3.0 Alpha 2] Kind regards, Robert

Re: [firebird-support] How to retrieve list of users granted with the admin role

On 20 Jun 2014 04:53:39 -0700, r...@xs4all.nl [firebird-support] firebird-support@yahoogroups.com wrote: Thanks Mark, I've tried executing fbsvcmgr (from the MS DOS prompt) but both action_display_user_adm and action_display_user are always returning no for the adm column. [WI-T3.0.0.30809

Re: [firebird-support] Re: GROUP BY odd results - can someone explain please?

On 20 Jun 2014 03:54:42 -0700, tomconl...@gmail.com [firebird-support] firebird-support@yahoogroups.com wrote: Thanks for the replies. - Same results with ISQL + CTE - FB version 2.1.3.18185 SS on Windows 2008 Server R2 (on a VM) - will validate the db when possible. Firebird 2.1.3 is

RE: [firebird-support] CORE-4467

So I was redirected to the list to discuss http://tracker.firebirdsql.org/browse/CORE-4467. In the case you indicate that you are using a trigger to calculate the statistics for all indexes. Why are you doing this from a trigger? (instead of running a script on a scheduled basis)

Re: [firebird-support] CORE-4467

El 20/06/2014, a las 21:33, Ivan Arabadzhiev intelru...@yahoo.com [firebird-support] firebird-support@yahoogroups.com escribió: So I was redirected to the list to discuss http://tracker.firebirdsql.org/browse/CORE-4467. What I can add is that it occurred to me to run a validation on

Re: [firebird-support] CORE-4467

Index recalculation (I think) was done to minimize the configuration needed (unfortunately, I wasn`t involved in the initial design). Non the less - it hasn`t been an issue for the past 7-8 years and is still working in most instances. The error count comes from a full validation with gfix (done

RE: [firebird-support] CORE-4467

Index recalculation (I think) was done to minimize the configuration needed (unfortunately, I wasn`t involved in the initial design). Non the less - it hasn`t been an issue for the past 7-8 years and is still working in most instances. The error count comes from a full validation with gfix