RE: [firebird-support] Help required

2012-08-01 Thread Mahesh Pratihari
Thanks From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Thomas Steinmaurer Sent: Wednesday, August 01, 2012 12:15 PM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] Help required Mahesh, Could you please let me know

[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

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, whereas

[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

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

[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 might have

[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 dimitr@... 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.

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_ENGVARCHAR(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 it from

[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