Re: [firebird-support] Preparing for upgrade from 1.56 to 3 or 4

On 19.12.2018 at 17:33, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > Although I haven't read it myself, consider buying "Migration Guide to > Firebird 3" by Carlos Cantu, see > https://www.firebirdnews.org/migration-guide-to-firebird-3/ Just taking the occasion of this topic

Re: [firebird-support] Does GRANT... TO PUBLIC has no more effect anymore?

On 09.11.2018 at 16:03, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > On 2018-11-09 15:19, jonatan.laurit...@yahoo.dk [firebird-support] > wrote: >> I used to execute GRANT... TO PUBLIC for every new database object I >> had created in the past, but for some time (I can not tell

Re: [firebird-support] Working with SQL (might be using loop)

On 04.10.2018 at 10:34, Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] wrote: > Hi, > I am trying to get below stuff using SQL only. > 1. If I have any statement like "World is good enough to enjoy..." then in I > need to get SQL out put as"WorlD IS GooD EnougH TO EnjoY..." that is

Re: [firebird-support] Prevent overlaping dates in concurent environment

On 12.09.2018 at 14:40, Omacht András aoma...@mve.hu [firebird-support] wrote: > [...] >while (curr_date <= new.date_to) do > > begin > >insert into reserved_date (res_date) values (:curr_date); > >curr_date = dateadd(1 day to curr_date); > > end > > end On a

Re: [firebird-support] Prevent overlaping dates in concurent environment

On 12.09.2018 at 15:04, Svein Erling Tysvær setys...@gmail.com [firebird-support] wrote: > Why wouldn't my suggestion work, Tomasz? When Karol inserts his first row > into his main table it will contain DATE_FROM 2018-09-10 and DATE_TO > 2018-09-20 and the trigger would insert 11 rows (one for

Re: [firebird-support] Prevent overlaping dates in concurent environment

On 12.09.2018 at 14:40, Omacht András aoma...@mve.hu [firebird-support] wrote: > Tested on 2.5.8, dialect 1: > > > > CREATE TABLE RESERVED_DATE ( > > RES_DATE DATE NOT NULL > > ); > > ALTER TABLE RESERVED_DATE ADD CONSTRAINT RESERVED_DATE_PK PRIMARY KEY > (RES_DATE); > > > >

Re: [firebird-support] Prevent overlaping dates in concurent environment

On 12.09.2018 at 13:29, Omacht András aoma...@mve.hu [firebird-support] wrote: > Create a (reserved_dates) table with date field, and make that field unique.. > When a user inserts a date into the reservation table a trigger immadiate > inserts this date to the reserved_dates table too. Then

Re: [firebird-support] Cannot create new database: "Can not access lock files directory /tmp/firebird/"

> So, try what the rest of the error message suggests and do: Sorry, didn't read carefully enough. What I took as a part of the error message was actually what Paul Beach was suggesting as a fix (so I hereby give due credit to him). So I just gave you an example of what Paul described. Tomasz

Re: [firebird-support] Cannot create new database: "Can not access lock files directory /tmp/firebird/"

On 23.08.2018 at 17:53, 'Paul Beach' pbe...@mail.ibphoenix.com [firebird-support] wrote: > > < command followed by the path and filename, hitting Enter and then typing in > my username and password (the only user is sysdba and I did change the > password) I get the following error message: >

[firebird-support] Multiple copies of the same post

Hi, 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 from yesterday - 2 copies). They seem identical except for their X-UIDL, but AFAIK UIDLs are

Re: [firebird-support] Multiple copies of the same post

On 09.08.2018 at 14:28, James Woodard woody-...@gt.rr.com [firebird-support] wrote: > I've been getting the same thing. It's not all posts but a lot of them > get duplicated. I've just discovered I've been getting duplicates from one more list (IBObjects), which is also hosted on yahoogroups.

Re: [firebird-support] How to store a string in Firebird which includes #0's in it?

On 08.08.2018 o 11:49, 'River~~' river14ap...@gmail.com [firebird-support] wrote: > [...] > So to go back to the original point I disputed, I personally intend to go > on referring to the byte terminating a C string as being x00 not as the > more pedantically correct chr(0). > [...] To be

Re: [firebird-support] install.sh not working in Ubuntu 18.04?

On 19.07.2018 o 01:31, erickdeoliveiral...@gmail.com [firebird-support] wrote: > Hello. I want to test Firebird in Ubuntu 18.04. > I Downloaded FirebirdCS-2.5.8.27089-0.amd64.tar.gz > https://github.com/FirebirdSQL/firebird/releases/download/R2_5_8/FirebirdCS-2.5.8.27089-0.amd64.tar.gz > I

Re: [firebird-support] Segmentation fault while trying to restore Firebird 2.1 database on Linux

On 04.07.2018 at 10:26, jonatan.laurit...@yahoo.dk [firebird-support] wrote: > I am trying to restore Firebird 2.1 database on Linux but I am receiving > error message: > > > Command '/opt/firebird02/bin/gbak –c –v –p 4096 –user SYSDBA –pass > masterkey /backup/BIG_DATABASE

Re: [firebird-support] How can I correctly write this WHERE

On 20.06.2018 o 13:41, Venus Software Operations venussof...@gmail.com [firebird-support] wrote: > Hi Thomasz > > You have understood me correctly, that is what I want to do and your > suggestion > works thanks. > > Please see my reply to SET as the query has slowed down to 10 minutes with >

Re: [firebird-support] How can I correctly write this WHERE

Hi, As I understand it, what you meant is: where ( TRIM(vwTA.cNameCity01) = 'Balance Sheet' and CAST(tSI.tDt AS DATE) < '2018-04-01' ) or ( TRIM(vwTA.cNameCity01) is distinct from 'Balance Sheet' and CAST(tSI.tDt AS DATE) BETWEEN '2018-03-01' AND '2018-03-31' ) If vwTA.cNameCity01 is sure to

Re: [firebird-support] Strange behaviour with char '#'

On 15.12.2017 at 09:17, Köditz, Martin martin.koed...@it-syn.de [firebird-support] wrote: > I stumbled upon the following problem: > I have a field of type varchar(7). When inserting the string '#ee' the > field value remains zero. > > Does the character '#' have a special role? No it

Re: [firebird-support] Issue with GBAK and upgrading old DB (1.5 -> 3.x)

On 15.11.2017 at 13:48, stihpos...@yahoo.com [firebird-support] wrote: > When I try to restore, it asks for next volume... so, I suppose backup > failed. (When looking gbak with -v it works fine and finally gets to certain > table, says something like: > gbak: 16 records written >

Re: [firebird-support] Creating a conditional "order by" statement

On 23.10.2017 at 14:37, j...@acousticdesign.co.uk [firebird-support] wrote: > I have a stored procedure along the lines of > SELECT ID, Amount1, Amount2 .. > FROM Table1. > UNION > SELECT ID, Amount1, Amount2... > FROM Table2 > ORDER BY 1 > Is it possible to construct a conditional

Re: [firebird-support] "Invalid Cursor State"

On 19.10.2017 at 16:46, Jorge Andres Brugger jorge.brug...@gmail.com [firebird-support] wrote: > I´m not sure which was the solution that finally worked, as I´ve made > several changes, mostly on the execution order in my program (windows exe, > not FB). > I suppose there is some issues with ODBC

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

On 17.08.2017 at 07:59, anshuman.na...@airtelmail.in [firebird-support] wrote: > > I would like some help to identify as to why and from where the following > query is getting executed on its own at particular intervals. We have Thick > Client Application written using Delphi and Firebird

Re: [firebird-support] permissions nbackup

> Absolutely right. My point was having root should is not crucial. It should read: having root is not crucial Typing and having dinner at the same time is not healthy for your stomach and for your readers. Apologies. Tomasz

Re: [firebird-support] permissions nbackup

On 14.08.2017 at 18:03, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > If you have sysdba permissions, you can do nbackup via services. > Security database is small enough for gbak too. Absolutely right. My point was having root should is not crucial. regards Tomasz

Re: [firebird-support] permissions nbackup

On 14.08.2017 at 17:41, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 14.08.2017 17:21, Nick Upson n...@telensa.com [firebird-support] wrote: >> if I do nbackup . it fails, telling me I cannot access the security2.fdb >> (as a normal >> user) > > Why can't you use su

Re: [firebird-support] permissions nbackup

On 14.08.2017 at 15:51, Nick Upson n...@telensa.com [firebird-support] wrote: > I'm looking at using nbackup but the file permissions on security2.fdb mean > only firebird or root can do so, is that the way it is supposed to be? Definitely. You wouldn't like any third party to access the password

Re: [firebird-support] Changing collation

On 29.06.2017 at 19:15, Tomasz Tyrakowski t.tyrakow...@sol-system.pl [firebird-support] wrote: > On 28.06.2017 at 22:58, Ann Harrison aharri...@ibphoenix.com > [firebird-support] wrote: > [...] > Or is 3 strictly bound > to PXW_PLK and always means PXW_PLK, regardless of th

Re: [firebird-support] Changing collation

On 28.06.2017 at 22:58, Ann Harrison aharri...@ibphoenix.com [firebird-support] wrote: > Not if you have indexes, a declared primary key, or a declared unique > constraint. The index keys are a transformation of the value into a format > that produces the desired ordering through binary

Re: [firebird-support] Changing collation

On 27.06.2017 at 19:39, Tomasz Tyrakowski t.tyrakow...@sol-system.pl [firebird-support] wrote: > Is it possible to change the collation of a varchar column in place > (without making a temporary column, copying data, dropping the original > column, making it anew and copying the data bac

[firebird-support] Changing collation

Hi, Is it possible to change the collation of a varchar column in place (without making a temporary column, copying data, dropping the original column, making it anew and copying the data back)? Would setting RDB$RELATION_FIELDS.RDB$COLLATION do the trick (and is it safe to do)? I've got

Re: [firebird-support] Re: UDF and server crashes on linux

On 03.05.2017 o 09:28, hv...@users.sourceforge.net [firebird-support] wrote: > ---In firebird-support@yahoogroups.com, wrote : > > Tested on FB 2.5.7 and 3.02 ubuntu_x64 14.04 (two different machines); > On windows fbx64 works ok. > > udf return integer by value. > >

Re: [firebird-support] Immediate Detection of Disconnected Clients on Classic

On 25.04.2017 o 17:03, hv...@users.sourceforge.net [firebird-support] wrote: > [...] > I don't actually think Firebird can detect client disconnection > "immediately" when there is no data exchange between the server and the > client (it would require some kind of heartbeat increasing

Re: [firebird-support] Immediate Detection of Disconnected Clients on Classic

On 24.04.2017 o 10:41, atuncce...@duzen.com.tr [firebird-support] wrote: > We have some desktop applications which are connecting to firebird, started > crashing for a while. > These applications are mostly on our wireless link connected building so > I'm suspicious about the network. >

Re: [firebird-support] Re: Which connection causes object in use - is there a way to find that out?

On 25.10.2016 o 10:20, hv...@users.sourceforge.net [firebird-support] wrote: >> From time to time, when I try to alter a stored procedure in a >> production database, I get "object in use" error. > Run DDL statement in wait transaction. Better to set some timeout to not > wait too much, but

[firebird-support] Which connection causes object in use - is there a way to find that out?

Hi, From time to time, when I try to alter a stored procedure in a production database, I get "object in use" error. I was wandering, is there a way to find the connections (users) that prevent a particular procedure from being altered? Querying MON$STATEMENTS is a no-go, no statement

Re: [firebird-support] Character sets and collations of columns

On 26.08.2016 o 14:35, robert rottermann rob...@redcor.ch [firebird-support] wrote: > I have no idea at on how to fix it "correctly", but would it not be an > idea just to dump the tables with weird character into a text file, and > search replace them. > > The wrong chars are probably uniformly

[firebird-support] Character sets and collations of columns

Hi, One of the legacy databases I happen to maintain has character sets and collations messed up. As far as I know, the database was created with default character set "NONE" instead of "WIN1250", which should have been set back then (and it's over 10 years old). Then, some columns have been

Re: [firebird-support] SQL Error Code -104: What is wrong with this rather simply SQL?

On 06.04.2016 o 22:03, 'stwizard' stwiz...@att.net [firebird-support] wrote: > SELECT DISTINCT P.AREA_CODE, P.PHONE_NO, > >(SELECT COUNT(*) > > FROM PHONE P2 > > WHERE P2.PHONE_ID = P.PHONE_ID) AS CNT > >FROM PHONE P > > WHERE P.AREA_CODE IS NOT NULL > > GROUP BY

[firebird-support] Gbaked and restored database larger than the original?

Hi, Just for my cursiosity and for a better understanding of Firebird: what can be a possible reason for a gbaked and restored (to a different file) database being _larger_ than the original one? I've got a db of size 104521728 bytes. I do gbak -B -T database.fdb database.gbk, then gbak -C

Re: [firebird-support] Re: Gbaked and restored database larger than the original?

W dniu 2015-07-08 o 14:50, Dmitry Yemanov dim...@users.sourceforge.net [firebird-support] wrote: 08.07.2015 15:18, Mark Rotteveel wrote: Another reason could be restoring with a different page size than the original database. Or some tables were altered to a longer record format after

Re: [firebird-support] Gbaked and restored database larger than the original?

W dniu 2015-07-08 o 14:18, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: Another reason could be restoring with a different page size than the original database. Both databases have 8k pages. Tomasz -- __--==--__ __--== Tomasz Tyrakowski

Re: [firebird-support] Gbaked and restored database larger than the original?

On 2015-07-08 o 14:14, Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support] wrote: Take a look here: http://www.firebirdfaq.org/faq361/ Yes, I've come across this on another occasion, but it doesn't seem to apply to my case (I didn't switch to a different version of

Re: [firebird-support] Firebird 2.5.x slow queries problem

On 2015-05-20 o 10:51, Sylvain Mazaudier smaza...@yahoo.fr [firebird-support] wrote: [...] Query select 1: SELECT ROW1 FROM TEST; Query select 2: SELECT ROW2 FROM TEST; Résults in IBExpert monitor : Query select 1:1.5 sec Query select 2:5.3 sec [...] We don't understand why are the

Re: [firebird-support] Query to update multiple records in same Table

On 2015-05-19 o 13:59, millsjac...@yahoo.com [firebird-support] wrote: Is there a single query that allows multiple row updates from multiple row selects (e.g. like Copy paste) i.e. Select row 1 column 7 update row 101 column 7 Select row 2 column 7 update row 102 column 7

Re: [firebird-support] working days between two dates

If you mean week days only, probably you can come up with a clever stored procedure or UDF (shouldn't be that hard), but if you have to take various bank holidays into account, most of which are state-specific or even mobile (e.g. easter), a general, elegant solution doesn't come to mind.