On 2018-08-08 20:58, 'River~~' river14ap...@gmail.com [firebird-support]
wrote:
> Suggestion: if you have admin rights on the machine install a ramdisk
> (there are several available for Windows and MS themselves offered
> them for some earlier Windows versions) as say R: and tell Windows to
>
On 4-8-2018 15:06, 'River~~' river14ap...@gmail.com [firebird-support]
wrote:
> You are pedantically correct but...
>
> ALL storage in ALL modern computers is in binary.
This may sounds pedantic, but it is not in my opinion. I have seen
enough systems storing binary data by encoding it using
On 4-8-2018 13:05, Chuck Belanger phytot...@lanset.com
[firebird-support] wrote:
> This worked beautifully. Thank you!
>
> There was no need to change my code, simply add a new OCTETS based
> Domain and change domains on the field. All the Char(0)s are stored as
> 0's in what looks like a HEX
On 2018-08-01 09:14, Kjell Rilbe kjell.ri...@marknadsinformation.se
[firebird-support] wrote:
> The benefits, as I see it, are the object trees, command history, data
> grid, CSV export, log output with stats, syntax highlighting, etc. That
> said, I wish they would bring FlameRobin up to fully
On 31-7-2018 16:18, Lee Nash leen...@barbers.co.uk [firebird-support] wrote:
> I’m struggling to grant any privileges on a .fdb file database.
>
> I have created a separate user as the SYSDBA reported “Your login SYSDBA is
> same as one of the SQL role name. Ask your database administrator to
On 31-7-2018 10:44, trueriver river14ap...@gmail.com [firebird-support]
wrote:
> So my question is
>
> a: is there a CLI client I have overlooked in the docs?
Yes there is: isql (although some distributions rename it, eg isql-fb on
Ubuntu). See also
On 24-7-2018 16:46, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] wrote:
> 24.07.2018 14:31, eric.gueguin...@gmail.com [firebird-support] wrote:
>> By example how to do that :
>>
>> SELECT IDSYSCONFGROUP FROM SYS_CONF_GROUP
>> WHERE UPPER(CAST(SYSGROUP_NAME AS VARCHAR(100)
On 2018-07-19 01:31, Chuck Belanger phytot...@lanset.com
[firebird-support] wrote:
> Hello:
>
> My background with Firebird has been mostly to use it for a local
> desktop application. A few years ago we started to experiment with a
> remote connection on a website and I have had no issues with
On 18-7-2018 15:42, liviuslivius liviusliv...@poczta.onet.pl
[firebird-support] wrote:
> >>I suggest you take this question to the firebird-devel mailing list as
> >>it concerns an unreleased version. Questions on FB4 are off topic here.
>
> >>Mark
>
> Yes, but as local_time and
On 2018-07-17 18:39, 'livius' liviusliv...@poczta.onet.pl
[firebird-support] wrote:
> But how timezone settup is configured in FB4?
> Time zone is set in fbconfig (preffered) or is retrived from system?
> If from config, then CURRENT_DATE and LOCAL_TIMESTAMP will get
> different date when
On 2018-07-17 16:43, liviuslivius liviusliv...@poczta.onet.pl
[firebird-support] wrote:
>>> ANSI standard compliance is the answer for all questions
>
> What about last question LOCAL_DATE missed?
The SQL standard only knows a single DATE type (there is no DATE WITH
TIME ZONE type), so there
On 12-7-2018 21:24, Aldo Caruso aldo.car...@argencasas.com
[firebird-support] wrote:
> thanks for your answer.
>
> One question related to changing SYSDBA password for the first time
> without using gsec.
>
> I noticed that, as you have no other database than security3.fdb,
>
On 12-7-2018 16:24, Aldo Caruso aldo.car...@argencasas.com
[firebird-support] wrote:
> Hello,
>
> The gsec utility still exists in Firebird 3.0.2 ( Ubuntu 18.04
> distribution ), although its man page states that it is deprecated.
> I tested it and works. I have some scripts that use
On 2018-07-06 02:07, Hamish Moffatt ham...@risingsoftware.com
[firebird-support] wrote:
> On 05/07/18 21:06, Mark Rotteveel m...@lawinegevaar.nl
> [firebird-support] wrote:
>
>> On 5-7-2018 09:28, Hamish Moffatt ham...@risingsoftware.com
>> [firebird-support] wr
On 5-7-2018 09:28, Hamish Moffatt ham...@risingsoftware.com
[firebird-support] wrote:
> We're linking embedded Firebird in to our application on macOS. Ever
> since macOS 10.13, we are getting crashes whenever our application
> invokes a file open dialog.
>
> We have tracked this down to some
On 2018-06-21 10:34, André Knappstein knappst...@beta-eigenheim.de
[firebird-support] wrote:
> If it is what I think it is then it is probably widely known, just not
> to me :-)
>
> I would like to get certain, though, because I do have some respect
> for things happening and looking
On 19-6-2018 13:54, Svein Erling Tysvær setys...@gmail.com
[firebird-support] wrote:
>
>
> Hi Bhavbhuti!
>
> According to https://firebirdsql.org/refdocs/langrefupd15-case.html
>
> this is how case is written:
>
> CASE
> WHEN THEN result1
> WHEN THEN result2
> ...
> [ELSE
On 15-6-2018 17:00, Emil Totev em...@tot-consult.com [firebird-support]
wrote:
> As far as I understand, the Firebird 3 LINGER value is actually a
> property of the database (file). How can I check if this is set and to
> what? I thought GSTAT -h might show it, but it doesn't.
You can use
On 2018-06-15 10:37, 'Check_Mail' check_m...@satron.de
[firebird-support] wrote:
> Sorry, there is a before delete trigger active, it ist he problem
> (firebird has changed the weird sequence in FB3, in FB2.5 it works.
I'm not sure what you are trying to say here. What do you mean with
On 2018-06-14 16:54, alsme...@yahoo.it [firebird-support] wrote:
> // Extract from firebird.conf
>
> Providers = Remote,Loopback
By removing `Engine12` from the `Providers` list, you have removed the
option from Firebird to access its database engine implementation. This
means it can't access
On 10-6-2018 01:14, talorigo...@yahoo.co.uk [firebird-support] wrote:
> When I try to create the following stored procedure I get sql error code
> = -206 Column unknown EMPID
>
>
> SET TERM ! ;
> CREATE OR ALTER PROCEDURE TEST (
> ATITLE DOM_VARCHARTINY,
> AFIRST_NAME DOM_VARCHARMEDIUM,
>
On 2018-06-08 08:30, antoedinchar...@gmail.com [firebird-support] wrote:
> Is there any way that we could log last accessed time of a procedure.
>
> I am in a process of cleaning up 8 years old database. DB is having
> more than 1000 procedures in which only 10-20% will be using now after
>
On 1-6-2018 11:44, Dmitry Yemanov dim...@users.sourceforge.net
[firebird-support] wrote:
> 01.06.2018 10:30, Chuck Belanger wrote:
>>
>> 2. The difference turned out to be that for one there was actually some
>> source code in the fields. While the other that threw an error message,
>> already
On 2018-05-31 23:48, blackfalconsoftw...@outlook.com [firebird-support]
wrote:
> Thanks for the heads up, Mark...
>
> However, Carlos' explanation when I read through it again, does appear
> to be a little confusing at the least.
I have read it again, and I don't see how it is confusing. Might
On 2018-05-31 17:51, Chuck Belanger phytot...@lanset.com
[firebird-support] wrote:
> Hello:
>
> Per googling and Carlos Cantu's FB3 Migration Guide (page: 110), we are
> still allowed to set RDB$PROCEDURE_SOURCE = null, and yet when trying
> to
> do just that on my app's converted FB2.5 to FB3
On 2018-05-31 18:14, blackfalconsoftw...@outlook.com [firebird-support]
wrote:
> I just finished a complete review of Carlos' migration guide. I read
> it quite carefully but completely missed what appears to be a
> contradiction in his explanations for the updating of the source-code
> fields
On 30-5-2018 14:41, Gabor Boros mlngl...@bgss.hu [firebird-support] wrote:
> 2018. 05. 29. 19:08 keltezéssel, Omacht András aoma...@mve.hu
> [firebird-support] írta:
>> Hi Gabor!
>>
>> You can do it with recursive cte:
>
>
> First of all, thank you very much! But...
>
> I got "multiple rows in
On 27-5-2018 18:19, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] wrote:
> 27.05.2018 18:03, Ann Harrison aharri...@ibphoenix.com [firebird-support]
> wrote:
>> In addtion to Mark Rotteveel’s description of the system tables, you might
>> want to look at
>> the code in isql which
On 25-5-2018 22:47, 'livius' liviusliv...@poczta.onet.pl
[firebird-support] wrote:
> previously it was possible to change external table filename
> UPDATE
> RDB$RELATIONS r
> SET r.RDB$EXTERNAL_FILE='c.txt'
> WHERE
> r.RDB$EXTERNAL_FILE='b.txt'
> in FB3 it is prohibited.
> Is there some DDL
On 26-5-2018 19:49, blackfalconsoftw...@outlook.com [firebird-support]
wrote:
> However, considering that Firebird is not supported to the same extent
> as SQL Server, my software may make a useful addition to the growing
> number of third-party tools for Firebird.
>
> The problem is, I need
On 2018-05-24 07:37, 'Primoz Jenko' primoz.je...@domplan.si
[firebird-support] wrote:
> Hi!
>
> We have exact same problem. Author of some previous posts here in this
> group (THANK YOU AGAIN!) gave us the asnwer how to solve the problem.
The problem I have with this solution, is that when
On 23-5-2018 19:23, Eduard Calveras ecalve...@inforserveis.es
[firebird-support] wrote:
> Since few days ago, after Windows 10 update, some applications writes in
> Delphi can not connect to network Firebird 2.5.5 server.
> These applications can connect with BDE, InterBase, FIB, FireDac... but
On 21-5-2018 08:09, hugo.lar...@yahoo.com [firebird-support] wrote:
> I have a followup question.
> If I have a varchar(1000) column with 1000 characters in it and then i
> delete the value in only that column but keep the row. The row has other
> columns with values.
> Will the space be
On 19-5-2018 15:00, fabia...@itbizolutions.com.au [firebird-support] wrote:
> We are trying to define the best specs for a windows based Firebird 3 64
> bits instance.
>
> Based on our knowledge, and the type of applications running we know we will
> need the best possible performance for 1 to 10
On 2018-05-16 21:07, Issam Boughanmi amigof...@gmail.com
[firebird-support] wrote:
> hi Mark, thanks for the great answer :)
>
> ok let's forget Fb3 wire thing ...
> like i said i have already a working zebedee setup, now what is the
> main benefit for using ssh instead apart that zebedee
On 15-5-2018 22:00, Issam Boughanmi amigof...@gmail.com
[firebird-support] wrote:
> i have a firebird 3 database hosted on internet wich i want to access
> it via a desktop application .
> for that i need to make the communication as secure as possible .
>
> i have tested zebedee and it
On 16-5-2018 02:54, Helen Borrie hele...@iinet.net.au [firebird-support]
wrote:
> fo...@darsys.com.ar wrote:
>
>> Hi
>
>> Since few hours ago, in some customers after Windows 10 update, my app can
>> not connect to server.
>
>> Fb server works, and clients with previous Windows versions work.
On 15-5-2018 23:50, fo...@darsys.com.ar [firebird-support] wrote:
> Since few hours ago, in some customers after Windows 10 update, my app
> can not connect to server.
>
> Fb server works, and clients with previous Windows versions work.
>
>
> Error; 8004 - Unable to complete server request to
On 10-5-2018 12:12, 'Primoz Jenko' primoz.je...@domplan.si
[firebird-support] wrote:
>
>
> Hi, Mark,
>
> thank you very much for detailed questions!
>
> Answers are:
>
> -WIN 10 is only on client
>
> -We have tried both: embeded and locall – nothing was working
>
> -FB runs as service
>
On 10-5-2018 09:27, bog...@mordicom.si [firebird-support] wrote:
>
>
> We've had Firebird 2.0 database in dialect 1.
>
> When we installed 2.5 64 server, connection was not possible.
>
> If my memory serves me well
Ah, well as far as I know the dialect shouldn't make a difference there.
I
On 9-5-2018 16:48, 'Primoz Jenko' primoz.je...@domplan.si
[firebird-support] wrote:
> I would have a question why, after automatic upate of WIN 10, update
> package 1803,FB 2.0.5.13206 (our software using those two) generates an
> error 335544721, Failed to established a connection?
>
> We
On 10-5-2018 08:01, bog...@mordicom.si [firebird-support] wrote:
> What is the dialect of the database ?
I don't see how the dialect would be relevant for this problem. Could
you explain what problem you where thinking of?
Mark
--
Mark Rotteveel
On 2018-05-08 18:45, Issam Boughanmi amigof...@gmail.com
[firebird-support] wrote:
> i am writing a little .net application that connect to a remote
> database server hosted on internet to make a sort of replication .
>
> so the database source live in my local firebird server the
> destination
On 7-5-2018 17:04, B?lint Nagy bali...@hotmail.com [firebird-support] wrote:
> Fb Server version is WI-V2.0.3.12981 Firebird 2.0
>
> Any ideas?
Is your other application maybe connecting as Firebird Embedded instead
of through Firebird server? That could explain the difference in
behavior,
On 2018-05-05 19:49, Issam Boughanmi amigof...@gmail.com
[firebird-support] wrote:
> i have this heterogeneous cross database query
>
> execute block as
> DECLARE panum INT;
> DECLARE nom varchar(50);
> DECLARE prenom varchar(50);
> DECLARE dna date;
> DECLARE datemodif date;
> DECLARE m date;
>
On 2018-05-04 20:10, blackfalconsoftw...@outlook.com [firebird-support]
wrote:
> I must admit that I have spent many years working with various
> database engines, with SQL Server being the engine where the large
> majority of my professional development had been emphasized.
> Nonetheless, I have
On 2018-05-04 18:56, blackfalconsoftw...@outlook.com [firebird-support]
wrote:
> I am not sure if I understand your explanation here...
>
> 1...
> Why would I test the input parameter, "PI_KEY_IN" for each row? I am
> only doing this to ensure that the client never sends an input value
> of
On 4-5-2018 18:31, Steve Naidamast blackfalconsoftw...@outlook.com
[firebird-support] wrote:
> How so? The "SUSPEND" statement is the last statement in the procedure
> or are you referring to the fact that it is continued as a result of the
> previous "DO" statement?
A FOR .. DO is a loop
On 4-5-2018 18:13, Steve Naidamast blackfalconsoftw...@outlook.com
[firebird-support] wrote:
> However, I am not sure about the multiple "SUSPEND" statements on a
> per-record basis.
>
> If you look at my procedure below, you will note that there is only a single
> "SUSPEND" statement. Yet,
On 3-5-2018 15:52, Javier Cintron fcintr...@yahoo.com [firebird-support]
wrote:
>
>
> Thank you very much!
You shouldn't focus purely on this metric, greater page caches may lead
to more pages returned from memory, but also increase memory consumption
and overhead from things like cache
On 3-5-2018 17:05, Javier Cintron fcintr...@yahoo.com [firebird-support]
wrote:
> Yes That is right, I want to backup the database.
>
> I have a gap in the nigth to do it.
>
> I understand that by using gbak or nbackup Firebird doesnt need to be
> shutdown.
Yes, and if you use alter database
On 3-5-2018 16:11, Javier Cintron fcintr...@yahoo.com [firebird-support]
wrote:
> Firebird ver 2.5.7.27050 64 bits
> Superserver
> Windows Server 2012R2
>
> I have two questions:
>
> 1. When I need to copy my Firebird database: Do I need to shutdown the
> Firebird instance first? and If
On 1-5-2018 09:19, Brian Dunstan brian.duns...@health.telstra.com
[firebird-support] wrote:
> Hi,
>
> We have a big customer here who processes large numbers of transactions into
> a large database and plans to not backup and restore.
They should plan for backups and tests restores. But if you
On 27-4-2018 04:16, Hamish Moffatt ham...@risingsoftware.com
[firebird-support] wrote:
> I have a linux server with a local Firebird 2.5.8 server and utilities
> and the Firebird 3.0.1 client library. I need to connect to a remote
> Firebird 3 server as well as the local 2.5 server.
>
> isql
On 24-4-2018 20:47, 'livius' liviusliv...@poczta.onet.pl
[firebird-support] wrote:
>
>
> >
> > Hi,
> > I need to add Field not null constraint with my custom name.
> > in previous versions of Firebird we can do:
> > 1. ALTER TABLE XXX ADD FIELDX INTEGER CONSTRAINT NK_XXX__FIELDX NOT NULL;
On 24-4-2018 15:40, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] wrote:
> On 24-4-2018 09:34, liviuslivius liviusliv...@poczta.onet.pl
> [firebird-support] wrote:
>>
>>
>> Hi,
>> I need to add Field not null constraint with my custom name.
>> in pre
On 24-4-2018 09:34, liviuslivius liviusliv...@poczta.onet.pl
[firebird-support] wrote:
>
>
> Hi,
> I need to add Field not null constraint with my custom name.
> in previous versions of Firebird we can do:
> 1. ALTER TABLE XXX ADD FIELDX INTEGER CONSTRAINT NK_XXX__FIELDX NOT NULL;
On 22-4-2018 12:11, Lukas Gradl fireb...@ssn.at [firebird-support] wrote:
> Setting up a firebird.conf according to the document in Helens link I
> could connect again.
>
> The downside of this method is I have to restrict Client
> authentification for ALL servers to legacy_auth when using
On 22-4-2018 09:05, hele...@iinet.net.au [firebird-support] wrote:
> By default, the V.3 client tries to connect using SRP authentication
> protocol. The V.1.5 server cannot respond to that. You need to set up
> a client-side firebird.conf containing
>
> AuthClient = Legacy_Auth
>
> Take out Srp
On 19-4-2018 20:03, Lukas Gradl fireb...@ssn.at [firebird-support] wrote:
> I work from a debian linux machine having installen the 3.0.1 client
> libs from the repository and flamerobin from the repository.
>
> One of the machines I have to connect to regularily runs 1.5.5 on
> debian linux.
>
On 18-4-2018 18:15, blackfalconsoftw...@outlook.com [firebird-support]
wrote:
> One of the newer and nice error trapping features in T-SQL is the
> implementation of the "Try-Catch" block, which I used quite a bit when
> working on developing corporate databases.
That is supported in Firebird
On 18-4-2018 16:55, blackfalconsoftw...@outlook.com [firebird-support]
wrote:
> I have to disagree with your observation. It is clearly stated in the
> Firebird SQL Reference Manual that the development of Firebird-SQL is
> with a strict implementation of the SQL-92 Standard.
Could you
On 18-4-2018 16:27, blackfalconsoftw...@outlook.com [firebird-support]
wrote:
> Firebird's implementation of SQL is a very strict implementation of the
> SQL-92 Standard. As a result, this makes Firebird-SQL not only very
> limited in what it can do when compared to other SQL dialects but
>
On 2018-04-18 12:24, Vishal Tiwari vishuals...@yahoo.co.in
[firebird-support] wrote:
> Hi Mark,
>
> I want to use TSQL in Firebird, as I was going through some online
> post at expert exchange where someone asked that can we use TSQL in
> firebird, then the answer that not fully but upto some
On 2018-04-18 06:14, 'Live.com Email' emendez...@nc.rr.com
[firebird-support] wrote:
> Vishal,
>
> The word “T-SQL” usually means transact SQL and that relates
> mostly to SQL Server. So if you search on TSQL you will get lots of
> hits pertaining to SQL Server. I’ve been working with FIREBIRD
On 2018-04-18 08:57, Vishal Tiwari vishuals...@yahoo.co.in
[firebird-support] wrote:
> Hi Edward Mendez,
>
> I totally agree with you that this Firebird group has also helped me
> immensely, in my critical situations.
>
> Thank you so much for the replay and suggestions. I would go through
>
On 2-4-2018 14:11, 'Joje' j...@codework-solutions.com [firebird-support]
wrote:
> I have issue where auto-increment of ID column is generating older ID’s
> that is already used in table.
>
> Currently, my transaction table has around 16 million rows and *ID of
> last inserted row is
On 29-3-2018 15:32, atuncce...@duzen.com.tr [firebird-support] wrote:
> What might be causing this, any ideas?
>
> Server: Firebird 64bit classic on Ubuntu Linux (2.5.4.26856)
The error indicates you're using 2.5.6. You might to check if upgrading
to 2.5.8 fixes the problems. I see several
On 29-3-2018 15:50, dco...@sympatico.ca [firebird-support] wrote:
> We have set up a FB 2.5 on a Linux server. We can access it locally from
> the server, but when we try to access it from any other computer on our
> local network (from which we can successfully ping the server), we get:
>
>
>
On 27-3-2018 12:51, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] wrote:
> 27.03.2018 12:49, Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
> wrote:
>> Dimitry, it would be more helpful if you explicitly pointed out the
>> problem instead of giving vague h
On 27-3-2018 11:29, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] wrote:
> 27.03.2018 9:14, rgilland1...@gmail.com [firebird-support] wrote:
>> Does anyone know why?
>
> Because your old formatting violated rules, described in comments for
> this parameter.
>
>
Dimitry, it
On 27-3-2018 12:41, rgilland1...@gmail.com [firebird-support] wrote:
> That doesnt answer the question
> The examples dont make sense in windows whom have spaces in the directory
> string
The problem is that the setting isn't "UdfAccess = Restrict UDF ", but "UdfAccess = Restrict "
The
On 26-3-2018 14:59, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] wrote:
> On 26-3-2018 14:29, liviuslivius liviusliv...@poczta.onet.pl
> [firebird-support] wrote:
>> My firebird.conf settings are:
>> Auth_Server = Srp
>> AuthClient = Srp, Win_Sspi, Legacy_Au
On 23-3-2018 18:26, shg_siste...@yahoo.com.ar [firebird-support] wrote:
> Hello! is there any trick to select a fixed number of rows? I mean, no
> matter if I have 2 rows which match the select, I need to always return
> 10 rows. Of course the last 8 would be all null in this example...
>
> I
On 20-3-2018 16:58, eric.gueguin...@gmail.com [firebird-support] wrote:
> I have the database before backup/restore
>
> I have an error with gfix on validating
>
> Summary of validation errors
> Number of index page errors: 3
> Number of database page warnings: 1
>
> IBE: Validation completed.
On 2018-03-20 15:34, Alexander Tabakov a.taba...@eklektica.com
[firebird-support] wrote:
> Hi All,
>
> I have found strange behaviour concerning trailing spaces - following
> strings are equal:
>
> 'ABC ' = 'ABC'
>
> You can try the following query:
>
> _select_
> _ case when 'ABC ' =
On 2018-03-19 15:46, titixi eric.gueguin...@gmail.com [firebird-support]
wrote:
> Hello,
>
> I want to post bug reports on your group.
> When I can do it ?
Bugs can be reported on the tracker: http://tracker.firebirdsql.org/
Please make sure to provide all relevant information to reproduce the
On 19-3-2018 07:51, Omacht András aoma...@mve.hu [firebird-support] wrote:
> Hi Hamis,
>
>
>
> merge is your friend:
>
> https://firebirdsql.org/refdocs/langrefupd21-merge.html
>
>
>
> In FB 2.5 series only insert and update is supported.
What do you mean with this sentence?
--
Mark
On 17-3-2018 18:07, 'Walter R. Ojeda Valiente'
sistemas2000profesio...@gmail.com [firebird-support] wrote:
> Sorry, but I don't understand. The script file is a plain text file. I
> had never used UTF8, I always use ISO8859_1
'plain' text files are just bytes that only get meaning in the
On 17-3-2018 16:21, 'Walter R. Ojeda Valiente'
sistemas2000profesio...@gmail.com [firebird-support] wrote:
>
>
> Hello Mark
>
> Thank you for your answer.
>
> I had tried with ISO8859_1 (which is the character set I always use) and
> with WIN1252 and the same (bad) results happens.
>
>
On 17-3-2018 14:12, 'Walter R. Ojeda Valiente'
sistemas2000profesio...@gmail.com [firebird-support] wrote:
> I am using Firebird 2.5..8 in Windows 7.
>
> I have a script file which contains the lines for create a database and
> theirs domains, tables, triggers, and so on.
>
> The problem is in
On 13-3-2018 02:12, ho...@agencybusys.com [firebird-support] wrote:
> Thank you, Mark, for such a complete and clear answer. You are a big
> help to me. What you said agrees and helps me understand what I have
> read. What I was concerned about was my Execute Blocks were too big, and
> had to
On 2018-03-12 18:08, ho...@agencybusys.com [firebird-support] wrote:
> I didn't see a way to edit the previous post, so sorry for this
> afterthought.
>
> My concert are:
>
> 1. Since the EBs are executed on the Server, will a transaction
> created in Delphi have any benefit for controlling the
On 2018-03-09 06:33, hugo.lar...@yahoo.com [firebird-support] wrote:
> I have a column char(2) where two ASCII values stored. For example
> 0011, 0001 are stored as (3,1).
> When I do a select I dont get any result because the result is not
> alphanumeric. 3 is ETX and 1 is NUL.
> I can
On 3-3-2018 17:43, setysvar setys...@gmail.com [firebird-support] wrote:
> The execute blocks had similar similar content to:
>
> for select mt.PK
> from tt
> join mt on
> where mt.integerfield = 1 into :PK do
> begin
> suspend;
> update
> set field1 = 'K', field2 = '-'
>
On 3-3-2018 13:16, 'livius' liviusliv...@poczta.onet.pl
[firebird-support] wrote:
> thank you very much for this guide.
> Where should i post info if i heve finded some issues in text? Here?
That is what the firebird-docs mailing list and
http://tracker.firebirdsql.org/browse/DOC is for.
> And
On 28-2-2018 08:46, 'Martijn Tonies (Upscene Productions)'
m.ton...@upscene.com [firebird-support] wrote:
>> On 23-2-2018 11:58, 'Martijn Tonies (Upscene Productions)'
>> m.ton...@upscene.com [firebird-support] wrote:
>>> I wonder, how can applications use this feature
>>>
On 27-2-2018 04:42, hugo.lar...@yahoo.com [firebird-support] wrote:
> Does null values take up disk space?
>
> If I have a table with 4 VARCHAR columns and I add 4 more does the table
> need double space even if the new columns are null?
I recently answered this question on
On 27-2-2018 03:17, ho...@agencybusys.com [firebird-support] wrote:
> Firebird 2.14, Delphi 2007, Multi-User App, IBDac components.
Why are you using 2.1.4? Version 2.1.4 has known security
vulnerabilities (some of which are fixed in newer 2.1.x versions, some
of which require you to upgrade
On 24-2-2018 08:56, Kjell Rilbe kjell.ri...@marknadsinformation.se
[firebird-support] wrote:
> New Windows 2016 server with Firebird 3 SuperServer x64 on port 3050.
>
> I'm trying to connect to this server from two legacy tools: Sinática
> Monitor and FlameRobin. I can successfully connect with
On 24-2-2018 11:40, antoedinchar...@gmail.com [firebird-support] wrote:
> I am having a doubt that if Foreign Key reduces Query Performance Or not.
>
> My Environment is
>
> FirebirdCS2.6 :-
>
> Item Table :- 10 Records, PK - Itemcode Varchar(5);
>
> BillDetail Table :- 10 Million Records (FK
On 23-2-2018 11:58, 'Martijn Tonies (Upscene Productions)'
m.ton...@upscene.com [firebird-support] wrote:
> I wonder, how can applications use this feature
> https://www.firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-dml-planoutput.html
What do you mean? How to parse it, or
On 21-2-2018 12:29, marco andreolli dra...@gmail.com [firebird-support]
wrote:
> Recently I have found the error /arithmetic exception, numeric overflow,
> or string truncation/
> /string right truncation
> At trigger 'X'
> /
> on different trigger or stored procedure.
> The strange thing is
On 15-2-2018 14:38, liviuslivius liviusliv...@poczta.onet.pl
[firebird-support] wrote:
> Did you know if there is some formating which can be included in report
> submited to Firebird bug tracker? Some bb-code or something like that?
We are using a very old version of Jira, and it has no such
On 2018-02-14 18:59, Omacht András aoma...@mve.hu [firebird-support]
wrote:
> Hi!
>
> Select gen_id(generator_name, 1)) as new_id from rdb$database
You should not do this with the generator of an identity column. The
system sequence to back the identity column is an implementation detail,
and
On 2018-02-14 18:32, Elton Fadel galdari...@yahoo.com.br
[firebird-support] wrote:
> I don't know why identity is better then the old method, but if we
> can't have access to the next number, this can be useless in some
> cases.
> How to get it like we did on FB 2.5 with a procedure to get the
Your problem has nothing to do with CTEs, you are combining implicit
(SQL-89) joins and explicit (SQL-92) joins, and referencing the
implicitly joined table from the explicitly joined tables. The rules for
these have changed in Firebird 3 to be compliant with the SQL
specification and to avoid
On 31-1-2018 16:07, Chuck Belanger phytot...@lanset.com
[firebird-support] wrote:
> Hello:
>
> In a stored procedure I am trying to concat two blob TEXT fields. One
> typically is text with RTF formating code about 1-30k long and the other
> may be simple text about 1-4 k long.
>
> According to
On 30-1-2018 12:24, jonatan.laurit...@yahoo.dk [firebird-support] wrote:
> For DB upgrade (from 1.5 to 3.0) I need to define custom internal
> function like this:
>
> create or alter function F_ABS (
> VAR_1 double precision)
> returns integer
> AS
> declare variable result double
On 31-1-2018 10:09, daniel.acherm...@logismos.com [firebird-support] wrote:
> I have a few questions concerning authentication and firebird 3.0:
>
> If I want to use windows trusted authentication I have to configure
> "AuthServer" and "AuthClient" with Win_Sspi? I am a bit confused to
>
301 - 400 of 804 matches
Mail list logo
