Re: [firebird-support] 2 firebird versions in parallel ?

2020-03-06 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
Hi,I don't know if that works on Linux but on Windows we are using v2.5 and 3,you need to specify another port and instance name,maybe this will help you:How to install Firebird 3 as the second instance in 5 minutes | | | | | | | | | | | How to install Firebird 3 as the second inst

Re: [firebird-support] avoid query subselect

2019-07-19 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
indeed much better thanks! On Friday, July 19, 2019, 02:34:20 PM GMT+3, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote:   Hi, i suppose this one is much faster SELECT P.ID, CASE WHEN EXISTS(SELECT *  FROM  CHILD C WHERE C.ID_PARENT=P.ID AND C.MYFIELD=3) ) THEN

[firebird-support] avoid query subselect

2019-07-19 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
HiI have a performance issue on a query where I need all parent record and from child table I only want a flag if there is any child record matching a condition,so I write something like that: SELECT P.ID,IIF(SUB.ID IS NULL,0,1) AS ISDATA  FROM PARENT P   LEFT JOIN     (SELECT FIRST 1 PA.ID FROM

Re: [firebird-support] Help creating expression index

2019-07-17 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
great solutionthanks! On Wednesday, July 17, 2019, 06:59:44 PM GMT+3, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: 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:

[firebird-support] Help creating expression index

2019-07-17 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
HiI 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 I can create this index:   CREATE DESCENDING MYINDEX ON MYTABLE  COMPUTED BY (EXTRACT(YEAR FROM datein) || EXTRACT(MONTH FROM datein) )  and c

Re: [firebird-support] query Integer overflow

2019-06-23 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
thanks for the tip Dimitry On Sunday, June 23, 2019, 11:38:04 AM GMT+3, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: 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   Th

Re: [firebird-support] query Integer overflow

2019-06-23 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
it is workingthanks On Sunday, June 23, 2019, 10:00:20 AM GMT+3, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote:   On 23-6-2019 05:59, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > > > the error is gone if I cast one of the values

Re: [firebird-support] query Integer overflow

2019-06-22 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
V_E AS INTEGER)    ), b.PR_I)                  FROM GS_FIED a INNER JOIN GS_FIEP b on a.id=b.id_doc On Sunday, June 23, 2019, 12:42:42 AM GMT+3, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: 22.06.2019 21:47, 'Mr. John' mr_joh...@yahoo.com [firebird-suppo

Re: [firebird-support] query Integer overflow

2019-06-22 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
The calculation is on a SP code and I need it there,worked for couple years..until that valuesthanks On Sunday, June 23, 2019, 12:42:42 AM GMT+3, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: 22.06.2019 21:47, 'Mr. John' mr_joh...@yahoo.com [firebi

[firebird-support] query Integer overflow

2019-06-22 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
HiI'm facing with this error on FB 2.5.8(latest stable version)/ W10 x64: Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements.Integer overflow.  The result of an integer operation caused the most significant bit of the result to carry

Re: [firebird-support] Re: Unsuccessful execution on delete FB 3 SP source code

2019-06-13 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
no error now thanks On Thursday, June 13, 2019, 4:41:12 PM GMT+3, Dmitry Yemanov dim...@users.sourceforge.net [firebird-support] wrote:   13.06.2019 13:43, 'Mr. John' mr_joh...@yahoo.com wrote: > Using FB 3.0.4/Windows 10x64 ,I'm trying to delete SP source co

[firebird-support] Unsuccessful execution on delete FB 3 SP source code

2019-06-13 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
Using FB 3.0.4/Windows 10x64 ,I'm trying to delete SP source code as worked in 2.5:      UPDATE RDB$PROCEDURES SET RDB$PROCEDURE_SOURCE = NULL WHERE RDB$SYSTEM_FLAG IS NULL  OR RDB$SYSTEM_FLAG=0; bun now on FB 3 tried: update RDB$PROCEDURES set rdb$procedure_source = NULL where rdb$procedure_nam

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

2019-06-12 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
the sql.. and execute them into FB2.5... With best regards,Mikey Le mercredi 12 juin 2019 à 12:57:08 UTC+2, 'Mr.. John' mr_joh...@yahoo.com [firebird-support] a écrit :   I've extracted db into a script,but when restoring got almost the same error:   Invalid to

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

2019-06-12 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
RATOR GEN_HT_MENT_ID TO 1; in my app I have no such code,for generators I used this: CREATE GENERATOR GEN_HT_MENT_ID;SET GENERATOR GEN_HT_MENT_ID TO 1; thanks thanks On Wednesday, June 12, 2019, 1:25:40 PM GMT+3, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: 12.06.2019 12:20

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

2019-06-12 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
12 juin 2019 à 11:50:55 UTC+2, 'Mr.. John' mr_joh...@yahoo.com [firebird-support] a écrit :   HiI'm trying to restore a FB 3 database to 2.5Before fb3 backup,I copy from 2.5  gbak.exe to gbak2.exe into FB3 folderthen run  gbak2.exe -v -b "d:\db3.fdb" "d:

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

2019-06-12 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: 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 nt

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

2019-06-12 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
HiI'm trying to restore a FB 3 database to 2.5Before fb3 backup,I copy from 2.5  gbak.exe to gbak2.exe into FB3 folderthen run  gbak2.exe -v -b "d:\db3.fdb" "d:\dbbk.gbk"  -user SYSDBA -pass "mypass" backup is done with no erorrs I can restore it again to fb3 with no error but when I restore it to

Re: ODP: [firebird-support] Turn on WireCompression on Firebird 3

2019-03-04 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
the vps is only for test,no extra connection to dbCPU is 0%,memory 60% If need I can give access to databases/vps thanks On Monday, March 4, 2019, 7:32:21 PM GMT+2, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: 04.03.2019 18:11, Mark Rotteveel m...@lawinegevaar.nl [

Re: ODP: [firebird-support] Turn on WireCompression on Firebird 3

2019-03-04 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
rt] wrote: 04.03.2019 17:57, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > yes   In this case you must done something really

Re: ODP: [firebird-support] Turn on WireCompression on Firebird 3

2019-03-04 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
yes On Monday, March 4, 2019, 6:55:12 PM GMT+2, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: 04.03.2019 17:39, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > As I mentioned in my first post I run that query for 15 times for each sever

Re: ODP: [firebird-support] Turn on WireCompression on Firebird 3

2019-03-04 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
Hi where have you  run and got 0.078s?As I mentioned in my first post I run that query for 15 times for each sever FB,PG,mysql.tested from 2 different computers/internet connectionswhy PG and mysql works fine? PG is almost x40 times faster? On Monday, March 4, 2019, 6:06:17 PM GMT+2, Kar

Re: [firebird-support] Turn on WireCompression on Firebird 3

2019-03-04 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
On 4-3-2019 10:06, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > I'm using latest version 6.5.0 > found no isc_database_info item isc_info_firebird_version; > in FbConnection.ServerVersion. That is not what I meant... The request to Firebird server is

Re: [firebird-support] Turn on WireCompression on Firebird 3

2019-03-04 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
HiI'm using latest version 6.5.0 found no isc_database_info item isc_info_firebird_version; in FbConnection.ServerVersion. thanks On Monday, March 4, 2019, 10:52:43 AM GMT+2, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote:   On 4-3-2019 08:13, 'Mr. Jo

[firebird-support] Turn on WireCompression on Firebird 3

2019-03-03 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
Hi. I've installed Firebird 3.0.4 x64 on VPS,and got slow performance with our app changes made in firebird.conf:    TcpRemoteBufferSize = 32767 WireCompression = true + restart firebird service in client connection (.NET connector): I put     Compression=True I have zlib1.dll in app folder   

Re: [firebird-support] Deactivate triggers inside EXECUTE BLOCK

2018-05-07 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
thanks On Monday, May 7, 2018, 12:43:40 PM GMT+3, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: 07.05.2018 7:43, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > I'm looking for a way to run a simple update on couple tables without c

[firebird-support] Deactivate triggers inside EXECUTE BLOCK

2018-05-06 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
Hi.I'm looking for a way to run a simple update on couple tables without calling triggers,something like this: EXECUTE BLOCK ASBEGIN EXECUTE STATEMENT 'update RDB$TRIGGERS set rdb$trigger_inactive=1 where RDB$RELATION_NAME=''TABLE1'' ';   UPDATE TABLE1  set FIELD1=0 WHERE FIELD1=1; EXECUTE STATEM

Re: [firebird-support] Firebird shows previous timezone after that was changed

2017-06-13 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
Restarting fb service seems to solve this On Monday, June 12, 2017, 10:53:46 AM GMT+3, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:   Hi on a Windows 10 x64 server timezone was changed 24 hours ago,but firebird (2.5.7) still shows date and time from older  tim

[firebird-support] Firebird shows previous timezone after that was changed

2017-06-12 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
Hi on a Windows 10 x64 server timezone was changed 24 hours ago,but firebird (2.5.7) still shows date and time from older  timezone when running: select current_date, current_timestamp from rdb$database; how to make it give current values? thanks  

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

2017-04-15 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
today I've migrated my app (temporary) to FB 3 and there improvements,seems much faster than before,but Flamerobin still works slow  From: "Alexey Kovyazin a...@ib-aid.com [firebird-support]" To: firebird-support@yahoogroups.com Sent: Friday, April 14, 2017 11:01 PM Subject: Re: [fire

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

2017-04-14 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
Mobile: +420 724 207 851 icq:199 118 333 skype:skopaliks e-mail:skopa...@elektlabs.cz http://www.elektlabs.cz On 14.4.2017 22:05, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > I've done tests with fb3 (only by flamerobin) but the same results as 2.

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

2017-04-14 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
and that increases the cost of implementation. I have a server that has 30 firebird databases running on it. I have up to 80 users  at a time on my server and all customers are very happy with the speed of the server. Best Regards Jack Engleman From: "'Mr. John' mr_joh...@ya

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

2017-04-14 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
I've done tests with fb3 (only by flamerobin)  but the same results as 2.5 From: "Alexey Kovyazin a...@ib-aid.com [firebird-support]" To: firebird-support@yahoogroups.com Sent: Friday, April 14, 2017 11:01 PM Subject: Re: [firebird-support] Improve remote query speed on Windows Server

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

2017-04-14 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
this is just firebird specific? From: "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]" To: firebird-support@yahoogroups.com Sent: Friday, April 14, 2017 10:54 PM Subject: Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS 14.04.2017

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

2017-04-14 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
indeed with orbada    247ms instead of 5-6 seconds...also ibeExpert is slow and my app too From: "Michal Kurczabinski michk...@gmail.com [firebird-support]" To: firebird-support@yahoogroups.com Sent: Friday, April 14, 2017 10:33 PM Subject: Re: [firebird-support] Improve remote query

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

2017-04-14 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
indeed is faster From: "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]" To: firebird-support@yahoogroups.com Sent: Friday, April 14, 2017 10:29 PM Subject: Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS 14.04.2017 21:27, 'M

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

2017-04-14 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
query speed on Windows Server 2012 VPS 14.04.2017 21:20, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > select count(*)  remote  is fast > Total execution time: 0.386s   If you use isql instead of Flame Robin/IBExpert does it make

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

2017-04-14 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
, April 14, 2017 10:08 PM Subject: Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS 14.04.2017 20:50, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > on another table,same db, with 7 records and  12 columns takes * 2.362s*   Is result the sa

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

2017-04-14 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
no blob field.thanks From: "Thomas Kragh t...@uvdata.dk [firebird-support]" To: firebird-support@yahoogroups.com Sent: Friday, April 14, 2017 10:06 PM Subject: RE: [firebird-support] Improve remote query speed on Windows Server 2012 VPS   Does MYTABLE contain any blob columns w

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

2017-04-14 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
on ex: SELECT * FROM tabletest ORDER BY data desc  66 row(s) returned 0.063 sec 10 fields thanks From: "'Mr. John' mr_joh...@yahoo.com [firebird-support]" To: "firebird-support@yahoogroups.com" Sent: Friday, April 14, 2017 9:29 PM Subject: Re: [firebird-sup

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

2017-04-14 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
hi.I put only 2 columns but seems the same result From: "'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]" To: "firebird-support@yahoogroups.com" Sent: Friday, April 14, 2017 9:13 PM Subject: RE: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

Re: [firebird-support] Re: Improve remote query speed on Windows Server 2012 VPS

2017-04-14 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
no,it doesn't thanks From: "kragh.tho...@yahoo.com [firebird-support]" To: firebird-support@yahoogroups.com Sent: Friday, April 14, 2017 9:02 PM Subject: [firebird-support] Re: Improve remote query speed on Windows Server 2012 VPS   Does MYTABLEcontain any blob columns with dat

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

2017-04-14 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
hiMin=37ms Max=37ms Avg=37ms thanks From: "'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]" To: "firebird-support@yahoogroups.com" Sent: Friday, April 14, 2017 6:20 PM Subject: RE: [firebird-support] Improve remote query speed on Windows Server 2012 VPS   > select

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

2017-04-14 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
rt]" To: firebird-support@yahoogroups.com Sent: Friday, April 14, 2017 2:30 PM Subject: Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS 14.04.2017 8:22, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > How can I impr

[firebird-support] Improve remote query speed on Windows Server 2012 VPS

2017-04-13 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
Hi.I'm testing Firebird 2.5 x64 on Windows Server 2012 R2 VPSFrom tests,remote access database works slow,a simple query on a small table with about 500 records select * from MYTABLE where id=200  takes    Total execution time: 5.388s    PLAN (MYTABLE INDEX (PK_MYTABLE))   the same query executed

Re: [firebird-support] Firebird web hosting ASP.NET Core

2017-02-20 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
Hi. Asp Core works only with Entity Framework Core,there is a list of current supported providers :Database Providers | | | | || | | | || Database Providers By rowanmiller | | | |   Firebird is not there yet.This feature is listed on firebird tracker  

Re: [firebird-support] Firebird web hosting ASP.NET Core

2017-02-20 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
Hi,thanks for the infoin this case I can't access db from winforms app,only from web.for a while I need to access data from both.Firebird doesn't support Entity Framework Core at this moment so I can't use it with Asp Core  :( From: "'livius' liviusliv...@poczta.onet.pl [firebird-support]"

Re: [firebird-support] Firebird web hosting ASP.NET Core

2017-02-17 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
17, 2017 9:56 PM Subject: Re: [firebird-support] Firebird web hosting ASP.NET Core 17.02.2017 20:36, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > Our clients ask for mobile/web access of our app,in this case we decided to > rewrite app > with Asp Core.What opt

[firebird-support] Firebird web hosting ASP.NET Core

2017-02-17 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
Hi,we use Firebird 2.5 for a windows application build with .NETOur clients ask for mobile/web access of our app,in this case we decided to rewrite app with Asp Core.What options are for hosting firebird with asp core?thanks.

Re: [firebird-support] Reporting for Firebird in Visual Studio 2013 (C#)

2015-09-02 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
Hi,we're are using  Reporting Tools and Components for .NET, ASP.NET, ASP.NET MVC, Web, WPF, WinRT, HTML5 Silverlight, Flex, PHP, Java. Stimulsoft BI. :: Stimulsoft |   | |   | |   |   |   |   |   | | Reporting Tools and Components for .NET, ASP.NET, AS...Stimulsoft Reports Product Line include

Re: [firebird-support] Embedded Firebird unload delay

2015-08-30 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
is that a bug? From: "'Mr. John' ionut_...@yahoo.com [firebird-support]" To: Firebird Support Sent: Thursday, August 27, 2015 4:58 PM Subject: [firebird-support] Embedded Firebird unload delay   Hi, I use FB embedded version for a little local db,Firebird-2

[firebird-support] Embedded Firebird unload delay

2015-08-27 Thread 'Mr. John' ionut_...@yahoo.com [firebird-support]
Hi, I use FB embedded version for a little local db,Firebird-2.5.4.268560_Win32 on W 8.1 x86 with Visual Basic 2012FirebirdClient 4.7 (latest version) I run this simple code and when I close it,application closes but IDE still show "...Running"  for couple seconds (up to 5)If I change   ServerT

Re: [firebird-support] Re: MAKE 'EXECUTE STATEMENT' USE INDEX

2015-08-20 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
19, 2015 4:18 PM Subject: [firebird-support] Re: MAKE 'EXECUTE STATEMENT' USE INDEX   19.08.2015 14:29, 'Mr. John' wrote: > This time,adding condition this way WHERE FIEL1=:F1 AND FIEL2=:F2 AND > * (FIEL3=:F3 OR **:F3 IS NULL) * INTO .. DO .. > > is causing query to

Re: [firebird-support] Re: MAKE 'EXECUTE STATEMENT' USE INDEX

2015-08-20 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
cution finished.   in both cases  :F3  is NOT NULL thanks From: "Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]" To: firebird-support@yahoogroups.com Sent: Wednesday, August 19, 2015 11:51 AM Subject: [firebird-support] Re: MAKE 'EXECUTE STATEMENT' USE IN

Re: [firebird-support] Re: MAKE 'EXECUTE STATEMENT' USE INDEX

2015-08-19 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
: firebird-support@yahoogroups.com Sent: Wednesday, August 19, 2015 11:51 AM Subject: [firebird-support] Re: MAKE 'EXECUTE STATEMENT' USE INDEX   19.08.2015 10:26, 'Mr. John' wrote: > now index is used if I call > SELECT * FROM MYPROC(...) > but I use it in oth

Re: [firebird-support] MAKE 'EXECUTE STATEMENT' USE INDEX

2015-08-19 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
: firebird-support@yahoogroups.com Sent: Tuesday, August 18, 2015 8:03 PM Subject: Re: [firebird-support] MAKE 'EXECUTE STATEMENT' USE INDEX  Den 18.08.2015 16:59, skrev 'Mr. John' mr_joh...@yahoo.com [firebird-support]: HI,in SP I have this query   FOR EXECUTE STA

[firebird-support] MAKE 'EXECUTE STATEMENT' USE INDEX

2015-08-18 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
HI,in SP I have this query   FOR EXECUTE STATEMENT 'SELECT SUM(CANT)  FROM TABLE1 WHERE FIEL1='||:F1||' AND FIEL2='||:F2|| IIF(:pCondition=1,' AND FIEL3='||:F3,'')  INTO .. DO ..   TABLE1 PK =FIELD1,FIELD2,FIELD3  running the query gives a NATURAL PLAN How to make it use the index? Index is used

Re: [firebird-support] How safe is to use SS and embedded version in the same time

2015-08-10 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
Greatthanks! From: "Helen Borrie hele...@iinet.net.au [firebird-support]" To: firebird-support@yahoogroups.com Sent: Monday, August 10, 2015 10:40 AM Subject: Re: [firebird-support] How safe is to use SS and embedded version in the same time   At 07:26 p.m. 10/08/2015,

Re: [firebird-support] How safe is to use SS and embedded version in the same time

2015-08-10 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
Please,any advice there! From: "'Mr. John' mr_joh...@yahoo.com [firebird-support]" To: Firebird Support Sent: Saturday, August 8, 2015 12:54 PM Subject: [firebird-support] How safe is to use SS and embedded version in the same time   HiI'm my

[firebird-support] How safe is to use SS and embedded version in the same time

2015-08-08 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
HiI'm my application I'm using FB superserver for main data.I have some local data for application settings,different data (only for read) that can be updated on application update and for that I used some xml but I got couple corruptions,also can't secure it,etc. I need something else so I've t

Re: [firebird-support] Slow query using stored procedure

2013-02-19 Thread Mr. John
 this time : Total execution time: 0.265s :) Thanks for your help From: Svein Erling Tysvær To: "'firebird-support@yahoogroups.com'" Sent: Tuesday, February 19, 2013 2:57 PM Subject: RE: [firebird-support] Slow query using stored procedure   >Thanks a lo

Re: [firebird-support] Slow query using stored procedure

2013-02-19 Thread Mr. John
Thanks a lot for your help,your script seems logically but execution time is almost the same Executing statement... 66903234 fetches, 60972 marks, 3322 reads, 503 writes. 19593 inserts, 0 updates, 0 deletes, 33170949 index, 99576 seq. Delta memory: 2127804 bytes. GN_DEBUG: 19593 inserts.  Total

Re: [firebird-support] Slow query using stored procedure

2013-02-18 Thread Mr. John
Hi Svein,thanks a lot for your help! I also need to add one condition to my query,but I don't know how to do it using your script,so my new query:  SELECT a.date,a.id FROM mytable1 a WHERE a.year=2013  AND (a.month=1 OR  (A.NUMB                       IN (SELECT DISTINCT X.NUMB FROM PR_GET_SOLD(20

[firebird-support] Slow query using stored procedure

2013-02-18 Thread Mr. John
Hi ! I have one selectable stored procedure (PR_GET_SOLD) that works and this query : SELECT DISTINCT  X.NUMB  FROM  PR_GET_SOLD(2013,1)  X )  is executed in 0.219s with result of  77 rows :  FlameRobin :  Executing statement... Statement executed (elapsed time: 0.000s). 35972 fetches, 0 mar

Re: [firebird-support] Re: IIF bug?

2013-01-23 Thread Mr. John
it is also working, thanks ! From: Christian Mereles To: firebird-support@yahoogroups.com Sent: Wednesday, January 23, 2013 3:02 PM Subject: [firebird-support] Re: IIF bug?   and... SELECT '11'||IIF(1>2,'00', cast('' as varchar(1)))||'.22' FRO

Re: [firebird-support] IIF bug?

2013-01-23 Thread Mr. John
thanks! From: Mark Rotteveel To: firebird-support@yahoogroups.com Sent: Wednesday, January 23, 2013 4:31 PM Subject: Re: [firebird-support] IIF bug?   On Wed, 23 Jan 2013 05:45:40 -0800 (PST), "Mr. John" mr_joh...@yahoo.com> wrote: > t

Re: [firebird-support] IIF bug?

2013-01-23 Thread Mr. John
||(IIF(1>2,'00',ltrim('')))||'.22' FROM rdb$database ltrim is what you need then result is 11.22 Best regards, Djordje Radovanovic From: Mr. John Sent: Wednesday, January 23, 2013 1:49 PM To: firebird-support@yahoogroups.com Subject: [firebird-suppo

Re: [firebird-support] IIF bug?

2013-01-23 Thread Mr. John
Thanks for your answer ! From: Mark Rotteveel To: firebird-support@yahoogroups.com Sent: Wednesday, January 23, 2013 3:14 PM Subject: Re: [firebird-support] IIF bug?   On Wed, 23 Jan 2013 04:49:17 -0800 (PST), "Mr. John" mr_joh...@yahoo.com>

[firebird-support] IIF bug?

2013-01-23 Thread Mr. John
Hi ! I'm using FB 2.5.2 on XP I've discovered a strange behavior for IIF function:  SELECT '11'||(IIF(1>2,'00',''))||'.22'  FROM rdb$database as it can see condition is always false,IIF should result an empty string but the result is not                     11.22 ,the result is 11  

Re: [firebird-support] Temporary sets of data

2012-11-27 Thread Mr. John
Thanks so much Thomas ! From: Thomas Steinmaurer To: firebird-support@yahoogroups.com Sent: Monday, November 26, 2012 8:46 PM Subject: Re: [firebird-support] Temporary sets of data   > Hi,I use FB 2.5 ! > I'm writing a store procedure,and there I need some

[firebird-support] Temporary sets of data

2012-11-26 Thread Mr. John
Hi,I use FB 2.5 ! I'm writing a store procedure,and there I need some sets of data stored temporary to use only in my SP,I also need to update/delete it  Is there is a easy way to do this with firebird?  I also found there are temporary tables,but I don't know how to use or if is what I need. Tha

Re: [firebird-support] Strange SELECT FIRST 1

2012-09-12 Thread Mr. John
Thanks Ann for your explanations ! From: Ann Harrison To: firebird-support@yahoogroups.com Sent: Thursday, September 13, 2012 12:21 AM Subject: Re: [firebird-support] Strange SELECT FIRST 1   On Wed, Sep 12, 2012 at 3:25 PM, Mr. John wrote: > Hi

Re: [firebird-support] Strange SELECT FIRST 1

2012-09-12 Thread Mr. John
FIRST 1   On Wed, Sep 12, 2012 at 6:18 AM, Mr. John wrote: > Hi,I'm using FB 2.5.1.26351 SS on XP SP3,I have one stored > procedure,also inside > FOR EXECUTE STATEMENT loop I have this query > > SELECT FIRST 1 id_cf,numar FROM CB_FC WHERE ID_CF=:wid_cf > AND num

Re: [firebird-support] Strange SELECT FIRST 1

2012-09-12 Thread Mr. John
Thanks all for your help,I'll review my code to fix that From: Lucas Franzen To: firebird-support@yahoogroups.com Sent: Wednesday, September 12, 2012 2:21 PM Subject: Re: [firebird-support] Strange SELECT FIRST 1   Am 12.09.2012 13:13, schrieb Mr.

Re: [firebird-support] Strange SELECT FIRST 1

2012-09-12 Thread Mr. John
03 PM Subject: Re: [firebird-support] Strange SELECT FIRST 1   Hi, On 12/09/2012 12:18, Mr. John wrote: > What I don't understand,for this query > ... >SELECT FIRST 1 id_cf,numar FROM CB_FC WHERE ID_CF=:wid_cf AND > numar=:wNUMAR INTO :xid_cf,:xnumar; >

[firebird-support] Strange SELECT FIRST 1

2012-09-12 Thread Mr. John
Hi,I'm using FB 2.5.1.26351 SS  on  XP SP3,I have one stored procedure,also inside  FOR EXECUTE STATEMENT loop I have this query  SELECT FIRST 1 id_cf,numar FROM CB_FC WHERE  ID_CF=:wid_cf AND numar=:wNUMAR INTO :xid_cf,:xnumar;     wNUMAR,wid_cf  are also variables   declare xID_CF bigint;DEC

Re: [firebird-support] FB Silent install Exe

2012-07-31 Thread Mr. John
 the parameters apply  to setup file From: Allan Fernandes To: "firebird-support@yahoogroups.com" Sent: Wednesday, August 1, 2012 8:46 AM Subject: [firebird-support] FB Silent install Exe   I think my question is misunderstood. All I want to know is that

Re: [firebird-support] FB Silent install Exe

2012-07-30 Thread Mr. John
Maybe this will help you :   download NSIS from there :  http://nsis.sourceforge.net/Main_Page create a text file with .NSI  extension,setup.nsi with content below. rename wFirebirdKIT  with the name of your setup file,save and then right click on the file and chose "Compile NSIS script" ,now you'

Re: [firebird-support] Need data on server 1 up to date from server 2

2011-12-07 Thread Mr. John
Thanks Thomas,I'll take your suggestion too,thanks From: Thomas Steinmaurer To: firebird-support@yahoogroups.com Sent: Wednesday, December 7, 2011 9:25 AM Subject: Re: [firebird-support] Need data on server 1 up to date from server 2   Hi! > Hi Thomas,tha

Re: [firebird-support] Need data on server 1 up to date from server 2

2011-12-06 Thread Mr. John
Hi Thomas,thanks for your tip,so this is DATABASE REPLICATION I'll first start with some free tool,as I read  :   http://www.firebirdfaq.org/faq249/    there are some,please give me a good one for testing.I've downloaded ReplicadorBR (replicadorbr_0_5_5.zip) but this seems not to be in english and

[firebird-support] Need data on server 1 up to date from server 2

2011-12-06 Thread Mr. John
Hi all ! I'm using Firebird 2.5 on XP on 2 servers.I need to have on  server 1 data up to date from server 2,there is a easy way to do that ? Sure I can add from my application but there must be some generators or else that have to be updated too. Thanks for any tip. [Non-text portions of thi

Re: [firebird-support] Deploy firebird with another password for sysdba user

2011-11-14 Thread Mr. John
with another password for sysdba user   On 11/14/2011 09:23 AM, Lucas Franzen wrote: > Am 14.11.2011 10:05, schrieb Mr. John: >> That is working from inside NSIS installer: >> >>ExecWait 'gsec -user sysdba -password masterkey -modify SYSDBA -pw >> mypa

Re: [firebird-support] Deploy firebird with another password for sysdba user

2011-11-14 Thread Mr. John
added,thanks ! From: Lucas Franzen To: firebird-support@yahoogroups.com Sent: Monday, November 14, 2011 11:23 AM Subject: Re: [firebird-support] Deploy firebird with another password for sysdba user   Am 14.11.2011 10:05, schrieb Mr. John: > That

Re: [firebird-support] Deploy firebird with another password for sysdba user

2011-11-14 Thread Mr. John
That is working from inside NSIS  installer:  ExecWait 'gsec -user sysdba -password masterkey -modify SYSDBA -pw mypassword' ____ From: Mr. John To: "firebird-support@yahoogroups.com" Sent: Monday, November 14, 2011 10:59 AM Subject: Re: [fire

Re: [firebird-support] Deploy firebird with another password for sysdba user

2011-11-14 Thread Mr. John
//www.firebirdsql.org/en/firebird-foundation/ > Thanks > > > > > From: Helen Borrie > To: firebird-support@yahoogroups.com > Sent: Monday, November 14, 2011 10:22 AM > Subject: Re: [firebird-support] Deploy firebird with another password fo

Re: [firebird-support] Deploy firebird with another password for sysdba user

2011-11-14 Thread Mr. John
: Re: [firebird-support] Deploy firebird with another password for sysdba user   At 08:37 PM 14/11/2011, Mr. John wrote: >Hi ! We need to deploy firebird server with another password for sysdba user. >One solution is replacing security2.fdb during install of our >application+server.

[firebird-support] Deploy firebird with another password for sysdba user

2011-11-13 Thread Mr. John
Hi ! We need to deploy firebird server with another password for sysdba user. One solution is replacing  security2.fdb during install of our application+server. Is it  good solution ? Thanks ! [Non-text portions of this message have been removed]