[firebird-support] Re: Firebird book on the DVD - three different versions?

2013-06-18 Thread un_spoken
Does anyone know what is contained on the DVD besides PDFs? When you purchase the DVD (which contains an enormous amount of additional resource material) I would like to know what is this enormous amount of material :)

Re: [firebird-support] Re: Firebird book on the DVD - three different versions?

2013-06-18 Thread Helen Borrie
At 07:41 p.m. 18/06/2013, un_spoken wrote: Does anyone know what is contained on the DVD besides PDFs? When you purchase the DVD (which contains an enormous amount of additional resource material) I would like to know what is this enormous amount of material :)

[firebird-support] Re: Recursive lookup

2013-06-18 Thread nols_smit
I don't quite get what you're trying to do, I'll guess, but feel free to reformulate your problem if my guessing is wrong. My guess is that you're trying to do, is to traverse two trees and join them together. Hi, Thanks, you saved my day! To explain what I use this select query for:

[firebird-support] Re: Firebird rookie - help selecting correct Firebird Version

2013-06-18 Thread Geoff
Hi Helen, Many thanks for clarifying.. Geoff --- In firebird-support@yahoogroups.com, Helen Borrie helebor@... wrote: At 11:23 p.m. 16/06/2013, you wrote: Hi, I'm considering using Firebird for my database applications. My applications are not large and certainly cater for (usually!)

[firebird-support] Re: Does Firebird have a way to reference similar named fields? (Like MONTH_1 thru MONTH_120)

2013-06-18 Thread thp_pkmi
I think you have 2 options: 1. normalize the table to have 2 fields Month Number Month Value, then you can search record by Month Number for updating Month Value 2. use PSQL statement: EXECUTE STATEMENT, you can read about it in Firebird-2.5-LangRef-Update.pdf --- In

Re: [firebird-support] Re: Does Firebird have a way to reference similar named fields? (Like MONTH_1 thru MONTH_120)

2013-06-18 Thread Softtech Support
Thanks for your reply. I should have mentioned that this stored procedure is used to generate a Stair-Step Financial Report (My first attempt at such a report I might add) and therefore option 1 below would not work as I do not need to store the results. I have used EXECUTE STATEMENT in the

[firebird-support] Charset for external table filename

2013-06-18 Thread Kjell Rilbe
Hi, I just tried to create an external table with a filename that contains ö. The database charset is UTF-8 and I did it from FlameRobin using UTF-8 as connection character set. It failed because the filename obviously got encoded as UTF-8, and passed like that to the server's file system,

[firebird-support] Primary Key Initial Value

2013-06-18 Thread jwcane2003
In creating a new table, how is primary key set to begin at a value other than 0 or 1?

Re: [firebird-support] Primary Key Initial Value

2013-06-18 Thread Norman Dunbar
Afternoon jwcane2003, On 18/06/13 14:26, jwcane2003 wrote: In creating a new table, how is primary key set to begin at a value other than 0 or 1? Imagine this: create table whatever ( pk_column bigint not null , other_stuff char(100), ... ); commit; alter table whatever add

Re: [firebird-support] Primary Key Initial Value

2013-06-18 Thread André Knappstein
In creating a new table, how is primary key set to begin at a value other than 0 or 1? begin suggests that you plan on some form of auto-incrementing a value for the primary key field? If so, I'd say you'll need a generator anyway. You can set this generator to any (valid) value you

[firebird-support] Problem with not null fields

2013-06-18 Thread rejanemyszka2002
Hello, I have some BDs, where fields not null are without the check not null. For example, all tables have a field 'codigo' not null, now all this fields are not check not null. Someone know what could happened? Could be some option or problem in restore? Thanks Rejane

[firebird-support] Why a database grows after a cycle backup/restore?

2013-06-18 Thread W O
Hello everybody Which can be the cause that a database of 3.1 gigabytes grows to 4.2 gigabytes after a cycle backup/restore? The file FIREBIRD.CONF seems normal, nothing strange there. Growing 1.1 gigabytes seems to me too much. Greetings. Walter. [Non-text portions of this message have

RE: [firebird-support] Why a database grows after a cycle backup/restore?

2013-06-18 Thread Leyne, Sean
Walter, Which can be the cause that a database of 3.1 gigabytes grows to 4.2 gigabytes after a cycle backup/restore? The file FIREBIRD.CONF seems normal, nothing strange there. Growing 1.1 gigabytes seems to me too much. To be clear, it is source database or the backup file 3.1GB? Sean

Re: [firebird-support] Why a database grows after a cycle backup/restore?

2013-06-18 Thread W O
The source database has 3.1 Gb but after the backup/restore have 4.2 Gb Seems very strange for me. Greetings. Walter. On Tue, Jun 18, 2013 at 6:03 PM, Leyne, Sean s...@broadviewsoftware.comwrote: ** Walter, Which can be the cause that a database of 3.1 gigabytes grows to 4.2

Re: [firebird-support] Why a database grows after a cycle backup/restore?

2013-06-18 Thread Alexandre Benson Smith
Em 18/6/2013 19:44, W O escreveu: The source database has 3.1 Gb but after the backup/restore have 4.2 Gb Seems very strange for me. Greetings. Walter. Just a shot in the dark... Could be that the original database was restored with -USE_ALL_SPACE and the new database was not be

[firebird-support] Understanding query performance changes

2013-06-18 Thread garethm
Hi, In upgrading from Firebird 2.0 to Firebird 2.5, I have a query that has dramatically changed performance. It would be great if I could understand the performance information given in FlameRobin, and how this can be used to return the query to its former performance. The statistics