[firebird-support] Re: What to install for Firebird client on Ubuntu

2011-09-08 Thread grip_2ls
Hi Mark Coming from a Windows background what you are suggesting sounds counter intuitive but it does seem like the simplest approach. Thanks Neil --- In firebird-support@yahoogroups.com, "markopetejan" wrote: > > > Yes, manually. It's much harder and you en up saving nothing. On the > co

[firebird-support] Re: little help to build a query in Firebird

2011-09-08 Thread Ronan Keating
--- In firebird-support@yahoogroups.com, Svein Erling Tysvær wrote: > > new_tbl2 is simply a second CTE table. There's nothing wrong in having > several CTE tables after each other, you can even use WITH RECURSIVE and have > some non-recursive CTEs amongst them. > > Why do you use gen_id(g

Re: [firebird-support] What to install for Firebird client on Ubuntu

2011-09-08 Thread Helen Borrie
At 01:41 AM 8/09/2011, grip_2ls wrote: >Hi > >I want to use isql from the command line to access remote Firebird database on >an Ubuntu server. > >Is it possible to install just the client libraries rather than the whole >Firebird server? If so how? First, say whether the remote client is to be

[firebird-support] Re: What to install for Firebird client on Ubuntu

2011-09-08 Thread grip_2ls
Hi Helen The client is to go on Linux and the server could be either Linux or Windows. Thanks Neil --- In firebird-support@yahoogroups.com, Helen Borrie wrote: > > At 01:41 AM 8/09/2011, grip_2ls wrote: > >Hi > > > >I want to use isql from the command line to access remote Firebird database >

Re: [firebird-support] Re: What to install for Firebird client on Ubuntu

2011-09-08 Thread Fulvio Senore
My copy of Ubuntu (10.04) has a client only firebird package. I think that it should install what you need. Fulvio Senore Il 08/09/2011 11.36, grip_2ls ha scritto: > Hi Helen > > The client is to go on Linux and the server could be either Linux or Windows. > > Thanks > > Neil > > --- In firebird

Re: [firebird-support] Re: What to install for Firebird client on Ubuntu

2011-09-08 Thread Philippe Makowski
2011/9/8 Fulvio Senore > My copy of Ubuntu (10.04) has a client only firebird package. > I think that it should install what you need. hum under Debian and Ubuntu I guess that you are talking about this package : libfbclient2 it is only the lib, it will not install isql Under Debian and Ubuntu I

Re: [firebird-support] Re: What to install for Firebird client on Ubuntu

2011-09-08 Thread Helen Borrie
At 09:36 PM 8/09/2011, you wrote: >Hi Helen > >The client is to go on Linux and the server could be either Linux or Windows. Download the bz2 superserver kit and untar it in your home directory. In /opt, create a firebird directory and beneath it, firebird/bin and firebird/intl. Copy firebird.msg

Re: [firebird-support] Re: Problem with compound index

2011-09-08 Thread Ismael L. Donis Garcia
You could not substitute the consultation for: select * from fond where typ=:typ and tridnaz like :text || '%' order by tridnaz; Best Regards = || ISMAEL || = - Original Message - From: ma_golyo To: firebird-support@yahoogroups.com Sent: Thursday, September 08

[firebird-support] Firebird 1.5.4 (Win): Where to download

2011-09-08 Thread Nikolaus Kern
Hello all, in order to test a parallel installation of Firebird 1.5.4 and FB 2.5 I am looking for a download location for 1.5.4. On the firebirdsql webpage and also in sourcefourge.net I could only fine 1.5.6 Any ideas where I can get this version? Thanks Niko -

Re: [firebird-support] Re: little help to build a query in Firebird

2011-09-08 Thread Ann Harrison
2011/9/8 Svein Erling Tysvær > > ... resetting a generator leaves > > no traces and can be done as often as you wish. > > The implementation of generators (aka sequences) is very simple, There's a table, RDB$GENERATORS that holds the generator name and it's ID. The id is an index into the array

[firebird-support] Firebird Project Tracker and Wiki web sites planned outage this Sunday, Sept 11 from 13:00 to 17:00 (GMT)

2011-09-08 Thread Leyne, Sean
All, We will be making changes to our network infrastructure, which will affect network connectivity. So, these resources will be unavailable during this time. Sean [Non-text portions of this message have been removed]

[firebird-support] Shutdown engine with an exception inside a udf dll

2011-09-08 Thread Jesus Garcia
Hello, is normal to crash the engine whe an exception is raised inside a udf dll or must be catch by the engine? I had a udf with the function power. If i call power with a negative valué in the base parameter an exception is raised and the engine is stopped. Why not catch the exception To prev

Re: [firebird-support] Shutdown engine with an exception inside a udf dll

2011-09-08 Thread Dmitry Kuzmenko
Hello, Jesus! Thursday, September 8, 2011, 9:42:38 PM, you wrote: JG> Hello, is normal to crash the engine whe an exception is JG> raised inside a udf dll or must be catch by the engine? JG> I had a udf with the function power. If i call power with a JG> negative value in the base parameter an e

[firebird-support] Re: Shutdown engine with an exception inside a udf dll

2011-09-08 Thread hvlad
--- In firebird-support@yahoogroups.com, Jesus Garcia wrote: > > Hello, is normal to crash the engine whe an exception is raised inside a udf > dll or must be catch by the engine? Any kind of exception *must* be handled inside UDF. > I had a udf with the function power. If i call power with

[firebird-support] Re: Problem with compound index

2011-09-08 Thread tomkrej
Thank You Attila, for information about this issue. I will add my vote to this issue as soon as will JIRA works again. I will ask my coleague how he repairs our JIRA software - we had the same errors after the last update like on firebirdsql. To Ismael : I know how to fix this problem in my DB

RE: [firebird-support] Re: Problem with compound index - Email found in subject

2011-09-08 Thread Leyne, Sean
> Thank You Attila, for information about this issue. I will add my vote to this > issue as soon as will JIRA works again. Please try again, the tracker is back in operation. Sean

[firebird-support] How to rename a column?

2011-09-08 Thread firebirdsql
How do I rename a column?

Re: [firebird-support] How to rename a column?

2011-09-08 Thread Helen Borrie
At 11:07 AM 9/09/2011, you wrote: >How do I rename a column? alter table alter [column] old_column_name to new_column_name ./hb

[firebird-support] How to swap row values and enforce business rule using trigger

2011-09-08 Thread firebirdsql
CREATE TABLE table1 ( object VARCHAR(25), type VARCHAR(25) ) I have a before update trigger that verifies that at least one object is of 'Type 1'. If a 'Type 1' row is updated so that no 'Type 1' row exist, it will prevent the update. Therefore, 'Type 1' row must exist in the table at all t