Re: [firebird-support] "Over the wire" Connection Encryption: AES

On 26-1-2018 15:16, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 26.01.2018 13:37, daniel.acherm...@logismos.com [firebird-support] wrote: >> One of our customer is interested in the Firebird 3 feature of a "over the >> wire" >> connection encryption. This customer however

Re: [firebird-support] Miscalculation of floating points in Firebird

On 2018-01-26 19:51, Helen Borrie hele...@iinet.net.au [firebird-support] wrote: >> I am not familiar with the details of the SQL standard, is this the >> proper was to round and calculate numeric values in SQL?  > > You really do need to familiarise yourself with the way SQL handles > numbers,

Re: [firebird-support] Miscalculation of floating points in Firebird

On 2018-01-26 16:17, Salim Naufal s.nau...@softnet.me [firebird-support] wrote: > I have noticed the following inconsistencies in Firebird 3.02: > > Try performing the following calculations: > > SELECT (1 - (1/1.11)) FROM RDB$DATABASEresult is rounded and > yields 0.10 (rounded result)

Re: [firebird-support] ASCII_CHAR(9)

On 2018-01-18 19:25, tiberiu_horv...@yahoo.com [firebird-support] wrote: > Firebird 3, Delphi IBX. > > Somehow one of my customers inserted a product code so that at the end > of the string he added chr(9) and stored this string in the database. A ASCII_CHAR(9) is a perfectly valid character

Re: [firebird-support] convert a string to a number in a where clause - without errors

On 2018-01-16 09:52, Rustam rusta...@ukr.net [firebird-support] wrote: > I think better way is to control input on client. > If this is impossible you can try "spike": write selectable stored > procedure with exception handler "when any do ..." Or use a Firebird 3 Function. Mark

Re: [firebird-support] Which Firebird ADO.Net client is compatible with Firebird server v2.0.x?

On 12-1-2018 15:11, B?lint Nagy bali...@hotmail.com [firebird-support] wrote: > I need to connect to a Firebird v2.0.3 database from .Net. > > I downloaded  the current Firebird ADO.Net provider about two months > ago, then the current one (5.12.1.0), and implemented all the necessary >

Re: [firebird-support] Firebird 1.5 on Windows 10 32

On 12-1-2018 19:10, fo...@darsys.com.ar [firebird-support] wrote: > I can't install FB 1.5 on my Windows 10 32b > > I get "this app can't run on this PC" > > In "more information" opens MS page that says "your app does not work on > your PC. > > In adition, I had it installed it. I think it

Re: [firebird-support] Firebird 3.0.1 freezes on one table for some 10-20 minutes during backup after gfix/mend

On 11-1-2018 14:24, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > On 11-1-2018 13:21, jonatan.laurit...@yahoo.dk [firebird-support] wrote: >> I checked the system again - we use 3.0.2 indeed. >> >> There is no particular reason why we use -mend. We use it

Re: [firebird-support] Firebird 3.0.1 freezes on one table for some 10-20 minutes during backup after gfix/mend

On 11-1-2018 13:21, jonatan.laurit...@yahoo.dk [firebird-support] wrote: > I checked the system again - we use 3.0.2 indeed. > > There is no particular reason why we use -mend. We use it routinely > between backup/restore operations to prevent the situation that any > corruption errors my

Re: [firebird-support] Firebird 3.0.1 freezes on one table for some 10-20 minutes during backup after gfix/mend

On 11-1-2018 09:14, jonatan.laurit...@yahoo.dk [firebird-support] wrote: > We have observed, that Firebird 3.0.1 freezes on one specific table for > some 10-20 minutes during backup. This freezing happens only in the case > when gfix/mend had been performed before backup. Backup runs smoothly >

Re: [firebird-support] Re: Firebird role.

On 10-1-2018 22:21, Alexandre Vinhaes - Tecnico - Tecnologia alexandre.vinh...@cipa.com.br [firebird-support] wrote: > I have created a role and granted it to an user. For my surprise, > related user doesnt have privileges from that role. I dont want to set > the role previously. What should I

Re: [firebird-support] Using a selectable stored procedure

On 6-1-2018 15:19, m_brahi...@yahoo.fr [firebird-support] wrote: > > > Heres is a sample code of the SP > > BEGIN > FOR SELECT O.ORDRE_ID, O.UNITE_ID, O.NUM_ORDRE, O.PREFIXE, O.DATE_ORDRE, > O.MOTIF_ORDRE, O.STRUCTURE_ID, O.PROJET_ID, O.BESOIN_NECESSAIRE, > O.COMMANDE_TRANSMISE, O.UTILISATEUR,

Re: [firebird-support] Using a selectable stored procedure

On 6-1-2018 14:30, m_brahi...@yahoo.fr [firebird-support] wrote: > Selecting fields of stored procedure build with FOR SELECT  from a > delphi app with where clause is not bad a a method ?  Thanks I think you need to illustrate this with a small example. Mark -- Mark Rotteveel

Re: [firebird-support] Problem with where clause

On 5-1-2018 14:35, m_brahi...@yahoo.fr [firebird-support] wrote: > > > Now with > > V1=:V1 || ' WHERE CF.DATE_COMMANDE'||' BETWEEN '''||:FROM_DATE||''' AND > '''||:TO_DATE||; > > It works for me  and I tried with > > V1=:V1 || ' WHERE CF.DATE_COMMANDE>='''||:FROM_DATE||''' AND >

Re: [firebird-support] Problem with where clause

On 5-1-2018 13:23, m_brahi...@yahoo.fr [firebird-support] wrote: > Thanks but adding a quote at the end doesn't work. In fact adding double > quote because with one the SP will not be compiled That is because || '; would open a string but not end it, then ||''; doesn't work, because that is

Re: [firebird-support] Problem with where clause

On 5-1-2018 13:37, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > Your immediate problems is caused by missing quotes around the date > values though. Specifically, it would need to be: V1=:V1 || ' WHERE CF.DATE_COMMANDE'||' BETWEEN '''||:FROM_DATE||''' AND '''||:T

Re: [firebird-support] Problem with where clause

On 5-1-2018 12:52, m_brahi...@yahoo.fr [firebird-support] wrote: > I am using FB 3 and IBExpert and with the DDL below I get message > command> and it works when I remove the where clause. I think the > problem is with the between command. Can you please help me ? Why are you using `execute

Re: [firebird-support] Query and problem with nulls

Without relevant DDL and sample data we can't really help you. Mark On 4-1-2018 12:36, Luigi Siciliano luigi...@tiscalinet.it [firebird-support] wrote: > Hallo, > >   The following query works fine but returns *all nulls* if no rows > between :DaData and :AData > > SELECT > >  

Re: [firebird-support] Firebird 3 client API to connect FB 2.5 database server

On 3-1-2018 20:24, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 03.01.2018 11:51, Mauricio Junqueira mau...@gmail.com [firebird-support] > wrote: >> Is there a way to change WireCrypt and AuthServer in the Database Params >> Buffer? > > Use isc_dpb_config hack. Which

Re: [firebird-support] Select freezes

On 30-12-2017 12:41, elifla...@gmail.com [firebird-support] wrote: > My software is running on a client and sometimes something happens and a > SELECT command in a table (only in this table) freezes. Then I just do a > backup (only a backup, without restore) and the command runs correct again. >

Re: [firebird-support] Engine Error - Partner Index

On 22-12-2017 13:27, Nico Speleers nico.spele...@carfac.com [firebird-support] wrote: > I only see version 3.0.1. How can I see the digits after comma ? There is no comma in the version number, but if you mean after the third dot, there are several ways: - Flamerobin: right click on server,

Re: [firebird-support] Engine Error - Partner Index

On 22-12-2017 13:10, Nico Speleers nico.spele...@carfac.com [firebird-support] wrote: > We are using Firebird 3.0. What is the full version (eg 3.0.2.32703)? -- Mark Rotteveel

Re: [firebird-support] info

On 22-12-2017 10:29, Nico Speleers nico.spele...@carfac.com [firebird-support] wrote: This is the third topic you started with the non-descriptive subject "info". In the future, could you please come up with a succinct but informative subject when posting? Subjects should summarize your

Re: [firebird-support] info

On 22-12-2017 10:29, Nico Speleers nico.spele...@carfac.com [firebird-support] wrote: > Problem > Engine Error (code = 335544333): internal Firebird consistency check (partner > index description not found (175), file: idx.cpp line: 1271). > SQL error (code = -902): Unsuccessful execution

Re: [firebird-support] Install Firebird on windows server 2012

On 21-12-2017 15:26, Ryan Farmer farme...@icloud.com [firebird-support] wrote: > Firebird 2.5.2.26539. The error message is “Firebird 2.5 Installer (2.1) > is not allowed to run on Win2012R2.64(6.3) Setup Aborted!” Why are you even trying to install version 2.5.2? It is not the latest 2.5.x

Re: [firebird-support] Firebird 3.0.3 no longer compatible with InterBase 7.5.1 clients

On 21-12-2017 08:49, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > On 21-12-2017 03:06, FSPAPA INCA Team i...@foodstuffs-si.co.nz > [firebird-support] wrote: >> I reckon this change to src/remote/server/server.cpp in commit >> 2fdb281759299f24d47349246f3c800ec

Re: [firebird-support] Install Firebird on windows server 2012

On 21-12-2017 05:01, Ryan Farmer farme...@icloud.com [firebird-support] wrote: > I am trying to install Firebird 2.5 onto a virtual machine. The machine is > run by amazon web services with windows server 2012. I simply get an error > stating firebird doesn’t work with windows server 2012. Is

Re: [firebird-support] Firebird 3.0.3 no longer compatible with InterBase 7.5.1 clients

On 21-12-2017 03:06, FSPAPA INCA Team i...@foodstuffs-si.co.nz [firebird-support] wrote: > I reckon this change to src/remote/server/server.cpp in commit > 2fdb281759299f24d47349246f3c800ec78971cc introduced an unintended effect: I think you're right. I'll create a ticket in the tracker for

Re: [firebird-support] Firebird 3.0.3 no longer compatible with InterBase 7.5.1 clients

On 19-12-2017 04:32, FSPAPA INCA Team i...@foodstuffs-si.co.nz [firebird-support] wrote: > I’ve been testing a set of apps that use the InterBase 7.5.1 client > library against Firebird 3.0.2 and have found them to be sufficiently > compatible (with minimal changes).  However after updating a

Re: [firebird-support] getting generated if before insert (was: Info)

On 2017-12-19 16:34, Nico Speleers nico.spele...@carfac.com [firebird-support] wrote: > Hi, > > Ex. > CREATE TABLE ADDRESSES ( > IDINTEGER GENERATED BY DEFAULT AS IDENTITY > NOT NULL, [..] > /* Keys */ > CONSTRAINT PK_ADDRESSES > PRIMARY KEY (ID), > /*

Re: [firebird-support] Problem with CONTAINING and COLLATE

On 2017-12-08 12:01, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 08.12.2017 11:56, Mark Rotteveel m...@lawinegevaar.nl > [firebird-support] wrote: >> I don't agree with this. The string literal is in the connection >> character set, but the value s

Re: [firebird-support] Problem with CONTAINING and COLLATE

On 2017-12-07 19:06, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 07.12.2017 18:46, Gabor Boros mlngl...@bgss.hu [firebird-support] > wrote: >> Why does the connection charset count? > >Because you are sending queries in connection charset. And string > literals in them

Re: [firebird-support] Using Firebird v3.0.2 fbclient.dll to access previous versions, specifically 1,56

On 2017-12-06 13:14, OB1 oldbasf...@googlemail.com [firebird-support] wrote: > We're making the jump from v1.56 to v3.0.2 (gulp!) and to make the > transition easier for our clients we wondered if v3 client libs > (fbclient.dll) can access 1.56 servers. We've tested this and it > appears to

Re: [firebird-support] Trouble establishing a connection to Firebird database files.

On 2017-11-28 00:06, Justis Root justis.r...@gmail.com [firebird-support] wrote: > Thank you for your responses, > > I’m running firebird 3.0; I’m not sure what version of firebird > the database files were generated with. > I’m using the JDBC driver to connect from InfoCaptor. > > When using

Re: [firebird-support] gbak open source ?

On 18-11-2017 11:12, 'Raether, Olaf' olaf.raet...@wink.de [firebird-support] wrote: > firebird itself is open source – Are the tools e.g. gBak open source as > well ? > > And if yes – where can I find it. It is part of the Firebird sources, which you can find on

Re: [firebird-support] Re: Rename a foreign key

On 2017-11-16 12:01, antoedinchar...@gmail.com [firebird-support] wrote: > have you tried altering rdb$indices ? That is something that will no longer work with Firebird 3. Mark

Re: [firebird-support] Firebird 3.0 create database syntax

On 14-11-2017 10:31, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > On 14-11-2017 00:00, palevi pablo.l...@horus.es [firebird-support] wrote: >> In firebird 2.x you can specify some parameters when creating a >> database, i.e.: >> >>    create

Re: [firebird-support] Firebird 3.0 create database syntax

On 14-11-2017 00:00, palevi pablo.l...@horus.es [firebird-support] wrote: > In firebird 2.x you can specify some parameters when creating a > database, i.e.: > >     create database "localhost:milenio-central.fdb" user "milenio" > password "secreto" page_size 16384 default character set utf8

Re: [firebird-support] Unexpected privileges on a table via a view

On 12-11-2017 10:17, Brian Dunstan br...@dunstan.biz [firebird-support] wrote: > > > Hi, > > I’m running Firebird 3.0, dialect 3. > > As SYSDBA I’ve created a table and a view, thus: > > *create table tab_a (x integer, y integer, z integer);* > > ** > > *create or alter  view test_view (x,

Re: [firebird-support] Primary key composed by multiple integer fields

On 11-11-2017 13:15, m_brahi...@yahoo.fr [firebird-support] wrote: > > > Thanks for the answers > > >  All fields contained in the PK are updated is that mean by operations > affected ? > > decrease in > performance is acceptable or not is up to you.> > Thanks for explanation but if case

Re: [firebird-support] Primary key composed by multiple integer fields

On 11-11-2017 11:13, m_brahi...@yahoo.fr [firebird-support] wrote: > I need to know please if it is allowed that a primary key has multiple > integer fields ? and only that. For example a PK that has seven integer > fields will it decrease the performance table ? I am using FB 3. Thanks Of

Re: [firebird-support] Firebird stopped after 190 connections

On 7-11-2017 22:53, Hamish Moffatt ham...@risingsoftware.com [firebird-support] wrote: > Did it actually refuse new connections, or did new connections attempts > just hang indefinitely? > > I have problems with new connections to Firebird just hanging. If you > have a connection then you can

Re: [firebird-support] firebird 2.5.2

On 8-11-2017 11:52, Ahmad Alammar / vamos Eltern-Kind-Reisen GmbH alam...@vamos-reisen.de [firebird-support] wrote: > I have firebird 2.5.2 installed on windows server 2008 R2 64, I want to > upgrade the windows Server to 2016, > > does firebird 2.5.2  work on windows server 2016?! > > if No,

Re: [firebird-support] Index process in Firebird 2.1.4

On 20-10-2017 05:45, gn7s...@gmail.com [firebird-support] wrote: > I'm going to develop a commercial program with Firebird2.1, in Delphi7. > I want to know whether the following index is picked by the optimizer. You do realise that Firebird 2.1 is no longer supported and hasn't received updates

Re: [firebird-support] LIST gives inconsistent results

On 2017-09-28 16:40, 'Daniel Miller' dmil...@amfes.com [firebird-support] wrote: > But that doesn't make sense. Right from the docs you quoted - "If > ordering is important, It is no guarantee as documented: "The ordering of the list values is **undefined**—the order in which the strings are

Re: [firebird-support] LIST gives inconsistent results

On 2017-09-28 10:49, 'Daniel Miller' dmil...@amfes.com [firebird-support] wrote: > It's certainly possible my database is corrupted - I don't think it > is. But I'm willing to test if someone tells me how. However... > > At the moment, after several painful hours, I think I've determined > the

Re: [firebird-support] Cannot create sequence

On 23-9-2017 02:44, Jorge Andres Brugger jorge.brug...@gmail.com [firebird-support] wrote: > > > Hello all. > To use a replication solution (not longer maintaned) i need to create a > generator/sequence named "RDB$GEN_REPLICADOR" but when I try to do it i > get (using Flamerobin): > > Error:

Re: [firebird-support] FB 3.0 Replacing ICU libraries

On 2017-09-12 10:15, Magnus Johansson mag...@nimajo.se [firebird-support] wrote: > Hi All, > > Perhaps my previous post about collation problem was too long so that > nobody cared to read it through, so let me start with a simpler > question. > > I need unicode collation for Swedish and

Re: [firebird-support] Re: Firebird Alpha 4 Release Notes

On 10-9-2017 06:30, Dmitry Yemanov dim...@users.sourceforge.net [firebird-support] wrote: > 10.09.2017 02:13, Daniel Miller wrote: > >> The misunderstanding is probably mine - but I've never heard of 34-bit >> values/precision before. Is that a typo for either 32 or 64? Or "34" >> is correct?

Re: [firebird-support] Connect to FB database through VPN

On 1-9-2017 11:28, sntpywhl3bfbefeaicfmgdnmn3pewm6576tee...@yahoo.com [firebird-support] wrote: > I have FB3 database at a customer site and was able to log in remotely > because they had Port Forwarding set on their router for Port 3050 and I > used the connection string - IP Address:Database

Re: [firebird-support] Spaticomentadal extensions...

On 27-8-2017 02:08, oscar.l...@microsipmty.com [firebird-support] wrote: > César, > Checando sus facturas, veo que no le capturaron el tipo de cambio a > facturas de dólares del mes de julio, para mí procede devolución total > y refacturar al cliente, ya que ese dato va en el xml, lo raro es que >

Re: [firebird-support] Spatial extensions...

On 26-8-2017 18:01, prosse...@yahoo.com [firebird-support] wrote: > I'm bored and need a challenge... I'd really like to add spatial support > to firebird so how do I sign up?   I've been programming in C, C++ and > Delphi for 30 years and now I can write what I want to write! Welcome! The

Re: [firebird-support] Firebird 3 crashes ( terminated abnormally (4294967295) )

On 18-8-2017 14:59, Rudi Feijó rudi.fe...@multidadosti.com.br [firebird-support] wrote: >>Which version (exact buildnumber)? > > Mark, server version is WI-V6.3.2.32703 That is not actually a Firebird version number (it is a fake version reported in - IIRC - gds_32.dll to provide compatibility

Re: [firebird-support] Firebird 3 crashes ( terminated abnormally (4294967295) )

On 2017-08-17 22:29, Rudi Feijó rudi.fe...@multidadosti.com.br [firebird-support] wrote: > I’ve been having quite a few crashes on a new server with not much > databases > or requests. terminated abnormally (4294967295) > > It seems to be very random, there are not many different operations >

Re: [firebird-support] Re: Automatic Firing of Query.

On 2017-08-17 13:40, Svein Erling Tysvær setys...@gmail.com [firebird-support] wrote: > Since the query contains 'from RDB$RELATION_FIELDS R, RDB$FIELDS F > where ... R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME' (SQL-89 type of JOIN) > and not 'from RDB$RELATION_FIELDS R JOIN RDB$FIELDS F ON >

Re: [firebird-support] Evaluate "empty" string

On 16-8-2017 17:53, Jorge Andres Brugger jorge.brug...@gmail.com [firebird-support] wrote: > Hello all. > I need to evaluate if one SP varchar parameter is "not empty". I´m using: > if (((CHAR_LENGTH(trim(terminal))>0) or (terminal is not null)) then something>. > If I send '' (empty string) as

Re: [firebird-support] Automation tools?

On 15-8-2017 15:36, Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support] wrote: > We're in need of a tool where we can author sequences of SQL queries > against FB and non-DB commands like file operations etc. I'd like to > call them "batch runs" to perform recurring tasks. > >

Re: [firebird-support] FIRST 1 of each iItemID

On 12-8-2017 08:28, venussof...@gmail.com [firebird-support] wrote: > I have a view and the following query which returns multiple records > from the view (see below) for each iItemID > > > SELECT iItemID > , cID > , dDt > , bRate > FROM vwPriceListHistory >

Re: [firebird-support] Compatibility questions: Current release versus 1.5.3.4870

On 2017-07-27 00:58, 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] wrote: > My question (and I'm sorry if I'm asking this before doing any > research on my own) is simply, how compatible is the 2.5 version with > databases created with 1.5.3? Firebird 2.5 can read databases from

Re: [firebird-support] Compatibility questions: Current release versus 1.5.3.4870

On 2017-07-26 17:52, scott...@comcast.net [firebird-support] wrote: > Hello! > > I know it's been a while since I've posted on this Group, but current > circumstances have brought me back. > > Today, I discovered that Microsoft forcibly removed fbserver & fbguard > for version 1.5.3.4870. This

Re: [firebird-support] fbclient: What to do after "Error readin / writing data to/ from the connection"

On 25-7-2017 16:12, Marsupilami79 marsupilam...@gmx.de [firebird-support] wrote: > Hello, > > some of my client seemingly have a faulty network and get the following > errors ocassionally when running my program while it tries to execute a query: > > Error writing data to the connection. >

Re: [firebird-support] Simple post edited data to table raises exception after converting FB 2.1 to FB 3.0

On 2017-07-20 16:53, fredf...@hotmail.com [firebird-support] wrote: > I used Delphi's FireDAC components and FireDAC Monitor program which > tracing issues with Firebird. I posted extracted data from tracing > file after user hit save button to save changes in address1 line - > it's very simple

Re: [firebird-support] Simple post edited data to table raises exception after converting FB 2.1 to FB 3.0

On 2017-07-20 23:33, setysvar setys...@gmail.com [firebird-support] wrote: > Den 20.07.2017 16:53, skrev fredf...@hotmail.com [firebird-support]: > >> I used Delphi's FireDAC components and FireDAC Monitor program >> which tracing issues with Firebird. I posted extracted data from >> tracing

Re: [firebird-support] Simple post edited data to table raises exception after converting FB 2.1 to FB 3.0

On 2017-07-20 00:18, fredf...@hotmail.com [firebird-support] wrote: > The error states: Exception class EFDDBEngineException with message > [FireDAC][Phys][FB_30]-312 Exact update affected [0] rows, while [1] > was requested. > If I hit "Continue" button then another exception raises: > The error

Re: [firebird-support] Re: How to get different Maximum Data for every single date in the table?

On 17-7-2017 13:31, Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] wrote: > HI SET, > > Please help. I find it rather rude to expect (almost demand) someone to just help you, and to then ignore the fact that there are also other people here who would also might help you. Not to

Re: [firebird-support] Connection rejected by remote interface

On 17-7-2017 14:08, Aldo Caruso aldo.car...@argencasas.com [firebird-support] wrote: > I have the same problem running Firebird super server on Linux ( > Ubuntu 14.04 ). Sadly, the only solution I found was to restart Firebird > service. > > I wrote a bash script that attempts to

Re: [firebird-support] Does Firebird support geography and geometry?

On 16-7-2017 12:19, Andrea Raimondi andrea.raimo...@gmail.com [firebird-support] wrote: > Just wondering if Firebird supports either :) > > Anybody knows? No, Firebird does not have data-types or indexes for - I assume - GIS purposes. Mark -- Mark Rotteveel

Re: [firebird-support] Connection rejected by remote interface

On 14-7-2017 15:07, 'Dieter Blume' d...@blume-edv.de [firebird-support] wrote: > Dear Friends, > > i am a software-developer, using Delphi 2006 and Firebird 2.5. > > Yesterday, I tried to migrate from Firebird 2.5 to Firebird 3.0. > > Everything works fine, but only on my server. When I tried

Re: [firebird-support] Re: How can one rename a table in Firebird 3.0

On 13-7-2017 22:58, Michal Kurczabinski michk...@gmail.com [firebird-support] wrote: >> Creating of a view is an old method. Firebird 3 just prohibit hacks with >> direct changes >> of system tables. > > > ALTER TABLE table_name RENAME TO new_table_name > > is also old method without

Re: [firebird-support] Connection rejected by remote interface

On 23-6-2017 14:03, Aldo Caruso aldo.car...@argencasas.com [firebird-support] wrote: > Hi Mark, > > thanks for your answer. > > Nevertheless, I looked up for crashed server errors in > /var/log/syslog as well as in /var/log/firebird2.5.log and found none. > The server did not crash,

Re: [firebird-support] Connection rejected by remote interface

On 2017-06-23 01:52, Aldo Caruso aldo.car...@argencasas.com [firebird-support] wrote: > Hi, > > I have Firebird 2.5 running since many years under the following > environment > > OS: Ubuntu 14.04 Server > > Firebird Superserver 2.5.2.26540 > > Web server: apache2 2.4.7 > > Today

Re: [firebird-support] Need to backup/restore when updating from 2.5.3 to 2.5.7?

On 17-6-2017 10:39, Matthias Hanft m...@hanft.de [firebird-support] wrote: > my (Gentoo) Linux distribution wants me to update from Firebird > 2.5.3.26780.0-r3 to (at least) Firebird 2.5.7.27050.0. Can I just > compile the new version, start it, and all is fine; or do I have > to run the complete

Re: [firebird-support] INET/inet_error: read errno = 104

On 5-6-2017 15:51, Gugui gugui_sarubi_mac...@yahoo.com.br [firebird-support] wrote: > Hi, all > i notice once in a day this error in firebird.log > i just ping my server and it doesnt lost package > i dont know what happend... > thanks in advance Error 104 on *nix means socket reset by peer

[firebird-support] Detecting a parameter is DB_KEY

How can I find out if a parameter is a DB_KEY? When describing "select column1 from testrowid where rdb$db_key = ?", how can I derive from the parameter information that this is actually a db_key? For selected fields like in "select rdb$db_key, column1 from testrowid" it is easy: just check

Re: [firebird-support] FB persistent connections on php-fpm

On 2017-05-03 19:07, Rudi Feijó rudi.fe...@multidadosti.com.br [firebird-support] wrote: > As of late, we have been experiencing with persistent connections on > our > backend. This is justifiable, we have a very high number of connection > requests (lots of requests from lots of users). > > We

Re: [firebird-support] Performing bulk update taking time.

On 27-4-2017 09:03, 'Joje' j...@codework-solutions.com [firebird-support] wrote: > Is there anyway using which we could perform bulk update in firebird. > > I have two tables A & B. Both tables are referenced by a *varchar(100)* > *AR_ID* column. > > - Total number of rows in each table

Re: [firebird-support] Firebird 2.5 - Alter table - drop default - bug or feature

On 25-4-2017 18:21, Lester Caine les...@lsces.co.uk [firebird-support] wrote: > On 25/04/17 16:50, Mark Rotteveel m...@lawinegevaar.nl > [firebird-support] wrote: >> The SQL standard is quite clear at what needs to happen: adding a new >> column with a default should behave as

Re: [firebird-support] Firebird 2.5 - Alter table - drop default - bug or feature

On 25-4-2017 17:43, Lester Caine les...@lsces.co.uk [firebird-support] wrote: > On 25/04/17 12:51, Maxi maxiroba...@gmail.com [firebird-support] wrote: >> I expect the value assigned by DEFAULT when I add the new field is >> still there. > > There has been various discussions on this area ... >

Re: [firebird-support] Firebird 2.5 - Alter table - drop default - bug or feature

On 24-4-2017 20:50, Maxi maxiroba...@gmail.com [firebird-support] wrote: > > > Hi everyone, > > I encountered strange behavior droping a column definition with default > value. > > The environment is Ubuntu 16.04 LTS 64 bits, Firebird version > LI-V2.5.6.27020 (Firebird 2.5 SuperClassic) > > >

Re: [firebird-support] Basic Start

On 2017-03-14 18:32, Clyde Eisenbeis cte...@gmail.com [firebird-support] wrote: > I've recently written code using SQLite (C# .NET, using > System.Data.SQLite) ... decided to try Firebird. > > > To install Firebird: Visual Studio 2013 -> File -> New -> Project, > etc. -- then Tools ->

Re: [firebird-support] Re: FB 3 embedded on Windows 7 64 bit

On 2017-03-10 14:56, Martin Schreiber mse00...@gmail.com [firebird-support] wrote: > On 10.03.2017 15:35, hv...@users.sourceforge.net [firebird-support] > wrote: > > > > > > ---In firebird-support@yahoogroups.com, wrote : > > > > > >> Are ther other possibilities to set the

Re: [firebird-support] FIREBIRD WITH JHIPSTER

On 2017-03-09 05:28, kyilintu...@yahoo.com [firebird-support] wrote: > Can i connect Firebird with Jhipster > because jhipster didn't show i can use firebird db This question would be more on topic on the Firebird-java mailinglist. However,I would guess that you are better off asking this on a

Re: [firebird-support] Re: firebird 3.0 ten times slower than 2.5 ?

On 2017-03-08 11:30, Michal Kurczabinski michk...@gmail.com [firebird-support] wrote: > Thanks for your answer, > > perhaps problem is in jaybird-3.0.0-beta-3 used to connection to fb 3. > > My fb25 client is jaybird-2.2.12 and works fine. When comparing performance of two systems, it is

Re: [firebird-support] Re: How to check and (possibly) repair new authorization system on Firebird 3.0.1

On 2017-03-01 09:59, Dmitry Yemanov dim...@users.sourceforge.net [firebird-support] wrote: > 01.03.2017 11:58, jonatan.laurit...@yahoo.dk wrote: > >> OK, I have working Firebird 3.0.1 installation and I have copied >> security3.fdb from the broken Firebird installation and now I am also >>

Re: [firebird-support] Re: How to check and (possibly) repair new authorization system on Firebird 3.0.1

On 2017-03-01 11:41, jonatan.laurit...@yahoo.dk [firebird-support] wrote: > Solution found - I had to use the "create user" command with the > "using" clause: > SQL> create user SYSDBA password 'masterkey' using plugin Srp; > > My firebird.cong indicated that Legacy_Auth is the first (default) >

Re: [firebird-support] How to check and (possibly) repair new authorization system on Firebird 3.0.1

On 2017-03-01 09:34, jonatan.laurit...@yahoo.dk [firebird-support] wrote: > Hi! > > Our client has Firebird 3.0 super server installation which has the > following behaviour: > - Client software (e.g. Flamerobin) can establish connection using > Firebird 2.x fbclient.dll > - When client software

Re: [firebird-support] Firebird 2.5 classic performance issue on linux64

On 26-2-2017 17:46, andreasmzel...@yahoo.de [firebird-support] wrote: > I originally tried to post to this like I would to a normal mailing list. > I've never seen an open source project that required me to have a yahoo > account ;) I have a firebird-related problem however. You don't need an

Re: [firebird-support] dropping the connection

On 2017-02-21 17:32, Nick Upson n...@telensa.com [firebird-support] wrote: > Hi > > The problem I'm trying to solve is users leaving inactive db_workbench > sessions attached to a database while other work is going on by other > processes, causing a large OIT gap and the consequent problems. The

Re: [firebird-support] FIREBIRD PIVOT function or Matrix

On 14-2-2017 15:48, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 14.02.2017 14:15, 'Stef' s...@autotech.co.za [firebird-support] wrote: >> Any suggestions on my DB design and query to display the values in matrix >> (pivot) format? > >Simple client-side code can show you

Re: [firebird-support] Charset and Font Character Set for IBX TIBDatabase component

On 10-2-2017 08:34, jonatan.laurit...@yahoo.dk [firebird-support] wrote: > IBExpert uses two settings for database charsets: > - Charset (apparently Database related) and > - Font Character Set (apparently Client related) > > As I understand then Charset is the same setting as lc_ctype=UNICODE_FSS

Re: [firebird-support] Connection with Problem

Please send your question to the Firebird-java list instead. If you do that, make sure to include more information: - the code you use - the version of Jaybird - the version of Firebird - the full stacktrace of the exception Mark - Bericht beantwoorden - Van: "Guilherme Henrique

Re: [firebird-support] Firebird : join table from two database

On 12-1-2017 21:44, startx252...@yahoo.fr [firebird-support] wrote: > What is the way to make a join from 2 tables in two respective database > (in same server) ? > > ex : > > Db1 > TableA > > > Db2 > TableB > > > how can i make somethink like this : > > SELECT tA.MATRICRS, tB.name, tB.age > FROM

Re: [firebird-support] How to identify if field of table is identity or not?

On 12-1-2017 17:22, hamacker sirhamac...@gmail.com [firebird-support] wrote: > hi All, > > I did a procedure that recompute all identity fields of a list with > items separate by comma, but I need a method to check if table.field is > identity or not. It´s a procedure of mainnitence. For Firebird

Re: [firebird-support] Time zones

On 12-1-2017 15:09, Tim Ward t...@telensa.com [firebird-support] wrote: > Sorry if this is a really basic question, but some time spent searching > has failed to find for me the definitive detailed documentation on > exactly how Firebird handles time zones (I'm particularly interested, to > start

Re: [firebird-support] There is a verb to supply identity columns?

On 11-1-2017 12:00, hamacker sirhamac...@gmail.com [firebird-support] wrote: > Colums identity in FB3, I love it! > > But there is one thing missing. > > I would like to know, if exists a verb to supply identity value to not > assume a literal value. Ex: > > create table test ( >id integer

Re: [firebird-support] Firebird : find strign in all database

On 11-1-2017 10:35, startx252...@yahoo.fr [firebird-support] wrote: > > > i mean taht i have no result (it's empty) and i am sure my string existe > in one table That is probably because you are using ' WHERE '||:DANSCOLONNE||' = ?' instead of ' WHERE '||:DANSCOLONNE||' = ''%'' || ? || ''%'''

Re: [firebird-support] Firebird : find strign in all database

On 11-1-2017 10:02, startx252...@yahoo.fr [firebird-support] wrote: > i have this code but something gone wrong Please be more specific than "something gone wrong" Mark -- Mark Rotteveel

Re: [firebird-support] find a string records in all my tables

On 10-1-2017 18:10, startx252...@yahoo.fr [firebird-support] wrote: > I am looking for a procedure or a function to find a stirng in my database > > I have a DB with 200 tables and want to find a specific string (record) > in a my DB > > I don't know the name of table / field. There are no

Re: [firebird-support] Updating Firebird version and database compatibility issue

On 9-1-2017 18:08, Leandro Melo de Sales leandromsa...@gmail.com [firebird-support] wrote: > Scenario: My customer has a Linux CentOS 5.7 with Firebird TCP/IP server > version LI-V2.5.2.26540 Firebird 2.5. I want to update his Linux server > to Ubuntu latest version. My customer uses a

Re: [firebird-support] "EXTRACT (YEAR FROM DT.DATA) <= 2016" or "DT.DATA <= '12/31/2016'"

On 2016-12-09 12:35, Luigi Siciliano luigi...@tiscalinet.it [firebird-support] wrote: > Hallo, > >what is more performant from subject? Could you please put all pertinent information of your question in the body, and not only in the subject. It makes questions a lot easier to read

<    1   2   3   4   5   6   7   8   9   >