On 11-8-2018 12:33, 'River~~' river14ap...@gmail.com [firebird-support]
wrote:
> I suggested wget as it has options to cope with that issue. I recommend
> these:
[..]
> The advantage of taking a precautionary backup is that there is
> (probably!) no need to hurry. Take it slow and you won't
On 11-8-2018 10:02, 'River~~' river14ap...@gmail.com [firebird-support]
wrote:
> How much does that archive matter?
It can be helpful to look up an old discussion or solution. I
occasionally do that if I recall something was discussed before but I
can't recall the solution.
In the case that Ya
On 10-8-2018 21:10, blackfalconsoftw...@outlook.com [firebird-support]
wrote:
Interestingly, the message by Doug you are replying to has yet to show
up in my mailbox. I wonder if it ever will.
> I am not sure what you mean by a non-web forum unless you are talking
> about the older bulletin bo
On 10-8-2018 18:15, blackfalconsoftw...@outlook.com [firebird-support]
wrote:
> Do you know how the data is stored in the Yahoo mailing list? If not,
> could you contact the administrator to find out?
In my experience, it is pretty hard to contact Yahoo for simple
problems, let alone for ques
On 10-8-2018 18:32, blackfalconsoftw...@outlook.com [firebird-support]
wrote:
> Out of curiosity, I found the following two links that may help in your
> future decisions about changing from Yahoo Groups to another platform...
>
> 1...
> This link demonstrates that others have been having a lot
On 9-8-2018 17:42, DougC d...@moosemail.net [firebird-support] wrote:
>
>
> In light of the current problem of duplicate messages being sent out,
> I'd like to bring up the idea of changing platforms from the Yahoo
> Groups platform. Many other mailing lists I receive used to use Yahoo
> Group
On 8/9/2018 9:29 PM, Helen Borrie hele...@iinet.net.au
[firebird-support] wrote:
> I've been seeing the same thing in this and other Yahoo lists.
> Also, as list admin, some other behaviour, such as getting a 404 error
> when I click through the supplied link to a post that requires
> moderation.
On 8/9/2018 1:41 PM, Tomasz Tyrakowski t.tyrakow...@sol-system.pl
[firebird-support] wrote:
> I know it's off-topic, but does anyone else experience receiving
> multiple copies of some posts on this list, or is it just me?
> Sometimes I have 2, 3 or 4 identical copies in my inbox (like Hugo's
> f
On 8/9/2018 2:06 PM, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] wrote:
> On 8/9/2018 1:41 PM, Tomasz Tyrakowski t.tyrakow...@sol-system.pl
> [firebird-support] wrote:
>
>> I know it's off-topic, but does anyone else experience receiving
>> multiple copies
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
> us
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 he
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 bas
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 su
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 set
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
https://www.firebirdsql.org/file/documentati
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) CHARACT
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 t
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 local_timesta
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 differen
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 is
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,
> yo
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] wrote:
&g
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 sor
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 stran
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 d
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 selec
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
"firebird
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 d
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
> optimi
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 had
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 b
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 d
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 in
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 s
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 supp
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 statme
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 to
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 usi
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 reclaime
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 develo
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 worke
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 w
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 ha
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 d
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, alth
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 zero
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 cons
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, al
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 evict
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 b
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 yes
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 can'
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;
Interestingly
On 24-4-2018 01:54, Robert Martin nz...@live.com [firebird-support] wrote:
> In past I have used Embedded to make apps that required no FB (2)
> install and could simply be copied onto machines. I need to do this for
> a client running FB 3. I have scanned the notes and find 'A special
> “embe
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 flamero
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 i
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 provide
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
> ex
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 ext
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 si
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
> the
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 16,594,027*
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 fixes
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 woul
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 default
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_Auth
&
On 26-3-2018 14:29, liviuslivius liviusliv...@poczta.onet.pl
[firebird-support] wrote:
> I see that i need only to put win_sspi as plugin but it does not work
> either. I have restarted FB server after change. I also have created mapping
>
> CREATE GLOBAL MAPPING TRUSTED_AUTH USING PLUGIN WIN_S
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 ho
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 ' = 'AB
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 Rotte
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 encodin
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.
>
> Neith
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 be
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 get
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 = '-'
> where
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
>>> https://www.firebirdsql.
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 dba.stackexchange.com
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 to
301 - 400 of 857 matches
Mail list logo