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
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,
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:
>>> >
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
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
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:
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
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
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
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
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:
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
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
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
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
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,
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
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
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:
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
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
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
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
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
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
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:
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'
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;
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
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
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
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 :=
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
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
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
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
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
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:
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 =
>>
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.
>
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
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
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.
>
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
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
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
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
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
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
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
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
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:
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]"
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
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
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
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
>
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
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.
>
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
>>
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
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
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
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:
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
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
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.
>
>
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
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]"
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>
;
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
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:
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
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
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]"
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
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
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
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
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
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
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
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
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
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
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
>
>
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
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)
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
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:
>
>
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).
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
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
>
>
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
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...
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
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
>
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 =
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
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
>
501 - 600 of 804 matches
Mail list logo