[firebird-support] Timeout occurred while waiting for a secondary connection for event processing

2013-05-23 Thread sir_wally_lewis
Does anyone know what this means? Simply trying to open a dataset and I get this error just after the system simply stops. Server Version: LI-V6.3.1.26351 Firebird 2.5

Re: [firebird-support] RDB$PAGES

2013-05-23 Thread Tomas Krejzek
Hi Alexey, thank you for this tool, it do exactly what I want. I calculate the size of database from mon$database - as number * size of pages - so total count of pages I know. Best regards, Tomas Dne 24.5.2013 6:31, Alexey Kovyazin napsal(a): > Hi, > > You can use our free product DBInfo > ht

Re: [firebird-support] RDB$PAGES

2013-05-23 Thread Alexey Kovyazin
Hi, You can use our free product DBInfo http://ib-aid.com/products/firebird_interbase/monitoring/dbinfo Also, you can divide size of your database in bytes to the page size of your database. Regards, Alexey Kovyazin IBSurgeon > Hi, I'd like to get the count of all types of db pages. > > If I

[firebird-support] Total Newbie Question:Can Firebird Provide a FileMaker Pro-Like GUI Environment?

2013-05-23 Thread tatihulot
Hello. I just discovered Firebird early this morning, and have spent a portion of today researching it. There is one question I have about it. I'm not 100% if there is a graphic user interface or not. I've seen screen shots that look like GUI, but I'm not sure if I'd have to add a GUI myself,

Re: [firebird-support] RDB$PAGES

2013-05-23 Thread Ann Harrison
On Thu, May 23, 2013 at 4:31 AM, tomkrej wrote: > Hi, I'd like to get the count of all types of db pages. > The easy answer is to use gstat which will tell you how many pages are used by data and indexes for each table. It does not track blobs that are larger than a page, nor does it track the

Re: [firebird-support] Backup Firebird Error

2013-05-23 Thread Ann Harrison
On Wed, May 22, 2013 at 4:20 PM, Marco Sucuzhañay < msucuzhanay.act...@gmail.com> wrote: > When generating a backup of the database shows me the message: > > gbak: ERROR database file appears corrupt() > gbak: ERROR wrong page type > gbak: ERROR page 2401 is of wrong type > gbak: ERROR gds_$ge

[firebird-support] Query on Double Precision Field Produces Incorrect Reults

2013-05-23 Thread Craig Cox
FB 2.5 SQL Query using IBExpert (Stand alone), and using IBObjects (in a Delphi Application). I have a double precision field that contains a value of 0.39. When I query for the value, I get 0.000 in the IBExpert result, and my Delphi application. When I inspect the table holding the val

Re: [firebird-support] Problem with Sharp s and UNICODE_CI_AI

2013-05-23 Thread Stefan Heymann
>> In test 4you compare lower letter "f" with upper letter "F" then you got >> difference. >> All is ok in this test case > The collation being used should be case insensitive. Test 4 results show it > is not, so all is not well. > Or am I reading this wrong? No. Test 3 proves that the case inse

RES: [firebird-support] RDB$PAGES

2013-05-23 Thread Fabiano Kureck
Sorry is not rdb$database but another system table. I can´t remember its name… De: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Em nome de Norman Dunbar Enviada em: quinta-feira, 23 de maio de 2013 06:35 Para: firebird-support@yahoogroups.com Assunto: Re: [firebird

Re: [firebird-support] RDB$PAGES

2013-05-23 Thread fabianoaspro
Take a look at the rdb$database table. It contains the total ammount pages of the entire database. Em 23/05/2013 06:34, "Norman Dunbar" escreveu: > ** > > > Morning Tomas, > > On 23/05/13 09:31, tomkrej wrote: > > Hi, I'd like to get the count of all types of db pages. > > > > If I run the query

Re: [firebird-support] RDB$PAGES

2013-05-23 Thread Norman Dunbar
Morning Tomas, On 23/05/13 09:31, tomkrej wrote: > Hi, I'd like to get the count of all types of db pages. > > If I run the query > select count(*), rdb$page_type from rdb$pages group by rdb$page_type > > I got only about 2200 pages, but there are about 320 000 pages in DB. > > And the result of

[firebird-support] RDB$PAGES

2013-05-23 Thread tomkrej
Hi, I'd like to get the count of all types of db pages. If I run the query select count(*), rdb$page_type from rdb$pages group by rdb$page_type I got only about 2200 pages, but there are about 320 000 pages in DB. And the result of query contains only - 3, 4, 6 and 9 type of page. How can I get

Re: [firebird-support] Backup Firebird Error

2013-05-23 Thread Mark Rotteveel
On Wed, 22 May 2013 17:30:31 -0500, Marco Sucuzhañay wrote: > Thanks for the reply, the problem appears to me to create a backup of the > database, which has 650 Gigas hot, I can do it in COLD backup? What do you mean with cold backup? Mark

Re: [firebird-support] Where to start ?

2013-05-23 Thread Norman Dunbar
Morning Berrie, On 22/05/13 13:41, berrie_at_m wrote: > I am on a LAN with approx. 150 users. I want to enable every user to enter 6 > fields of data (date, time, name, what, where, follow-up), without the > ability to see what other users have entered, or the ability to go back later > and m

Re: [firebird-support] Backup Database

2013-05-23 Thread Norman Dunbar
On 22/05/13 21:13, Marco Sucuzhañay wrote: > Dear, > How to generate a cold backup of the database, thanks You can download a PDF manual for the gbak application at http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/Firebird-gbak.pdf Before backing up: http://www.fireb