Re: [firebird-support] Re: NEXT VALUE FOR on Firebird 3.0.1 32bit Windows 7 32bit

On 6-12-2016 09:23, Dmitry Yemanov dim...@users.sourceforge.net [firebird-support] wrote: > Check RDB$GENERATOR_INCREMENT inside RDB$GENERATORS. NEXT VALUE FOR uses > the increment stored inside the system table. I noticed something interesting, when restoring a Firebird 2.5 database to

Re: [firebird-support] SS FB3.01 - Is it possible to set CPU utilization to max?

On 6-12-2016 03:59, trsk...@yahoo.com [firebird-support] wrote: > During project development/testing or database maintenance, such as > backup/restore, mostly, there is only 1 connection to FB Server. > > I have 6 core processors and during those process, cpu's utilization is > about 16%. I knew,

Re: [firebird-support] Overflow problem

On 2016-11-25 15:29, Lester Caine les...@lsces.co.uk [firebird-support] wrote: > On 25/11/16 13:56, Mark Rotteveel m...@lawinegevaar.nl > [firebird-support] wrote: >> On 2016-11-25 12:40, Lester Caine les...@lsces.co.uk >> [firebird-support] >> wrote: >>> >

Re: [firebird-support] Overflow problem

On 2016-11-25 12:40, Lester Caine les...@lsces.co.uk [firebird-support] wrote: > Nothing to do with Firebird but can anybody explain why the numbers in > 'SELECT FIRST 102121121121212 SKIP 3574239239242420' would be a problem > in MySQL or is it some other vulnerability the original sQL injection

Re: [firebird-support] Blob Sub Type 1 and character limits with UTF8

On 24-11-2016 11:02, Si Carter s1car...@gmail.com [firebird-support] wrote: > Using FB3 on windows I get the error message: > > String literal with 30465 characters exceeds the maximum length of 16383 > characters for the UTF8 character set > > As a test I created a new db (UTF8) with the

Re: [firebird-support] Unable to upgrade database to firebird 3.0

Firebird 3 does not support old ODS versions. You will need to backup with Firebird 2.5 and then restore under Firebird 3. Mark - Bericht beantwoorden - Van: "'Joje' j...@codework-solutions.com [firebird-support]" Aan:

Re: [firebird-support] Is Try_Cast in Firebird?

On 17-10-2016 12:10, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: > No there isn't, although you could build something like that > yourself in > Firebird 3 with PSQL functions. > > Mark > -- > Mark Rotteveel > > Hi Mark, > > yes, PSQL function can be

Re: [firebird-support] Is Try_Cast in Firebird?

On 17-10-2016 10:10, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: > i know > Cast('XXX' AS Integer) > but is there > try_Cast('XXX' AS Integer) > like in MSSQL? > you know if something can not by converted then return null. No there isn't, although you could build

Re: [firebird-support] Reviving an old firebird database (file conversion/programming hints)

On 13-10-2016 11:43, Helen Borrie hele...@iinet.net.au [firebird-support] wrote: > 64-bit or 32-bit - does not matter. You should be able to open that > v.1.5 database with either Fb 1.5 or 2.0.6. You would probably get > some errors trying to open it in Fb 2.1 or 2.5. That has nothing to > do

Re: [firebird-support] PR6036 - Win10 Firebird compatibility w/ Win 10

On 2016-10-06 14:26, abdi.m...@inergi.ca [firebird-support] wrote: > Hi There, We are updating our operating system from windows 7 to > Windows 10 64 bit and want to know the compatibility for the > application below: * Firebird 3.0 Firebird 3 and its client library are compatible with Windows

Re: [firebird-support] Compile Errors Firebird 3.0.1 Win32

You should post this to the Firebird-devel list instead. Mark - Bericht beantwoorden - Van: "'Mueller, Roland (GE87)' roland.muel...@honeywell.com [firebird-support]" Aan: "firebird-support@yahoogroups.com" Onderwerp:

Re: AW: AW: [firebird-support] High number of NULL attachments

Could you please stop posting responses like "Perfect", "Thanks" and "Great, Thanks!", "Hello", etc. It is unnecessary filler that doesn't contribute anything to the mailing list Over the last 3 months you have only posted response like that to the list (and no other real contributions). Mark

Re: [firebird-support] Unable to execute large text inside stored procedures.

Which version of Firebird are you using? And show the code of your stored procedure. Mark - Bericht beantwoorden - Van: "'Joje' j...@codework-solutions.com [firebird-support]" Aan: Onderwerp: [firebird-support] Unable

Re: [firebird-support] Connecting to Firebird 3.01 with JDBC

On 23-9-2016 06:00, trsk...@yahoo.com [firebird-support] wrote: > I have set WireCrypt to Disabled/Enabled, the error changed to : > Error occurred during login, please check server firebird.log for details > > When I read on firebird.log, here are the error : > Authentication error No matching

Re: [firebird-support] Vulnerability

On 26-9-2016 22:56, Carlos Mazariegos carlosemazarieg...@gmail.com [firebird-support] wrote: > I understand firebird is not equal interbase, > but the problem is that the Firewall Palo Alto, > Palo Alto detected the vulnerability with my application, which is built > with: It didn't detect the

Re: [firebird-support] Connecting to Firebird 3.01 with JDBC

On 2016-09-22 11:01, trsk...@yahoo.com [firebird-support] wrote: > Hi guys, > > Anyone here able to connect to FB 3.01 with JDBC 2.x? > > I have tried with jaybird-full-2.2.11 & have adding these lines to > firebird.conf > 1) UserManager = Srp, Legacy_UserManager > 2) AuthClient = Srp, Win_Sspi,

Re: [firebird-support] "nbackup needs local access to database file"

On 11-9-2016 09:11, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > Gbak and nbackup are different tools that work in a different way. Gbak > works through a Firebird server (real or embedded), while nbackup works > with the physical backup file. That should have been

Re: [firebird-support] "nbackup needs local access to database file"

On 10-9-2016 23:34, fabia...@itbizolutions.com.au [firebird-support] wrote: > I am getting this error while running nbackup: > > "nbackup needs local access to database file" > > The nbackup sentence is: > > Nbackup.exe -user SYSDBA -pas HereMyPass -B 0 > localhost:MyDB_FB3.fdb

Re: [firebird-support] Change Description

You need to use comment on: http://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-ddl-comment.html Mark - Bericht beantwoorden - Van: "gregorkob...@yahoo.com [firebird-support]" Aan:

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

On 26-8-2016 22:27, Jardar Maatje jardar.maa...@nds.nortek.no [firebird-support] wrote: > We are running fb 2.5.6 and are getting the INET erorr regularily. > The error has been there before as well with earlier versions of fb. > > Is this something I should be conserned about and what can I do

Re: [firebird-support] Delete causes server to hang

The rows clause does work on delete (and update) statements. Mark - Bericht beantwoorden - Van: "'livius' liviusliv...@poczta.onet.pl [firebird-support]" Aan: Onderwerp: [firebird-support] Delete causes server to hang

Re: [firebird-support] Delete causes server to hang

Which Firebird version are you using, and do you use Super, Classic or SuperClassic? Mark - Bericht beantwoorden - Van: "kragh.tho...@yahoo.com [firebird-support]" Aan: Onderwerp: [firebird-support] Delete causes

Re: [firebird-support] IDE web for firebird

On 28-7-2016 18:38, Carlos Mazariegos carlos.mazarie...@umg.edu.gt [firebird-support] wrote: > Exist any ide or manager web for administration firebird from 2.1 to 3.0 > version? Yes: https://github.com/mariuz/firebirdwebadmin -- Mark Rotteveel

Re: [firebird-support] how to get rownum

On 28-7-2016 04:49, 'hz.yb' hz...@foxmail.com [firebird-support] wrote: > > > i want to get rownum？how to select？thanks > > table： > CREATE TABLE PZ ( > ID INTEGER NOT NULL, > RQ TIMESTAMP NOT NULL, > JE DECIMAL(18,2), > /* Keys */ > PRIMARY KEY (ID) > ); > > data： > INSERT INTO PZ

Re: [firebird-support] from FB 2.5.2 to 2.5.6 and C application

Can you create a bug on http://tracker.firebirdsql.org/browse/CORE Mark On 27-7-2016 08:28, ehmmm.fireb...@seznam.cz [firebird-support] wrote: > > > Adding some notes: > > Examples stat3.e and stat5.e from /opt/firebird/examples/stat/ don't > work, while stat2.e works. > I'm getting the same

Re: [firebird-support] Firebird - errors logs

Given you are using 2.1.5, it is entirely possible you are experiencing a bug that crashed the server that was fixed in a more recent release. Mark - Bericht beantwoorden - Van: "'maciej...@gmail.com' maciej...@gmail.com [firebird-support]" Aan:

Re: [firebird-support] Firebird - errors logs

I already covered that one in my reply to your previous question. The error means connection refused, which usually means that the client is trying to connect to a Firebird insurance that isn't running (or to the wrong port). Mark - Bericht beantwoorden - Van: "'maciej...@gmail.com'

Re: [firebird-support] Firebird - explanation of errors

On 19-7-2016 06:25, 'maciej...@gmail.com' maciej...@gmail.com [firebird-support] wrote: > I have a question about the information in the log Firebird (version > Firebird: 2.1.5.18496).). The server was installed as SuperServer. The > problem occurs in Windows XP SP3. 2.1.5 is not the latest 2.1;

Re: [firebird-support] Transaction in limbo

Of course there is: just call isc_prepare and never commit or rollback. Mark - Bericht beantwoorden - Van: "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]" Aan: Onderwerp: [firebird-support] Transaction in

Re: [firebird-support] Transaction in limbo

On 19-7-2016 12:14, michael.vilhelm...@microcom.dk [firebird-support] wrote: > As I read about 2 phase commits, its about 2 databases. We do not use > more than one Not really, two-phase commits can also be applied to a single database, single connection. It just means that instead of doing an

Re: [firebird-support] Transaction in limbo

On 19-7-2016 09:32, michael.vilhelm...@microcom.dk [firebird-support] wrote: > I have a database, which have had to instances where there have been > Transactions in limbo. > I know how to fix this. > > I am on the other hand unsure why they appear. > What can cause this? > What should/could I

Re: [firebird-support] Error while parsing procedure procname's BLR

On 15-7-2016 09:42, Norbert Saint Georges n...@tetrasys.eu [firebird-support] wrote: > -CHARACTER SET ISO8859_1 is not installed > X-Newsreader: MesNews/1.08.05.00 > > I try to connect embedded mode via master interface with the code > (Pascal). > <-- > master :=

Re: [firebird-support] FDR file in Firebird folder

On 28-6-2016 20:03, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 28.06.2016 19:46, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] > wrote: >> I've never heard of such a file, does anyone have an idea what it could be? > >I would bet on a dat

[firebird-support] FDR file in Firebird folder

I just came across this question on Stackoverflow: http://stackoverflow.com/questions/38070209/what-is-this-file-fdr-in-the-directory-firebird The question is: "what is this file .fdr in the directory Firebird . For me, it weighs 16 gb. Is this a transaction log ? Or how to reduce it ?" I've

Re: [firebird-support] It works on FB 2.5 but does not work in FB 1.5

On 2016-06-23 22:06, Gabriel Frones grfro...@gmail.com [firebird-support] wrote: > Eu preciso de informações sobre suas tabelas (essas envolvidas) e > que tipo de relatório essa view fornece pra te dar uma query que > funcione. Mas uma dica geral a principio é: isole o problema. > Primeiro

Re: [firebird-support] performance issue with firebird 3.0 embedded on linux

On 15-6-2016 17:55, chen hsu chen...@outlook.com [firebird-support] wrote: > Thanks, Helen. Please see my replies inline. > > I am sure it is not 3.0 specific, 2.5 is the same. and the main issue is > scalability, sequential transaction performance is actually pretty good, > comparable to ESE

Re: [firebird-support] Engine12 mistery

On 2016-06-14 19:44, fabia...@itbizolutions.com.au [firebird-support] wrote: > My understanding from reading the documentation is: > > Provider = Remote means the client is on the network, excluding > 127.0.0.1 > Provider = Loopback means the client is actually on the same OS > instance as the

Re: [firebird-support] Engine12 mistery

Engine12 is actually the post of Firebird 3 that is the implementation of the database server (and understands ODS12). So it is a required part of Firebird 3. Mark - Bericht beantwoorden - Van: "fabia...@itbizolutions.com.au [firebird-support]" Aan:

Re: [firebird-support] Re: accessing firebird on windows from linux

On 7-6-2016 13:50, Virgo Pärna virgo.pa...@mail.ee [firebird-support] wrote: > On Tue, 17 May 2016 16:43:51 +0200, robert rottermann rob...@redcor.ch > [firebird-support] wrote: >> >> This is the connection string I use: >> engine = >>

Re: [firebird-support] Re: FB 3.0, got problem when add field to Table with existing data

On 2016-06-02 6:20, trsk...@yahoo.com [firebird-support] wrote: >> What value must it have? Add a default clause to this statement. Or > add > > the field as nullable, populate with data and then alter to NOT > NULL. > > I have tried to add field as nullable, then tried to alter to not > null. >

Re: [firebird-support] Searching for FB3 backup suggestions

Sorry, I just realised I was thinking of an option that had been removed. You need to run Firebird as SuperClassic or Classic (or do the backup through localhost as suggested earlier. Mark - Bericht beantwoorden - Van: "'Mark Rotteveel' m...@lawinegevaar.nl [firebird-su

Re: [firebird-support] Searching for FB3 backup suggestions

You need to backup through localhost, or you need to set the database in databases.conf (or the Firebird default in Firebird.conf) to Shared. You should have had the same problem with Firebird 2.5 if you used SuperServer. Mark - Bericht beantwoorden - Van: "dondondonje...@yahoo.com

Re: [firebird-support] FB 3 issues with String from FB 2.54

On 23-5-2016 03:45, fabia...@itbizolutions.com.au [firebird-support] wrote: > I have been trying to migrate from FB2.54 into FB 3 for a few weeks, and > after hitting a string related error for some time i have got to the > point where I do understand the issue, but I don't know how to solve it. >

Re: [firebird-support] Re: Minimal file file requirements for FB3 (client/embedded)

On 2016-05-25 8:31, josef.gschwendt...@quattro-soft.de [firebird-support] wrote: > Hi, > > what is with msvcp100.dll and msvcr100.dll? > > Are these files not required? They are required if the MS Visual C 2010 runtime is not installed on the machine. In my experience it usually is, but it

Re: [firebird-support] accessing firebird on windows from linux

On 20-5-2016 13:21, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > I think you have too many `/` after the port number. Try > > sa.create_engine('firebird+fdb://SYSDBA:thekey@10.42.1.150:3050/c:\\Users\\elvis\\Documents\\VAS.fdb') > > It would also be very

Re: [firebird-support] accessing firebird on windows from linux

On 17-5-2016 16:43, robert rottermann rob...@redcor.ch [firebird-support] wrote: > Hi there, > > I try to access a firebird db on windows from my ubuntu box. > I have a gui-tool (FlameRobin), from which this works nicely. Therefore > it is not a firewall or access problem. > > Now I would like to

Re: [firebird-support] Minimal file file requirements for FB3 (client/embedded)

On 17-5-2016 18:08, josef.gschwendt...@quattro-soft.de [firebird-support] wrote: > could please anybody tell us which files we definitely have to ship with > our app as client for a FB3 remote server or as an FB3 embedded server? > (minimal files required). > > Standard Client: > - fbclient.dll

Re: [firebird-support] Checking Ods version (2.5 <-> 3.0)

On 12-5-2016 20:18, liviusliv...@poczta.onet.pl [firebird-support] wrote: > This detection is useless . > use the latest library (FB3) and you can connect to any older servers But that isn't really useful if you want to find out if you need to upgrade a database. Mark -- Mark Rotteveel

Re: AW: [firebird-support] Simply bad, new is not always better. FB3 and ODBC

On 11-5-2016 16:04, 'Checkmail' check_m...@satron.de [firebird-support] wrote: > I have already tested the new version of firebird, but I think it is not my > part to understand everything how firebird works. MSSQL I can install in > every version, except new functions everything works in a new

Re: [firebird-support] Simply bad, new is not always better. FB3 and ODBC

On 10-5-2016 16:03, 'Checkmail' check_m...@satron.de [firebird-support] wrote: > We had FB 2.5 CS before our migration to fb 3 SS. After this, the > Frontend (MS-ACCESS) calls a stored procedure and sometimes the > odbc-driver does not wait until the procedure finished and writes the > new

Re: AW: [firebird-support] Simply bad, new is not always better. FB3 and ODBC

On 2016-05-12 7:37, 'Checkmail' check_m...@satron.de [firebird-support] wrote: > Hello again, > > the most funkctionality are very simply, just tables who linked to > msaccess. > I thought that firebird in every version can do this without any > problems - > how I said is this not in every case

Re: [firebird-support] SQL standard for sort fields and returned fields

ebird-support@yahoogroups.com> Onderwerp: [firebird-support] SQL standard for sort fields and returned fields Datum: ma, mei 9, 2016 23:54 Perfect On Monday, May 9, 2016 8:48 PM, "'Mark Rotteveel' m...@lawinegevaar.nl [firebird-support]" <firebird-support@yahoogroups.com> wrote:

Re: [firebird-support] SQL standard for sort fields and returned fields

Ah. It is the exception, because ordering by column index (en order by 1, 3) uses the index of the column in the select list, so by definition that column needs to be in the list. Mark - Bericht beantwoorden - Van: "liviusliv...@poczta.onet.pl [firebird-support]"

RE: [firebird-support] FW: HowTo for Plugins

On 2016-05-09 16:22, Ralf Jansen ralf.jan...@mailstore.com [firebird-support] wrote: > Hi, > > really? The groups disclaimer states „DO NOT USE THIS LIST FOR > SUPPORT QUESTIONS REGARDING RELEASED VERSIONS.” > > Ralf In my opinion, the plugin system is not documented enough and therefor not

Re: ODP: Re: [firebird-support] SQL standard for sort fields and returned fields

On 2016-05-09 15:29, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: > hi, > > could you explain this exception? > And i also have not sql standard to look into and need some exact > confirmation about this (something like Sql92 or sql2013.. say this) I see no exception, did

Re: [firebird-support] FW: HowTo for Plugins

On 2016-05-09 10:36, Ralf Jansen ralf.jan...@mailstore.com [firebird-support] wrote: > Hi, > > unfortunately, my question didn't get anything as response so I > assume that there isn't a documentation dedicated to writing plugins. > Let me try a more concrete question on the subject. > > I was

Re: [firebird-support] SQL standard for sort fields and returned fields

On 2016-05-09 11:45, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: > Hi, > > This is not specific to Firebird question but: > is something in SQL standard specification about sorted fields must > be > also returned? > I mean: > > SELECT > [FILM_DATE,]FILM_TITLE > FROM >

Re: [firebird-support] EF6 - Why extra index created?

On 2016-05-09 0:35, 'e...@emel.hu' e...@emel.hu [firebird-support] wrote: > I try the ordinary EF CodeFirst test with latest packages for new > FB3. ... > BUT: why is created a "IX_Posts_blogId" index when the > "FK_Posts_Blogs_blogId" index created for FK? This question is more suitable for

Re: [firebird-support] conect flamerobin with Firebird3

On 2016-04-26 14:10, 'Ismael L. Donis Garcia' sli...@citricos.co.cu [firebird-support] wrote: > Create a firebird 3 bd in another user who is not sysdba > and create a role called sysdba without permission Creating a role called SYSDBA will disallow the user SYSDBA to connect to Firebird. >

Re: [firebird-support] General: connect firebird server from local network

On 23-4-2016 11:33, Helen Borrie hele...@iinet.net.au [firebird-support] wrote: > Hello Mark, > > Saturday, April 23, 2016, 6:02:00 PM, you wrote: > >> As far as I know even in Firebird 2.5 and earlier, settings like >> ConnectionTimeout, TcpRemoteBufferSize and maybe some other settings >>

Re: [firebird-support] General: connect firebird server from local network

On 22-4-2016 20:22, Helen Borrie hele...@iinet.net.au [firebird-support] wrote: > Mark, since the OP was referring to "aliases.conf" he evidently isn't > trying to work with Firebird 3, which doesn't have aliases.conf. > > In prior releases, firebird.conf is relevant locally only if the > client

Re: [firebird-support] General: connect firebird server from local network

On 2016-04-21 21:13, Helen Borrie hele...@iinet.net.au [firebird-support] wrote: >> DB-Application @ PC-B > ->> fbclient.dll > ->> Pickup Firebird Server IP/Name from firebird.conf > > No. Firebird.conf and aliases.conf are components of the server host, > not of the client. Fbclient.dll is

Re: [firebird-support] Installing Firebird 3.0 alongside Firebird 2.5 and 2.1

On 2016-04-20 8:29, michael.vilhelm...@microcom.dk [firebird-support] wrote: > Hi > > I have a testserver currently running both Firebird 2.1 and 2.5. > I need this to support and test various situations with different > firebird versions. > > Now I would like to install Firebird 3.0 manually as

Re: [firebird-support] Embedded FB3 was killed?

Firebird embedded still exists, but looking at the release notes, it might require a bit more explicit coverage. In short, you need fbclient.dll and engine12.dll (or their Linux equivalent). There is no separate fbembed.dll anymore. Mark - Bericht beantwoorden - Van:

Re: [firebird-support] [FB 2.1] Firebird engine seems to slow down on high load without utilizing hardware

On 2016-04-11 13:55, thetr...@yahoo.com [firebird-support] wrote: > hi, > > recently we had some strange performance issues with our Firebird DB > server. > > We would be very grateful if anyone can give us hints where we can > search further. > > Or someone has similar experiences to share with

Re: [firebird-support] Firebird V3RC2 Primary Key question

On 7-4-2016 23:01, Ertan Küçükoğlu ertan.kucuko...@1nar.com.tr [firebird-support] wrote: > Would you be so kind to provide an example SQL which shows how to do > primary key with a case insensitive collation? 1. Register the WIN1254_UNICODE collation (it is defined in fbintl.conf, but not

Re: [firebird-support] Antivirus Exclusions

On 5-4-2016 17:18, tcanfiel...@hotmail.com [firebird-support] wrote: > I'm trying to set the exclusions for one of our servers and I see > Firebird running. > > I don't have any experience with this program and I was hoping someone > on the forum could shed some light on the needed exclusions. > >

Re: [firebird-support] FB on LAN

On 7-4-2016 20:54, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: > Hello Mark. > > I was like you showed 192.168.0.158:C:\DIR1\BASEDIR\MYDATABASE.FDB > > Than I changed from FB 32 to FB 64 and it stopped working. After that, > after that even turnning to FB 32 it doesn´t work using this

Re: [firebird-support] Firebird V3RC2 Primary Key question

This is the default and expected behavior. If you want case insensitive, then you need to create the primary key column with a case insensitive collation. Mark - Bericht beantwoorden - Van: "Ertan Küçükoğlu ertan.kucuko...@1nar.com.tr [firebird-support]"

Re: [firebird-support] VIEW optimization

Also consider the situation with multiple rows on the other side of the join: in that case the one side repeats as many times as there are rows - Bericht beantwoorden - Van: "'Mark Rotteveel' m...@lawinegevaar.nl [firebird-support]" <firebird-support@yahoogroups.com>

Re: [firebird-support] VIEW optimization

; Onderwerp: [firebird-support] VIEW optimization Datum: do, apr. 7, 2016 19:06 2016. 04. 07. 18:48 keltezéssel, 'Mark Rotteveel' m...@lawinegevaar.nl [firebird-support] írta: > Why wouldn't it be necessary, this is an inner join, so the joined table > needs to be evaluated if the matches row

Re: [firebird-support] VIEW optimization

Why wouldn't it be necessary, this is an inner join, so the joined table needs to be evaluated if the matches row is present. Mark - Bericht beantwoorden - Van: "Gabor Boros gaborbo...@yahoo.com [firebird-support]" Aan:

Re: [firebird-support] FB on LAN

On 2016-04-07 14:41, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: > Hello. > > Thanks for answer my question. > > I changed the connection (Deplhi XE10 / DBX) to > \\192.168.0.158\C:\DIR1\BASEDIR\MYDATABASE.FDB and it works. With this change you are using a different protocol than you

Re: [firebird-support] Timestamp conversion issue

On 2016-04-07 5:26, Alex Castillo acr_k...@yahoo.com [firebird-support] wrote: > I've no doubt this is a bug for the linux release. It should be > filtering the string literals before doing the conversion as it does > on Windows. I don't think it is a bug. Firebird supports the SQL standard

Re: [firebird-support] FB on LAN

Have you checked the difference between the two Firebird.conf? You seem to be using relative paths to connect the database; I believe that depends on the RootDirectory setting. Mark - Bericht beantwoorden - Van: "Hugo Eyng hugoe...@msn.com [firebird-support]"

Re: [firebird-support] RE: unsubscribe

On 2016-04-04 9:08, Hasnain Najafi hasnain.naj...@boots.co.uk [firebird-support] wrote: > unsubscribe > > Regards, > > HARDWARE REFRESH TEAM To unsubscribe send a mail to firebird-support-unsubscr...@yahoogroups.com with subject: Unsubscribe Mark

Re: [firebird-support] Timestamp conversion issue

On 2016-04-05 10:47, Alex Castillo acr_k...@yahoo.com [firebird-support] wrote: > Hello everyone, > > I'm having some issues with a stored procedure. This is a legacy > development, so the time was stored in a varchar field and the date > in > a timestamp field. > > The issue stills happens

Re: [firebird-support] Re: UDF install in FB3.0 RC2

On 21-3-2016 09:19, russ...@belding.co.nz [firebird-support] wrote: > Thanks Vlad. I am failing with fb3 rc2 3.0.0.32366. > Yours is? > I will re-install and try again tomorrow. I believe you mentioned earlier that you were testing FB3 RC2 on a fresh install. Maybe the old UDFs require the

Re: [firebird-support] RECREATE Procedure issue.

On 2016-03-17 15:49, Joje j...@codework-solutions.com [firebird-support] wrote: > Hi All, >  I am facing a issue with 'RECREATE' procedure. > > Problem: > I have a stored procedure that uses 'RECREATE Procedure', this > procedure does not execute properly when executed in EMS SQL manager > for

Re: [firebird-support] RECREATE Procedure issue.

On 2016-03-18 9:10, Joje j...@codework-solutions.com [firebird-support] wrote: > I am executing this query using my .net application and it is not > throwing any error. If there was a error then it would log that error > and will display it to the user. If it is not throwing an error, then I

Re: [firebird-support] Error with > 10 columns in SQL SELECT query using python firebirdsql

On 2016-03-17 5:54, ggoo...@yahoo.com [firebird-support] wrote: > I am querying a Firebird 1.5.3 database with python code using the > python firebirdsql module. All works well (query returns values as > expected) with up to 10 columns from two tables, but when I add an > 11th column I get the

Re: [firebird-support] RECREATE Procedure issue.

On 19-3-2016 11:51, j...@codework-solutions.com [firebird-support] wrote: > Regarding thus issue could someone raise a ticket & update the > documentation of firebird. You can create tickets at http://tracker.firebirdsql.org/browse/DOC Mark -- Mark Rotteveel

Re: [firebird-support] RECREATE Procedure issue.

On 19-3-2016 04:44, j...@codework-solutions.com [firebird-support] wrote: > If it's not executing then it should send a message. Also I referred the > site documentation of recreate procedure. But there was no specific info > about dependency in stored procedure. > > But later when I referred the

Re: AW: Re: [firebird-support] timestamp of the firebird database (modified date) does not change in fb 3.0 RC2

On 2016-03-11 13:40, 'Checkmail' check_m...@satron.de [firebird-support] wrote: > Hi, > > my third ticked within three days. What should I do, windows ticket? > E-Mail an microsoft? ;) It is expected behavior. See

Re: AW: [firebird-support] coalesce bug in fb 3.0 rc2?

On 2016-03-09 7:57, 'Checkmail' check_m...@satron.de [firebird-support] wrote: > Hello again, > > sorry, outlook corrects me in German. At the moment, I have no > sulution for the problem. Anything ideas? I think you should create a sample database to demonstrate this problem, and create a

Re: [firebird-support] coalesce bug in fb 3.0 rc2?

On 2016-03-08 16:18, 'Checkmail' check_m...@satron.de [firebird-support] wrote: > Hello, > > in the further version of firebird I can execute the following and > get > the real value of m (exists in tlager_sum) > > select a.teilenr, a.bezeichnung, a.minb, coalesce(b.menge,0) as m, > a.typ > >

Re: [firebird-support] How write a query with a progressive sum field

On 2016-03-07 11:32, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 07.03.2016 11:16, Luigi Siciliano luigi...@tiscalinet.it > [firebird-support] wrote: >> How I do? > >sum(saldo) over (order by data) That only works with Firebird 3. Mark

Re: [firebird-support] FB3 RC2 error with Flamerobin

On 6-3-2016 17:55, 'esdonisgarcia' esdonisgar...@sisconge.hol.es [firebird-support] wrote: > You can use a Flamerobin with FB3 RC2? Yes you can, but you need to make sure that you either use the libfbclient.so of Firebird 3, or that you set the encryption setting to Enabled (or Disabled)

Re: [firebird-support] When do I need the FB 3 client libs?

On 2016-03-04 12:45, Köditz, Martin martin.koed...@it-syn.de [firebird-support] wrote: > Hi, > > I wonder when to use the new client libs. For getting more concrete: > I > run a web server with apache using the FB 2.5 client libs to access > the FB 3.0 RC 2 server. Is that constellation OK or

Re: [firebird-support] Re: Problems with connecting to Firebird 2.5.5 over TCP/IP on Linux (Ubuntu).

On 25 Feb 2016 08:29:14 -0800, "brucedickin...@wp.pl [firebird-support]" wrote: > @Mark I've tried 127.0.0.1 - the same error. > @Steve I've instaled xinetd (found some suggestions about that on > stackoverflow) > > I've run such command: > >

Re: [firebird-support] Problems with connecting to Firebird 2.5.5 over TCP/IP on Linux (Ubuntu).

On 25 Feb 2016 08:15:12 -0800, "brucedickin...@wp.pl [firebird-support]" wrote: > Hello guys, > > could you be so kind and help me to diagnose problem with connecting to > Firebird on Ubuntu? I do not have experience with linux (haven't touched it > for years).

Re: [firebird-support] database formats?

On 24 Feb 2016 06:29:20 -0800, "heineferre...@yahoo.com [firebird-support]" wrote: > Hi, > > Is there any difference between the database format of a 32bit Firebird > database vs a 64bit Firebird database? Depends on the Firebird version. I believe in 2.0 or

Re: [firebird-support] I can't drop foreign key

On 16-2-2016 22:05, watan...@yahoo.com [firebird-support] wrote: > I am using FireBird 2.5.3 > and a Database is updated from 2.2, and the database was updated from 1.5. > > The database have about 150 tables and just one foreign key. > > The Foreign key is from "hachu"Table to "parts"Table > >

Re: [firebird-support] how to suppress dashes in query results

On 11 Feb 2016 17:57:35 -0800, "ho...@agencybusys.com [firebird-support]" wrote: > Users can enter values with dashes (-) in random locations. I don't know > where they might put them. I need to select a record using a where clause > that doesn't have those

Re: [firebird-support] Firebird and web connection

On 6-2-2016 22:37, mlcvi...@yahoo.fr [firebird-support] wrote: > Hello I'm looking for any information on connecting to a firebird > database by IP adresse. > > The database is placed on a web server with a permanent IP... > > is it possible ?, and where to find information on how to do it...

RE: [firebird-support] system table behaviour

On Thu, 4 Feb 2016 15:55:29 +1100, "'Andrew Zenz' and...@aimsoftware.com.au [firebird-support]" wrote: > 'Tis starting to make some sense now. > > Unfortunately our application establishes a connection to the FB server > and remains active until shut down. I

Re: [firebird-support] What is more effective execute block or select?

On Thu, 28 Jan 2016 16:22:03 +0100, "Svein Erling Tysvær setys...@gmail.com [firebird-support]" wrote: > No, I must admit limited knowledge of MERGE. For Firebird 3 is seems like a > good alternative, but I think Fb 2.1 and 2.5(?) requires a WHEN NOT MATCHED >

Re: [firebird-support] What is more effective execute block or select?

On Wed, 27 Jan 2016 23:01:50 +0100, "setysvar setys...@gmail.com [firebird-support]" wrote: > [..] On the other hand, there are cases > where EXECUTE BLOCK can help performance (note, I speak for 2.5, I know > nothing about Firebird 3): > > UPDATE h > SET =

Re: [firebird-support] What is more effective execute block or select?

On Wed, 27 Jan 2016 10:48:49 -0200, "hamacker sirhamac...@gmail.com [firebird-support]" wrote: > I would know whats methods is more effective, per exemple: > To know if itens exists or not, select: > select > case > when exists(select 1 from cv_itens where

Re: [firebird-support] The PHP default transaction

On Thu, 21 Jan 2016 10:44:10 +, "Tim Ward t...@telensa.com [firebird-support]" wrote: > I've got a long running (hours) PHP script which does large numbers > (tens of thousands) of database operations along the lines of > > start explicit transaction >

<    1   2   3   4   5   6   7   8   9   >