[firebird-support] Re: Possible interaction between Firebird and Skype?

2012-08-01 Thread cgr_firebird
Svein and Reinier, Thanks for replying to my query and for your suggestions. Sorry for not being quick to reply to you both - I'm travelling at the moment, with intermittent access to broadband. The first thing to say is that the problem hasn't recurred. I have also borrowed a netbook, and set

Re: [firebird-support] Help required

2012-08-01 Thread Paul Vinkenoog
Hi, > > Could you please let me know what is the equivalent of varbinary( max) > > of SQL datatype in Firebird. > > In general, BLOB with an appropriate sub-type. I'd rather say varchar(max) character set octets, unless max is between 32K and 64K. In that case you need a BLOB in Firebird, whe

[firebird-support] Re: FB Silent install Exe

2012-08-01 Thread Allan Fernandes
I am extremely sorry. Today the command  Firebird-2.0.3.12981-1-Win32.exe /SILENT ... is working as it is supposed to. I have no idea what went wrong yesterday. Again sorry for wasting your time. [Non-text portions of this message have been removed]

[firebird-support] matrix report

2012-08-01 Thread mahdoom_a
Dear all, I need your help to create this report AQNOJan Feb Mar Apr May Jun Jul..Dec. Total_paid --- --- --- --- --- --- --- ----- 10012000 2000 2000 2000 8000 CHQNO 214 215216 217

RES: [firebird-support] Re: How to list the tables and field wich use the primary key from one table as FK

2012-08-01 Thread harveypekkar
Thank you , I will also try to verify memory ( I know memtest , it's efficient the difficulty is that I am not behind the server but distant and it eed also to be run before Windows , not easy for my client ) . But I think memory is not the problem for all , and after a repair the base usually w

Re: [firebird-support] matrix report

2012-08-01 Thread Alexandre Benson Smith
Em 1/8/2012 08:23, mahdoom_a escreveu: > Dear all, > > I need your help to create this report > > AQNOJan Feb Mar Apr May Jun Jul..Dec. Total_paid > --- --- --- --- --- --- --- ----- > 10012000 2000 2000 2000

[firebird-support] Firebird 2.5 performance slower then 2.1 especially SuperClassic...

2012-08-01 Thread randallsell
Hello all, I recently upgraded FB from 2.1.5 to 2.5.1. In order to port data we essentially write the contents of the database to a file, then read it back in again. In short, this amounts to many thousands of INSERT statements. (Yes I know how to use GBak, this process was designed to make met

[firebird-support] Re: Firebird 2.5 performance slower then 2.1 especially SuperClassic...

2012-08-01 Thread Dmitry Yemanov
01.08.2012 19:40, randallsell wrote: > > Has anyone else experienced performance degredation with FB 2.5? This may explain your experience: http://tracker.firebirdsql.org/browse/CORE-3792 Dmitry

Re: [firebird-support] Recursive query (get all employees under master department)

2012-08-01 Thread Newbie
this is exactly what I needed. Thank you :) > > If what you're asking is what I think, then the answer is very simple: > > (same CTE as you already have) > > SELECT * FROM fs_tree fs > JOIN employee e on fs.dept_id = e.dept_id > > Of course, you could also put this in the CTE itself (then you migh

[firebird-support] Re: Firebird 2.5 performance slower then 2.1 especially SuperClassic...

2012-08-01 Thread randallsell
--- In firebird-support@yahoogroups.com, Dmitry Yemanov wrote: > > 01.08.2012 19:40, randallsell wrote: > > > > Has anyone else experienced performance degredation with FB 2.5? > > This may explain your experience: > http://tracker.firebirdsql.org/browse/CORE-3792 > > > Dmitry > Possibly. Al

Re: [firebird-support] Saving / Retreving Chinese chrs from database

2012-08-01 Thread Michael Ludwig
Andy Gable schrieb am 26.07.2012 um 03:21 (+0100): > "KITCHENDESCRIPTION_ENG"VARCHAR(40), > > "KITCHENDESCRIPTION_OTHER" VARCHAR(100) CHARACTER SET UTF8, > (programming language VB6 and interface is ODBC) > I can display when adding a new product the Chinese chars but when I > recall i

[firebird-support] Re: Firebird 2.5 performance slower then 2.1 especially SuperClassic...

2012-08-01 Thread Dmitry Yemanov
02.08.2012 3:14, randallsell wrote: > > Possibly. Although I am noticing far worse then a 50% loss. But shall > retest when 2.5.2 is publicly available. Got a rough idea when that > might be? In a couple of weeks. But you may use a snapshot build for testing. Dmitry

[firebird-support] Re: Firebird 2.5 performance slower then 2.1 especially SuperClassic...

2012-08-01 Thread hvlad
--- In firebird-support@yahoogroups.com, "randallsell" wrote: > > Hello all, > > I recently upgraded FB from 2.1.5 to 2.5.1. In order to port data we > essentially write the contents of the database to a file, then read it back > in again. In short, this amounts to many thousands of INSERT sta