Re: [firebird-support] Isql copy command - anyone know how it works?

2013-01-18 Thread Norman Dunbar
On 17/01/13 08:59, Norman Dunbar wrote: I'm doing some more documentation work on the isql manual. The current version mentions a copy command in isql which copies a table structure to another table, or database. Answering self! After a brief look at the isql source code. Given my limited

Re: [firebird-support] Interbase/Firebird interaction?

2013-01-18 Thread Elmar Haneke
1) Are there any adverse conflicts between IB6.5 and Firebird in a situation like this ... i.e., would running AT against an IB6.5 engine ultimately damage the data? As long as the data file is created and accessed by the IB6.5 server only no damage should occurr. The Firebird client lib

[firebird-support] Weird query results - bug?

2013-01-18 Thread Kjell Rilbe
Hi, This SQL returns 2533 records, none of which contain B.Kod starting with 1711 or 2111 (checked thoroughly): select B.* from Branschkod B inner join Branschkod B2 on B2.Namn = B.Namn where B.ECO_ID B2.ECO_ID Now, I add a line to the WHERE: select B.* from Branschkod B inner join Branschkod

Re: [firebird-support] Weird query results - bug?

2013-01-18 Thread Kjell Rilbe
Den 2013-01-18 12:56 skrev Kjell Rilbe såhär: Hi, This SQL returns 2533 records, none of which contain B.Kod starting with 1711 or 2111 (checked thoroughly): select B.* from Branschkod B inner join Branschkod B2 on B2.Namn = B.Namn where B.ECO_ID B2.ECO_ID Now, I add a line to the

Re: [firebird-support] Weird query results - bug?

2013-01-18 Thread Gary Benade
On 1/18/2013 2:02 PM, Kjell Rilbe wrote: Den 2013-01-18 12:56 skrev Kjell Rilbe såhär: Hi, This SQL returns 2533 records, none of which contain B.Kod starting with 1711 or 2111 (checked thoroughly): select B.* from Branschkod B inner join Branschkod B2 on B2.Namn = B.Namn where B.ECO_ID

RE: [firebird-support] Weird query results - bug?

2013-01-18 Thread Svein Erling Tysvær
Hi, This SQL returns 2533 records, none of which contain B.Kod starting with 1711 or 2111 (checked thoroughly): select B.* from Branschkod B inner join Branschkod B2 on B2.Namn = B.Namn where B.ECO_ID B2.ECO_ID Now, I add a line to the WHERE: select B.* from Branschkod B inner join

Re: [firebird-support] Weird query results - bug?

2013-01-18 Thread Kjell Rilbe
Den 2013-01-18 13:30 skrev Gary Benade såhär: On 1/18/2013 2:02 PM, Kjell Rilbe wrote: Den 2013-01-18 12:56 skrev Kjell Rilbe såhär: Hi, This SQL returns 2533 records, none of which contain B.Kod starting with 1711 or 2111 (checked thoroughly): select B.* from Branschkod B inner join

Re: [firebird-support] Weird query results - bug?

2013-01-18 Thread Kjell Rilbe
Den 2013-01-18 13:31 skrev Svein Erling Tysvær såhär: Hi, This SQL returns 2533 records, none of which contain B.Kod starting with 1711 or 2111 (checked thoroughly): select B.* from Branschkod B inner join Branschkod B2 on B2.Namn = B.Namn where B.ECO_ID B2.ECO_ID Now, I add

[firebird-support] ISC ERROR MESSAGE: connection rejected by remote Interface

2013-01-18 Thread Carsten John
Hello everybody, I get the following error on the client side: ISC ERROR MESSAGE: connection rejected by remote Interface the server log shows: INET/inet_error: read errno = 131 the server runs on solaris (x86), firebird 2.04. The whole thing ran flawlessly for some time, but since

[firebird-support] Execute block: Execute seems to be case sensitive !

2013-01-18 Thread laurentricci
Hi, I have faced a weird behaviour in Firebird 2.5.0. When executing the following (execute is in lowercase) , the block is returning the expected 3 rows: [1,2,3] execute block returns(val INTEGER) as begin val=1;SUSPEND; val=2;SUSPEND; val=3;SUSPEND; end When executing the following

Re: [firebird-support] Execute block: Execute seems to be case sensitive !

2013-01-18 Thread Thomas Steinmaurer
I have faced a weird behaviour in Firebird 2.5.0. When executing the following (execute is in lowercase) , the block is returning the expected 3 rows: [1,2,3] execute block returns(val INTEGER) as begin val=1;SUSPEND; val=2;SUSPEND; val=3;SUSPEND; end When executing the

[firebird-support] Re: Interbase/Firebird

2013-01-18 Thread lcampbell
j.ko...@apatykaservis.cz wrote: I had some significant issues if I used FB to access an IB database file. It was imperative to backup the IB database and restore it as FB database. This might or might not be an issue for you if you distribute a prepared database file (with all tables, procedures,

[firebird-support] Is this good advice?

2013-01-18 Thread lcampbell
We received a tip on using a minimal installation that referenced the following web page, last updated in 2009. http://www.destructor.de/firebird/minimumclient.htm Is this still current info? Is it good advice? Any thoughts or comments Thanks, Lane Campbell NW Software

Re: [firebird-support] Re: Interbase/Firebird

2013-01-18 Thread Thomas Steinmaurer
I had some significant issues if I used FB to access an IB database file. It was imperative to backup the IB database and restore it as FB database. This might or might not be an issue for you if you distribute a prepared database file (with all tables, procedures, triggers etc. created); if

Re: [firebird-support] Is this good advice?

2013-01-18 Thread Helen Borrie
At 08:10 a.m. 19/01/2013, lcampbell wrote: We received a tip on using a minimal installation that referenced the following web page, last updated in 2009. http://www.destructor.de/firebird/minimumclient.htm Is this still current info? Is it good advice? Any thoughts or comments Yes, it is good

Re: [firebird-support] Re: Isql copy command - anyone know how it works?

2013-01-18 Thread Ann Harrison
On Thu, Jan 17, 2013 at 8:05 AM, mariuz mar...@mariuz.android-dev.rowrote: A proposal on Firebird-devel has been made i think is time some of our tools change it's names and enter the fb-* prefix namespace fb-sql, fb-dump, fb-security, fb-fixup, fb-stat, fb-backup, fb-qli, fb-preprocess,

[firebird-support] Password management

2013-01-18 Thread Rick Debay
We are currently running Firebird 1.5 on a physical server running Linux. Automated server processes have the database password hardcoded. We are migrating to FB 2.5 on Linux VMs. Since FB only integrates with Windows Active Directory authentication, does anyone have suggestions on how to manage

[firebird-support] RE: Password management

2013-01-18 Thread Leyne, Sean
Rick, We are currently running Firebird 1.5 on a physical server running Linux. Automated server processes have the database password hardcoded. We are migrating to FB 2.5 on Linux VMs. Since FB only integrates with Windows Active Directory authentication, does anyone have suggestions on

Re: [firebird-support] Weird query results - bug?

2013-01-18 Thread Gary Benade
On 1/18/2013 2:48 PM, Kjell Rilbe wrote: Den 2013-01-18 13:30 skrev Gary Benade såhär: On 1/18/2013 2:02 PM, Kjell Rilbe wrote: Den 2013-01-18 12:56 skrev Kjell Rilbe såhär: Hi, This SQL returns 2533 records, none of which contain B.Kod starting with 1711 or 2111 (checked thoroughly):