Re: [firebird-support] Re: New Firebird project/OpenEMR/Wind8.1/asgalib20/#201902a

2019-02-19 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
19.02.2019 20:03, blackfalconsoftw...@outlook.com [firebird-support] wrote: > Mark is correct in his previous reply as I went through some of the > documentation for the > Open EMR System.  The OpenEMR system makes use of the MySQL database engine, > not Firebird. I guess the author wanted

Re: [firebird-support] Question about delay in fetch operation

2019-01-28 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
28.01.2019 18:10, Rudi Feijó rudi.fe...@multidadosti.com.br [firebird-support] wrote: > Tried downloading it now but couldnt find the embedded version for firebird 3 Read Release Notes. Embedded mode is used automatically for local connections. -- WBR, SD.

Re: [firebird-support] Connection lost after long inactive time

2019-01-28 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
28.01.2019 18:15, Stefan Heymann li...@stefanheymann.de [firebird-support] wrote: > Does anybody have an idea what is going on here? Yes. Router (CISCO most likely) or firewall (Comodo) breaks inactive TCP connection. > DummyPacketInterval = 0 (but this should be irrelevant for this type >

Re: [firebird-support] Re: How to "shape" indexes to avoid index depth > 3

2019-01-29 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
29.01.2019 21:13, 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] wrote: > the multi-segment indexes are to optimize commonly used queries. In this case you can consider removing one or two fields from the index and see how much selectivity it lose and how much performance would

Re: [firebird-support] Firebird 2.5 - Data committed to database is not found after a while

2019-01-25 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
25.01.2019 17:30, duque.herna...@yahoo.com [firebird-support] wrote: > Have anyone had this situation? > > Is it posible that it is related to a Windows version? If your database file has GDB extension, Windows System Restore (including automatic one after some minor reboot errors) can

Re: [firebird-support] Re: installing fb 1.5 in Mac Mojave

2019-01-24 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
24.01.2019 15:01, wang...@yahoo.com [firebird-support] wrote: > if do a port scan, 3050 is opened, any idea why> this is a classic fb 1.5, > maybe not started? Is (x)inetd started? Does netstat confirm that port 3050 is listened? -- WBR, SD.

Re: [firebird-support] Re: installing fb 1.5 in Mac Mojave

2019-01-24 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
24.01.2019 15:44, wang...@yahoo.com [firebird-support] wrote: > if i do a telnet localhost 3050, see the 'connected to localhost, escape > char...' > then 'connection closed by foreign host' > if I do a isql connection: > > connect "localhost:/home/sample.fdb', > got error unable to complete

Re: [firebird-support] What to install on a client computer

2019-01-31 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
31.01.2019 14:16, Ivan Cenov i...@okto7.com [firebird-support] wrote: > What is needed to install on a client computer so as an application to > access Firebird server 2.0.3 > that is  installed on another computer. is there some client > distributable package? Run installer and choose

Re: [firebird-support] Question about delay in fetch operation

2019-02-04 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
04.02.2019 13:09, Rudi Feijó rudi.fe...@multidadosti.com.br [firebird-support] wrote: > Can I ask you if there is any good tutorial so one could start learning the > ins and outs > about optimizing queries and plans? I’ve sifted through the available > documentation a few > times but they are

Re: [firebird-support] user manager?

2019-04-12 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
12.04.2019 7:27, 'Check_Mail' check_m...@satron.de [firebird-support] wrote: > how can I change both sysdba-passwords? The one from srp and the other from > legacy auth? "ALTER USER" clause has "USING" part which set user manager to be used. -- WBR, SD.

Re: [firebird-support] user manager?

2019-04-12 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
12.04.2019 15:50, 'Check_Mail' check_m...@satron.de [firebird-support] wrote: > ..if I use the fbclient.dll, I can connect with every password, why? Because you use embedded mode and password isn't checked. -- WBR, SD.

Re: [firebird-support] user manager?

2019-04-16 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
15.04.2019 12:18, 'Check_Mail' check_m...@satron.de [firebird-support] wrote: > I'm using not the embedded mode, or ibexpert uses it? If I configure "local" > and use the > fbclient.dll, every password works. If you read Release Notes for Firebird 3.0 you'll find out that "local" there is

Re: [firebird-support] Granting Create Database via client api

2019-04-18 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
18.04.2019 7:03, rgilland1...@gmail.com [firebird-support] wrote: > In order to create a database in Firebird 3 by a non SYSDBA user, a > connection must be > made and th e CREATE DATABASE privilege must be granted. But on a clean > firebird system > there is no database to connect to.

Re: [firebird-support] Problem with Firebird embedded on Windows: CHARACTER SET UTF8 is not defined

2019-04-11 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
11.04.2019 18:02, Anil anil.muja...@gmail.com [firebird-support] wrote: > It seems that the DB creation on Windows is resulting in an invalid DB file. Yes. Because you didn't put all necessary files into proper directory structure, Firebird engine failed to load fbintl module. Database file

Re: [firebird-support] Query that was very fast under the oldest 2.5 versions are very slow under 2.5.8 or 2.5.9

2019-05-24 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
24.05.2019 21:25, 'Dany Schaer' danysch...@yahoo.com [firebird-support] wrote: > What can be the problem with this query undewr 2.5.8? "IN" predicate is in trouble. Get rid of it if possible. -- WBR, SD.

Re: [firebird-support] Firebird upgrade advise

2019-06-04 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
04.06.2019 0:00, SP Ooi sp.ooi@gmail.com [firebird-support] wrote: > May I know what our upgrade path should be to bring our firebird databases to > the > latest version? 1. Install a new server with new Firebird version. 2. Create a new database from script. 3. Pump data from old database.

Re: ODP: [firebird-support] Query that was very fast under the oldest 2.5 versions are very slow under 2.5.8 or 2.5.9

2019-05-28 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
28.05.2019 22:36, danysch...@yahoo.com [firebird-support] wrote: > I don't think this problem is about parameters, there is something that > changed a lot > between 2.5.0 and 2.5.8 that is making this queries to go that slow. http://tracker.firebirdsql.org/browse/CORE-4690 -- WBR, SD.

Re: [firebird-support] Re: Query optimizer is not using the useful indexes.

2019-05-31 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
31.05.2019 13:18, danysch...@yahoo.com [firebird-support] wrote: > That (and ONLY THAT) is making my query to need 24 minutes insted of 1 minute. Do you understand that DISTINCT inside of IN is meaningless? -- WBR, SD.

Re: ODP: [firebird-support] Query that was very fast under the oldest 2.5 versions are very slow under 2.5.8 or 2.5.9

2019-05-29 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
29.05.2019 13:37, danysch...@yahoo.com [firebird-support] wrote: > The very important diference is the plan. 2.5.8  is not using MOVI_FECH > index, so it must > read more than one millon records to analize ("MOVI"."FECH" between > '20190301' and > '20190412'). Remove "DISTINCT" from

Re: [firebird-support] invalid request BLR at offset 27, on restore FB 3 database to 2.5

2019-06-12 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
12.06.2019 12:53, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > I've extracted db into a script You must have a "master script" instead of extracting metadata from live database. Ask the database author for it. -- WBR, SD.

Re: [firebird-support] invalid request BLR at offset 27, on restore FB 3 database to 2.5

2019-06-12 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
12.06.2019 11:38, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: >  Invalid token. >      invalid request BLR at offset 27. >      BLR syntax error: expected valid BLR code at offset 28, encou ntered > 210. This database obviously used some new features of Firebird 3 in stored

Re: [firebird-support] invalid request BLR at offset 27, on restore FB 3 database to 2.5

2019-06-12 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
12.06.2019 12:20, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > what other way I could use? Create database from scratch, pump data. -- WBR, SD.

Re: [firebird-support] Help interpret plan

2019-06-12 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
12.06.2019 12:37, Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support] wrote: > Would this mean that the table F would be subject to a full natural scan > for each record of the preceding joins? Yes. -- WBR, SD.

Re: [firebird-support] invalid request BLR at offset 27, on restore FB 3 database to 2.5

2019-06-12 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
12.06.2019 12:26, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > based application is written for 2.5,just some test are done for Fb 3,in case > something > goes wrong, must go back to 2.5 until a fix is done,so that restore is need. That's a wrong way of migration. Better set

Re: [firebird-support] rw vs ro connections

2019-06-19 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
19.06.2019 17:51, Nick Upson n...@telensa.com [firebird-support] wrote: > Should I expect any performance gain if I change my rw connections to ro, > given that the > query is always of the form "select * from ..." At first, there is no such things as "ro connection". At second, ro

Re: [firebird-support] index vs page size

2019-06-20 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
20.06.2019 17:10, Nick Upson n...@telensa.com [firebird-support] wrote: > Can anyone suggest other actions I could take. Increase page cache size to ensure that this index fits into it. Re-consider size of field(s) in this index. -- WBR, SD.

Re: [firebird-support] query Integer overflow

2019-06-22 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
22.06.2019 21:47, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > I'm facing with this error on FB 2.5.8(latest stable version)/ W10 x64 My advice is "never perform calculations (especially multiplication and division) in SQL". Your expression has result of type NUMERIC(18,14)

Re: [firebird-support] query Integer overflow

2019-06-23 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
23.06.2019 5:41, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > The calculation is on a SP code and I need it there Then get rid of IIF and decide at which moment you need round intermediate values. Then cast the values to types with smaller precision. -- WBR, SD.

Re: [firebird-support] Open database connection fails

2019-06-17 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
17.06.2019 11:48, gregorkob...@yahoo.com [firebird-support] wrote: > May somebody has me a hint. https://support.microsoft.com/en-us/help/239924/how-to-disable-the-media-sensing-feature-for-tcp-ip-in-windows -- WBR, SD.

Re: [firebird-support] Connect Libreoffice Base with Firebird

2019-05-09 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
09.05.2019 13:03, Drew Jensen drewjensen.in...@gmail.com [firebird-support] wrote: > What is the reason they don't have direct connection to FB servers as an > option? > > No one stepped up to write it. It is an office packet. I personally see no point for it to support anything

Re: [firebird-support] FB 3 Database hanging in multi-user

2019-05-09 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
09.05.2019 15:52, Sukhendu Barua sb.peace...@gmail.com [firebird-support] wrote: > Please tell me how to turn on the Firebird transactions audit. In the FB > config file? Is > there a tool that does it? It is described in doc/README.trace_services and there are tools that can help you

Re: [firebird-support] FB classic 3.0.4 - cannot find tip page (165), file: tra.cpp line: 2331

2019-05-11 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
10.05.2019 17:41, Vladimir Zbodulja vladimir.zbodu...@pis.eu.com [firebird-support] wrote: > I'm not if this two issues are the same Still it is a good idea to upgrade to current snapshot 3.0.5 first of all. -- WBR, SD.

Re: [firebird-support] Understanding Firebird Security

2019-05-20 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
20.05.2019 12:19, sbai...@mutualconsultants.ltd.uk [firebird-support] wrote: > What stops me taking a copy of SecretDatabase.fdb and connecting to it on my > own Firebird > installation? You cannot do that if you 1) Have no access to the file (and server file system as whole). 2) Don't know

Re: [firebird-support] Understanding Firebird Security

2019-05-20 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
20.05.2019 12:54, sbai...@mutualconsultants.ltd.uk [firebird-support] wrote: > 2) In my testing I was able to open MyDB and view its contents *without > *knowing the > owner's password just by making it use my default security.fbd and > SYSDBA/masterkey. For this you again must have access

Re: [firebird-support] Understanding Firebird Security

2019-05-20 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
20.05.2019 12:32, sbai...@mutualconsultants.ltd.uk [firebird-support] wrote: > anyone can open any Firebird database and view the data (unless it happens to > be encrypted). Yes, and it is true for any database server. -- WBR, SD.

Re: [firebird-support] Engine12 32 64 bit question

2019-05-18 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
18.05.2019 9:32, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > It sounds like your code is attempting to use Firebird Embedded instead > of Firebird Server. Even if not, default configuration put Engine12 to the first place so it is tried before network connection. He

Re: [firebird-support] SYSDBA user

2019-04-30 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
30.04.2019 7:26, dennisktl...@yahoo.com [firebird-support] wrote: > can i remove SYSDBA user? Yes, you can. -- WBR, SD. ++ Visit

Re: [firebird-support] insert data two databases different

2019-05-07 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
07.05.2019 16:25, 'Joel Moo' joel@verticalknits.com [firebird-support] wrote: > i stopped the service of > firebird before renaming the file .fdb. If Firebird is in Classic mode stopping of service has no effect to existing connections. -- WBR, SD.

Re: [firebird-support] Re: firebird mingw

2019-05-06 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
06.05.2019 3:41, robol...@yahoo.com [firebird-support] wrote: > I decided definitely to give the package a try in mingw. Maybe I will get > lucky and > someone will agree to update that package at a future time. Nope. MinGW build is completely abandoned. Use binary installation. --

Re: [firebird-support] Read OAT value

2019-07-12 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
12.07.2019 16:14, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: > Is then a different way to read oldest active transaction from the connected > db client? isc_database_info(isc_info_oldest_active) -- WBR, SD.

Re: [firebird-support] FB 2.5.8 - Next transaction value growing too much.

2019-07-01 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
01.07.2019 18:11, duque.herna...@yahoo.com [firebird-support] wrote: > What am I doing wrong? You misunderstood documentation. Sweep does move OAT (and collect garbage as a side effect), but it has nothing to do with Next Transaction. Numbers from your gstat output tell that your

Re: [firebird-support] Offtopic: Trigger before Insert: Firebird vs. MS SQL

2019-07-08 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
08.07.2019 16:55, 'Nikolaus Kern' parzival1...@gmx.at [firebird-support] wrote: > Is it possible that this works totally different in MS SQL? Yes, it works totally different in MS SQL. Yes, only AFTER and INSTEAD OF triggers are available there. Besides, they are statement-level, not

Re: [firebird-support] Re: run firebird engine without fbguard

2019-07-15 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
15.07.2019 12:16, peshk...@mail.ru [firebird-support] wrote: > server does not contain code to daemonize itself, i.e. you will have to > perform all > required for it activity yourself. systemd does not require daemonization from services. If firebird use own listener it is enough to

Re: [firebird-support] Can't get Firbird 3.x embedded to work in Delphi 10.3 update 1?

2019-04-23 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
23.04.2019 14:11, 'Chris LeFebvre' lefebv...@comcast.net [firebird-support] wrote: > And it seems like the setup should be that the FireDAC TFDPhysFBDriverLink > should have > “Embedded” set to true (which I do) and “VendorLib” should point to > “engine12.dll” located > in the

Re: [firebird-support] Firebird 3 - gstat output about blobs

2019-04-23 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
23.04.2019 14:38, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: > records are 136628 blobs are 10021, is this mean that some blobs are null? Yes. > blob pages: 0 - what this mean? Blob is stored in the same page as other > fields? Yes. > What about levels 0, 1, 2

Re: [firebird-support] lock_timeout or isc_tpb_lock_timeout?

2019-04-16 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
15.04.2019 19:59, hamacker sirhamac...@gmail.com [firebird-support] wrote: > First question: > fdconn1.Params.Values['lock_timeout']:='180'; > or > fdconn1.Params.Values['isc_tpb_lock_timeout']:='180'; > ??? IFAIK, FireDAC can recognize both names, but value for timeout must be an integer,

Re: [firebird-support] Re: Automating Firebird maintenance on Linux

2019-04-17 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
17.04.2019 15:10, my...@techsol.org [firebird-support] wrote: > but gfix refuses to shutdown the database to single user maintenance mode if > there are any > existing connections to it. Use -force_shutdown. -- WBR, SD.

Re: [firebird-support] Automating Firebird maintenance on Linux

2019-04-16 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
15.04.2019 18:23, my...@techsol.org [firebird-support] wrote: > End users (and end user reporting applications, scripts, etc.) that connect > to this > database are often connected when I attempt to run these maintenance tasks, > so I can never > get the database to go to "offline" mode

Re: [firebird-support] Strange items in log file

2019-04-24 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
24.04.2019 11:52, respekt...@post.cz [firebird-support] wrote: > What should I do with it ??? Check you file system and disc health. There is no way for a piece of system log to sneak into firebird.log except bad storage corruption. -- WBR, SD.

Re: [firebird-support] How to trigger automatic sweep?

2019-08-13 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
13.08.2019 21:03, Gabor Boros mlngl...@bgss.hu [firebird-support] wrote: > Any other tips? Turn on transaction audit and see what happened to OIT/OAT. -- WBR, SD.

Re: [firebird-support] System requirements for the Firebird 3.0

2019-08-02 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
02.08.2019 15:35, Marcelo Guimaraes mfguimar...@gmail.com [firebird-support] wrote: > I would like to know if someone can help me with the minimum system > requirements for the > Firebird 3.0, specific for Debian distribution. Distribution, kernel and so > on. Debian has Firebird in

Re: [firebird-support] CpuAffinityMask on firebird 3.X and firebird memory leakage

2019-09-03 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
03.09.2019 12:10, 'Check_Mail' check_m...@satron.de [firebird-support] wrote: > if we use the default firebird.conf with #CpuAffinityMask = 0, does firebird > use all > cpus/cores? Or should I set it to 15 for 4 cores? I have found some > information for the > 2.5 only. For Firbird 3 CPU

Re: [firebird-support] CpuAffinityMask on firebird 3.X and firebird memory leakage

2019-09-03 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
03.09.2019 13:12, 'Check_Mail' check_m...@satron.de [firebird-support] wrote: > How can I understand this gap? The biggest probability is a memory leak in your UDFs. -- WBR, SD.

Re: [firebird-support] CpuAffinityMask on firebird 3.X and firebird memory leakage

2019-09-03 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
03.09.2019 13:53, 'Check_Mail' check_m...@satron.de [firebird-support] wrote: > but the UDFs I haven’t change in. So a leak in them (if any) has no chance to be fixed. > How can I delimit this leak? Can I debug > the memory? Developers version of Firebird writes memory leaks into file on

Re: [firebird-support] MS-Windows<-->Linux compatibility

2019-08-29 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
29.08.2019 13:06, emou...@yahoo.fr [firebird-support] wrote: > In theory, if I create a Firebird database with IBExpert under MS-Windows, is > it then > possible to use it with a Linux application (written in Lazarus), giving it > all the right > rights, ie without going through an IBExpert's

Re: [firebird-support] Error code help

2019-08-28 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
21.08.2019 16:24, Todd Pickler t...@midlandsxray.com [firebird-support] wrote: > Can anyone help with this error? > > Getting SQL error code = -206 This is a very generic error code with meaning "something is wrong". You must read the rest of the error message for details. -- WBR, SD.

Re: [firebird-support] Array datatype?

2019-08-28 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
28.08.2019 15:29, 'Check_Mail' check_m...@satron.de [firebird-support] wrote: > How can I define an array datatype and use it in some functions? No way. Forget about arrays in Firebird. -- WBR, SD.

Re: [firebird-support] Array datatype?

2019-08-28 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
28.08.2019 16:18, 'Check_Mail' check_m...@satron.de [firebird-support] wrote: > is there no way? I know the thing with the execute statement, but it is not > the best > solution. I would like to add a value, if the weekday is 1 (Monday), then I > would like to > take the variable t1 and add

Re: [firebird-support] MON$ATTACHMENT performance issue

2019-08-26 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
26.08.2019 14:36, Róbert Sisa robert.s...@dyntell.com [firebird-support] wrote: > Can anybody help me?  It looks like a FB bug... No, this is not a bug. Yes, monitoring tables are slow and locking whole server to get snapshot of its state. Don't use them unless absolutely necessary. --

Re: [firebird-support] 32 Bit and 64 Bit

2019-09-06 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
06.09.2019 15:35, 'Check_Mail' check_m...@satron.de [firebird-support] wrote: > Can I use the 64 Bit Client-Installation of Firebird for the clients or > should I take the > 32-Bit firebird installer to install the minimum client installation? Applications cannot use libraries of different

Re: [firebird-support] SELECT FIRST N BY GROUP

2019-08-07 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
07.08.2019 14:26, pg...@mccolls.co.uk [firebird-support] wrote: > Is this possible in a single SELECT query I would try WHERE ROW_NUMBER() OVER (PARTITION BY empid, ORDER BY effdate) <= 2. -- WBR, SD.

Re: [firebird-support] 3.x - Check if DB exist using alias

2019-08-05 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
05.08.2019 14:05, 'P-Soft - Fabio Codebue' f.code...@p-soft.biz [firebird-support] wrote: > Which is the best way to check if a database exist if my connection is alias > based? > > I have to try to connect and manage response? Yes, this is the only way. -- WBR, SD.

Re: [firebird-support] Help creating expression index

2019-07-17 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
17.07.2019 17:54, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > I want to create a index to improve a query like that: >     SELECT * FROM MYTABLE WHERE EXTRACT(YEAR FROM datein)=2019  AND > EXTRACT(MONTH FROM > datein)=1 Rewrite it as SELECT * FROM MYTABLE WHERE datein

Re: [firebird-support] Basic Re-Start

2019-09-28 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
28.09.2019 14:52, Clyde Eisenbeis cte...@gmail.com [firebird-support] wrote: > I don't know the answer to some questions: I recommend you to read Firebird Quick Start Guide and other documentation in doc folder. -- WBR, SD.

Re: [firebird-support] Basic Re-Start

2019-09-30 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
30.09.2019 14:27, Clyde Eisenbeis cte...@gmail.com [firebird-support] wrote: > What the the link for downloading Embedded Firebird? None. Read Firebird 3 Release Notes. -- WBR, SD.

Re: [firebird-support] FB3

2019-11-07 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
07.11.2019 22:05, mohamed hamza medh...@hotmail.com [firebird-support] wrote: > How to downgrade from firebird 3 to Firebird 2.5.8 Create a new database from script, pump data. > I  am having problem mapping numeric (x,y) field . even if y>0  the host > language map it > to an  integer.

Re: [firebird-support] Identity vs Before Insert Trigger

2019-10-31 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
31.10.2019 15:15, Daniel Miller dmil...@amfes.com [firebird-support] wrote: > My question - is this intended behavior? For "generated *by default*" it is intended behavior. Your trigger obviously emulated identity with "generated always" option. -- WBR, SD.

Re: [firebird-support] Linked Table and double precision

2019-10-30 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
30.10.2019 11:58, 'Check_Mail' check_m...@satron.de [firebird-support] wrote: > in a Report I calculate the VAT For VAT rounding you must follow your local tax laws and do not rely on computer rounding functions. -- WBR, SD.

Re: [firebird-support] Multiple FB Installations

2019-11-13 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
13.11.2019 01:14, 'Andrew Zenz' and...@aimsoftware.com.au [firebird-support] wrote: > I recently installed Firebird Client (2.5.8) and Firebird ODBC drivers > (2.0.5) on a > clients RDS server and was told I had broken a previously installed app that > appears to > use FB Embedded. > > The

Re: [firebird-support] Re: High write access on disk

2019-11-13 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
13.11.2019 12:41, Alexey Kovyazin a...@ib-aid.com [firebird-support] wrote: > we also started with Page Buffers = 25%  RAM and increased it step by step > (and still > continue to work with fine tuning). Isn't it better to use cache hit ratio to make the decision about its growth? --

Re: [firebird-support] Re: High write access on disk

2019-11-13 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
13.11.2019 11:59, kragh.tho...@yahoo.com [firebird-support] wrote: > Its not that I see high traffic to /tmp as a problem, I was just worried that > it was > becoming a bottleneck in our system. In this case you can use for it tempfs backed up with auto-expanded swap files. -- WBR,

Re: [firebird-support] Re: What are the trade-offs of CHAR vs. VARCHAR?

2019-11-13 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
13.11.2019 17:37, blackfalconsoftw...@outlook.com [firebird-support] wrote: > Your statement is suggesting a null length (until the field is updated) with > two bytes for > an actual length, which is how VARCHAR fields work in all other databases to > my > knowledge.  Otherwise, to follow the

Re: [firebird-support] What are the trade-offs of CHAR vs. VARCHAR?

2019-11-13 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
13.11.2019 15:51, blackfalconsoftw...@outlook.com [firebird-support] wrote: > However, internally, the CHAR field definition is more efficient as the > database does not > have to perform any field size calculations at the moment that data is being > updated to a > VARCHAR field. No such

Re: [firebird-support] What are the trade-offs of CHAR vs. VARCHAR?

2019-11-13 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
13.11.2019 15:07, Clyde Eisenbeis cte...@gmail.com [firebird-support] wrote: > Assume I have two fields => "stFixed CHAR(10)" and "stVar VARCHAR(8191) > CHARACTER SET > UTF8" --- what is the optimum pageSize? As big as possible for your Firebird version. -- WBR, SD.

Re: [firebird-support] Why won't Firebird restore backups from a network drive?

2019-11-13 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
13.11.2019 16:45, dco...@sympatico.ca [firebird-support] wrote: > Whether I used a mapped drive letter, or a UNC path, if I try to restore a > backup from a > network drive it fails, with a message like "Cannot open file". Don't you by chance try it using Services API or "-se" switch of

Re: [firebird-support] Re: What are the trade-offs of CHAR vs. VARCHAR?

2019-11-13 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
13.11.2019 16:09, blackfalconsoftw...@outlook.com [firebird-support] wrote: > If a VARCHAR field is defined for 1000 characters and it is stored in the > table at a 1000 > character length than there is no purpose to an actual VARCHAR field > definition. There is. I addition to 1000

Re: [firebird-support] Re: What are the trade-offs of CHAR vs. VARCHAR?

2019-11-14 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
14.11.2019 17:08, blackfalconsoftw...@outlook.com [firebird-support] wrote: > The links provided to me had the information on the IB-Experts web site... I didn't see who provided you any link, but here is right one: https://firebirdsql.org/en/reference-manuals/ At the bottom of this page

Re: [firebird-support] with wrong sql i get no exception or firebird error

2019-11-14 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
14.11.2019 15:06, 'Harald Wolf' firebir...@online.de [firebird-support] wrote: > i use the ibpp.org c++ lib. How can i get the firebird sql error in my c++ > code? This is a Firebird support list. Your question belongs to IBPP support. -- WBR, SD.

Re: [firebird-support] What are the trade-offs of CHAR vs. VARCHAR?

2019-11-14 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
14.11.2019 17:06, blackfalconsoftw...@outlook.com [firebird-support] wrote: > What do you mean I am wrong?  I have merely re-iterated how all database > engines I have > worked operate. How "all database engines operate" is irrelevant here. You are wrong in your assumption how Firebird

Re: [firebird-support] What is the optimum pageSize?

2019-11-14 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
14.11.2019 13:41, cte...@gmail.com [firebird-support] wrote: > Assume I have two fields => "stFixed CHAR(10)" and "stVar VARCHAR(8191) > CHARACTER SET > UTF8" --- what is the optimum pageSize? Optimum page size doesn't depend on data but on application usage. I can repeat once again:

Re: [firebird-support] Why won't Firebird restore backups from a network drive?

2019-11-13 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
13.11.2019 18:53, dco...@sympatico.ca [firebird-support] wrote: > We're actually already doing the backups and restores with the Services API. Usually account used to run Firebird server has no access to network at all. Thus the error you see. -- WBR, SD.

Re: [firebird-support] Re: What are the trade-offs of CHAR vs. VARCHAR?

2019-11-13 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
13.11.2019 18:42, blackfalconsoftw...@outlook.com [firebird-support] wrote: > So my understanding of how the VARCHAR field works is correct and what I have > stated earlier. Your understanding is wrong and either IB Expert site is wrong as well or you misread it. Yest remember: CHAR -

Re: [firebird-support] Re: High write access on disk

2019-11-13 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
13.11.2019 21:06, kragh.tho...@yahoo.com [firebird-support] wrote: > Just to clarify, one could make a RAM drive with tmpfs, eg /ramdrive, and > then specify > this path in firebird.config under "TempDirectories"? Not quite. > If correctly understood, does this provide any benefits over

Re: [firebird-support] Re: What are the trade-offs of CHAR vs. VARCHAR?

2019-11-14 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
14.11.2019 18:01, blackfalconsoftw...@outlook.com [firebird-support] wrote: > However, the PDF language manual I have for version 2.5 does in fact state > the following... > > > "A fixed-length character data type. When its data is displayed, trailing > spaces are added > to the string up to

Re: [firebird-support] Re: What are the trade-offs of CHAR vs. VARCHAR?

2019-11-14 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
14.11.2019 20:29, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > Actually Dimitry, Steve was quoting from the Firebird 2.5 Language > Reference: >

Re: [firebird-support] Re: What are the trade-offs of CHAR vs. VARCHAR?

2019-11-14 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
14.11.2019 20:29, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > And that part of the documentation is unfortunately wrong (although I'm > not sure why the language reference even cares to describe such an > implementation detail). This documentation is actively corrected and

Re: [firebird-support] What is the optimum pageSize?

2019-11-14 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
14.11.2019 23:30, Clyde Eisenbeis cte...@gmail.com [firebird-support] wrote: > What is the max page size for Firebird 3? 16 kilobytes. > Also, could you clarify a page? Quoting

Re: [firebird-support] Re: What are the trade-offs of CHAR vs. VARCHAR?

2019-11-14 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
14.11.2019 23:19, Clyde Eisenbeis cte...@gmail.com [firebird-support] wrote: > The previous comments indicate that Firebird is Litle Endian. It doesn't matter because Firebird client deliver length of VARCHAR in native endiannes and for the rest there are API functions to convert

Re: [firebird-support] Re: What is the optimum pageSize?

2019-11-14 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
14.11.2019 23:47, blackfalconsoftw...@outlook.com [firebird-support] wrote: > Doesn't the page size definition as per a database depend on one designs > their database > tables and how such tables will be used? Cases when pages of smaller size have a speed advantage are very special and

Re: [firebird-support] What is the optimum pageSize?

2019-11-17 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
17.11.2019 12:22, jerz...@o2.pl [firebird-support] wrote: > > Because it is hard to do. A lot of internals in Firebird and its clients > > rely on this maximum size (hint: the number itself fits in a 2-byte > > unsigned integer). It is not like you just need to update a MAX_ROW_SIZE > >

Re: [firebird-support] What are the trade-offs of CHAR vs. VARCHAR?

2019-11-12 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
12.11.2019 18:38, cte...@gmail.com [firebird-support] wrote: >   I know that VARCHAR consumes less space. It doesn't. CHAR has no advantages over VARCHAR in most usages. Only very little cases need fixed length data (and usually it is binary data). -- WBR, SD.

Re: [firebird-support] What are the trade-offs of CHAR vs. VARCHAR?

2019-11-12 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
12.11.2019 23:06, Clyde Eisenbeis cte...@gmail.com [firebird-support] wrote: > As I understand, the FbConnection.CreateDatabase max pageSize for VARCHAR is > 8191.  Does > the page size change to less than 8191 if the VARCHAR is less? Database page size has no relation with any data type

Re: [firebird-support] with wrong sql i get no exception or firebird error

2019-11-15 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
15.11.2019 12:45, 'Harald Wolf' firebir...@online.de [firebird-support] wrote: > Any suggestions? Dig into IBPP sources and find out the reason. Use debugger. -- WBR, SD.

Re: [firebird-support] What is the optimum pageSize?

2019-11-15 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
15.11.2019 11:58, jerz...@o2.pl [firebird-support] wrote: > What is the max record size in FB3 (in bytes)? > I search for this information without success. https://firebirdsql.org/en/firebird-technical-specifications/ -- WBR, SD.

Re: [firebird-support] Push notifications prom DB

2019-11-15 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
15.11.2019 12:56, Tommi Prami tommi.pr...@suonentieto.fi [firebird-support] wrote: > Does any database/standard have such mechanism in DB-Engine level that > application could > get some kind of notifications of updates. Firebird has events (read Language Reference about POST_EVENT), Oracle

Re: [firebird-support] What is the optimum pageSize?

2019-11-15 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
15.11.2019 22:09, jerz...@o2.pl [firebird-support] wrote: > But only for FB 2.5, not for FB3! > My question was about FB3. Where is info about new versions? In Release Notes for these versions. Maximum size of record was not changed. -- WBR, SD.

Re: [firebird-support] Unrecognized Service Parameter Block during FbBackup.Execute

2019-11-15 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
15.11.2019 10:56, fbianch...@yahoo.com [firebird-support] wrote: > any hint? https://groups.google.com/forum/#!forumsearch/firebird-net-provider;context-place=overview -- WBR, SD.

Re: [firebird-support] What is the optimum pageSize?

2019-11-16 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
16.11.2019 09:33, jerz...@o2.pl [firebird-support] wrote: > a few larger char fields with multibyte coding and we get an exception. An entity with several large text attributes is unusual. Can you provide an example? -- WBR, SD.

Re: [firebird-support] FB3

2019-11-08 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
08.11.2019 10:35, mohamed hamza medh...@hotmail.com [firebird-support] wrote: > In FB 2.5  I have it as ftBcd   and ftinteger in FB3. It is a problem in your application and used components. -- WBR, SD.

Re: [firebird-support] ISC ERROR CODE:335544721

2019-11-18 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
18.11.2019 19:40, Michel LE CLEZIO mlcvi...@yahoo.fr [firebird-support] wrote: > Do you have an idea of what I have to do ? Remove Interbase client and use Firebird client to connect to Firebird. -- WBR, SD.

<    1   2   3   4   5   6   7   8   >