[firebird-support] Moving from 2 to 2.5?

2012-05-25 Thread Maury Markowitz
I would like to test the transition from 2.x to 2.5 on a backup machine we have. Am I correct in believing I can simply move the data files over and point the 2.5 server at them? The only note I found on this was this: http://www.firebirdnews.org/?p=5027 Which appears to detail problems in one

RES: [firebird-support] Moving from 2 to 2.5?

2012-05-25 Thread Fabiano
Yes you can, but the best approach is create a backup with 2.x version then restore in 2.5 to get the advantages of new ODS. De: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Em nome de Maury Markowitz Enviada em: sexta-feira, 25 de maio de 2012 07:57 Para: firebird

[firebird-support] Left join and computed columns

2012-05-25 Thread Rick Debay
A query with a left join to a table with a computed column returned values in the computed column even though the row didn't exist in the table. All other non-computed values came back as null, which was to be expected. Is this a bug, or correct by SQL specifications? Disclaimer: This message (in

RE: [firebird-support] Left join and computed columns - Email found in subject

2012-05-25 Thread Leyne, Sean
Rick, > A query with a left join to a table with a computed column returned values in > the computed column even though the row didn't exist in the table. All > other non-computed values came back as null, which was to be expected. > Is this a bug, or correct by SQL specifications? I don't have

[firebird-support] Re: Transaction tracing

2012-05-25 Thread JackR
It's not a stand-alone tool like I think the MS SQL Profiler is, but Dev Art makes a tool called dbMonitor that takes input from a component you can create on your data module. The tool is available on their website and works with their DBExpress drivers. --- In firebird-support@yahoogroups.co

Re: [firebird-support] Role permissions

2012-05-25 Thread Michael Ludwig
Newbie schrieb am 24.05.2012 um 19:36 (+0300): > I tried to grant execute permission for stored procedures for a role. > but when this procedure is executed by a user in this role I get > message, that rights doesn't exist on table. > > I see in IBExpert DDL that grant select on tables used by tha