Re: [firebird-support] embedded database with Chinese path

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

03.10.2017 2:25, Hamish Moffatt ham...@risingsoftware.com [firebird-support] 
wrote:
> Any ideas?

   Give up. Firebird does not support unicode characters in database name and 
path. Only ANSI.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] embedded database with Chinese path

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

03.10.2017 11:05, Kjell Rilbe kjell.ri...@marknadsinformation.se 
[firebird-support] wrote:
> Forgive me for butting in, but... Perhaps it's high time to change FB
> then? Unicode is "everywhere" these days, and FB should keep up.

   It is a lot of work, so the path 
(https://github.com/aafemt/firebird/tree/unicode) was 
big and broke some functionality. Core developers rejected it.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Service restore from stdin

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

   Hello.

   When I use isc_info_svc_line for sending a piece of backup to server, 
everything works 
well. But when I use just replace isc_info_svc_line with isc_info_svc_to_eof, 
no errors is 
produced, but database is not restored.
   Do I something wrong or it is a bug (incomplete implementation)?

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [Graymail] [firebird-support] Service restore from stdin

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

03.10.2017 16:43, 'Sabbagh, Nariman' nariman.sabb...@delta.com 
[firebird-support] wrote:
> Does anybody know what the server name is

   I used 'localhost' but AFAIU it should be irrelevant.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Service restore from stdin

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

04.10.2017 11:42, Pavel Cisar pci...@ibphoenix.cz [firebird-support] wrote:
> You can't use isc_info_svc_line for sending backup file to the service.

   But that's what fbsvcmgr does.

> The right token is isc_info_svc_stdin.

   No, it is only for getting buffer size from server. I have no idea why 
application must 
care about server buffer, but that how current implementation works.

> isc_info_svc_to_eof *may* work once whole backup stream is sent to the 
> service,

   I tried. My backup file was 512 bytes long, but it didn't work. That's why I 
started 
this thread.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Service restore from stdin

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

04.10.2017 11:42, Pavel Cisar pci...@ibphoenix.cz [firebird-support] wrote:
> Until stdin is fully transmited service may need another 
> chunk, but reply to application is blocked until stdout buffer (eof 
> request) is full, so everything gets stuck (service will not ask for 
> further input because there is not enough output to send the request).

   Actually I see the contrary: output buffer is empty, but no request for 
input is sent.
Output from my test program which send { isc_info_svc_stdin, isc_info_svc_line 
} looks 
like that:

> query piece 0
> isc_info_svc_stdin 262144
> isc_info_svc_line 0:
> isc_info_data_not_ready
> query piece 512
> isc_info_svc_stdin 262144
> isc_info_svc_line 0:
> isc_info_data_not_ready

   Notice that it always gets isc_info_data_not_ready.
   But if I change request to {isc_info_svc_stdin } (because I know that no 
data is ever 
returned), I get this:

> query piece 0
> isc_info_svc_stdin 0
> isc_info_end
 about 40 times the same ..
> query piece 0
> isc_info_svc_stdin 0
> isc_info_end
> query piece 0
> isc_info_svc_stdin 262144
> isc_info_end
> query piece 512
> isc_info_svc_stdin 262144
> isc_info_end

   I.e. server just wasting network throughput requesting no data from client 
as if 
request timeout is by default set to zero instead of infinity.
   Is it intended behavior?

   Besides, my whole test backup size is 512 bytes, but server asks for more 
data even 
when got it all.
   What else must I send to it?
   Now I forcefully disconnect after sending of whole backup and it seems to 
work. But is 
it right way?

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Service restore from stdin

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

04.10.2017 16:24, Dimitry Sibiryakov wrote:
>    I.e. server just wasting network throughput requesting no data from client 
> as if 
> request timeout is by default set to zero instead of infinity.

   Oops, I was wrong: even explicitly set timeout don't make service to wait 
before 
sending input data request.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Service restore from stdin

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

04.10.2017 18:28, Pavel Cisar pci...@ibphoenix.cz [firebird-support] wrote:
> Nope, without requesting isc_info_svc_line output you can't know when
> service actually finished, so you may close the service at will. If you
> close it *after* its finished then everything is ok, but if not, you
> will get broken database (unfinished restore). Note that after whole
> backup file is processed (and thus no more data are requested), then
> service recreates the index trees which may take a lot of time (depends
> on data size and number of indices) when you would get only text output.

   Fine.

   Another question: is there a way to abort restore process which would cause 
server to 
drop half-restored database? For example, if I have a problem of reading backup 
file.
   Or in this case I must connect to the database and drop it myself?

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Connected databases to the Server

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

07.10.2017 22:57, 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com 
[firebird-support] wrote:
> Which databases are connected, right now?

   Use MON$ATTACHMENTS with SYSDBA rights.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Backup Firebird 3.0.2 database using Service Manager

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

09.10.2017 16:08, pierr...@gmail.com [firebird-support] wrote:
> If I try to use a remote connection to service_mgr

   RTFM -expected_db.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

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

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

17.10.2017 20:12, Jorge Andres Brugger jorge.brug...@gmail.com 
[firebird-support] wrote:
> What am I doing wrong?

   You cannot fetch from non-select query.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

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

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

19.10.2017 18:11, Tomasz Tyrakowski t.tyrakow...@sol-system.pl 
[firebird-support] wrote:
> The real nightmare of a programmer is not when the program doesn't work
> and she/he doesn't know why; it's when the program does work and she/he
> doesn't know why :)

https://docs.microsoft.com/en-us/sql/odbc/reference/develop-app/was-a-result-set-created


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Index process in Firebird 2.1.4

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

20.10.2017 5:45, gn7s...@gmail.com [firebird-support] wrote:
> I want to know whether the following index is picked by the optimizer.

   You can know that if you run (or just prepare) the query in isql with "SET 
PLAN ON".


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Re: MON$REMOTE_ADDRESS

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

31.10.2017 20:44, m_brahi...@yahoo.fr [firebird-support] wrote:
> Is there a document which explains that ?

https://en.wikipedia.org/wiki/Ephemeral_port


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Primary key composed by multiple integer fields

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

11.11.2017 11:13, m_brahi...@yahoo.fr [firebird-support] wrote:
> I need to know please if it is allowed that a primary key has multiple 
> integer fields ?

   Yes, but usually it is a sign of a bad database design.

>  a PK that has seven integer fields will it decrease the performance table ?

   It depends on many details. Some operations may be affected, some not.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Primary key composed by multiple integer fields

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

11.11.2017 13:15, m_brahi...@yahoo.fr [firebird-support] wrote:
> All fields contained in the PK are updated is that mean by operations 
> affected ?

   No. Operations are: select, insert, update, delete. Update may change PK 
values or not, 
select can do index scan or full scan. All this are different cases and 
affected in 
different ways.
   Size of table also matters.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] NBackup Backup Takes Long Time For Level 2.

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

15.11.2017 7:49, Anto Edin Charley antoedinchar...@gmail.com [firebird-support] 
wrote:
> For every Level 2 Backup it takes more than 30 Minutes to complete. Is there 
> anything i 
> need to Check/Improve

1) Try switch -d. NBackup should work at disk's speed.
2) You can migrate to Firebird 3 where performance of nbackup of level 1+ was 
improved.

> or if this is the normal time that will take for this kind of Database.

   30 minutes for copying of 20 Gb file is too much. Even notebook HDD can 
perform better. 
Check your storage system.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Re: Rename a foreign key

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

16.11.2017 12:20, michael.vilhelm...@microcom.dk [firebird-support] wrote:
> I do know, that its a onetime thing, but if Ihave to wait for it to finish 
> all I want to 
> change, I will not do it.

   Run script in evening, get results in morning.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Copy Table to Another Database

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

21.11.2017 10:01, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote:
> How can I copy all records of a table to another table in different database. 
> The tables 
> having same design.

   Use "execute statement on external datasource".


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Copy Table to Another Database

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

21.11.2017 15:52, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote:
> Please see if the under mentioned procedure is good enough:

   I would do the contrary: select on external source and local insert. It is 
better for 
performance. But if your SP work for you, it is good.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] query with no result

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

24.11.2017 8:53, alauren...@gmail.com [firebird-support] wrote:
> I have a query with no results and I doo't understand what I do wrong:

   Conditions in your query will never met: you are asking for record that ARE 
in tempsub 
and at the same time ARE NOT in tempsub.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Re: query with no result

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

24.11.2017 11:22, alauren...@gmail.com [firebird-support] wrote:
> Because of that matter, I manufacture that query :)

   Remove TEMPSUB from FROM clause.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Trouble establishing a connection to Firebird database files.

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

27.11.2017 11:35, Justis Root justis.r...@gmail.com [firebird-support] wrote:
> What should I be checking first?

   First of all, carefully read error message. It usually contain a reason of 
failure.

> What info am I missing from this description in order to make assisting me 
> easier?

   The message, preferable copy-pasted from isql.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Deadlock error from firebird during midnight

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

30.11.2017 14:31, 'Joje' j...@codework-solutions.com [firebird-support] wrote:
> Interesting part is this error occurs only at midnight from 12 to 2 AM. 
> Thereafter, 
> everything goes smoothly without any error. I tried replicating this on my 
> test machine 
> but no success.
> 
> On analysing the pattern I think at midnight some CPU intensive applications 
> like 
> (/Machine backup or AV scanning etc/.) might be running on server machine.

   These application don't start transaction in Firebird database. Run audit 
and find out 
whom belong transaction from first error message.
   Don't forget to change transaction isolation level from default (for .NET 
provider) 
"read committed no record version" to "read committed record version at least" 
or, better, 
"snapshot".

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Deadlock error from firebird during midnight

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

01.12.2017 17:32, j...@codework-solutions.com [firebird-support] wrote:
> I got this errors only during midnight. Thereafter it's working fine.

   It may pretend to work fine, but using default transaction isolation level 
in .NET 
provider is just a disaster waiting to happen. It is the reason of the error 
you see.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Slow execution of Stored Procedure after 20 min. inactivity

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

05.12.2017 10:07, Marcel Brink mbr...@xploration.onmicrosoft.com 
[firebird-support] wrote:
> Does anyone have an idea why this happens only after around 20 minutes and 
> not every time ?

   You should, probably, turn performance counters output in trace as well. May 
be in 
these 20 minutes some old transactions are ended and your procedure has to 
collect garbage.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Problem with CONTAINING and COLLATE

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

07.12.2017 18:46, Gabor Boros mlngl...@bgss.hu [firebird-support] wrote:
> Why does the connection charset count?

   Because you are sending queries in connection charset. And string literals 
in them are 
in connection charset. Because of that your 'x' cannot have COLLATE PXW_HUNDC.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Problem with CONTAINING and COLLATE

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

08.12.2017 11:56, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote:
> I don't agree with this. The string literal is in the connection
> character set, but the value should be converted to the target character
> set (of the column) for the comparison

   No. Imagine connection charset to be UTF-8 and some characters in query that 
not exist 
in column charset. Should this situation throw "Cannot transliterate" error or 
return no 
results?


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Problem with CONTAINING and COLLATE

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

08.12.2017 12:07, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote:
> It should return no results. If it can't transliterate, it means that
> the character definitely does not exist in the target column, so the
> comparison is false.

   When character is transliterated into charset where it doesn't exist, it 
becomes '?'. 
I'm not sure that it should match '?' stored in the column.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Deadlock error from firebird during midnight

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

12.12.2017 7:32, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote:
> “Error reading data from the connection” has again surfaced

   This is a server crash. This instruction may be useful for you to help 
developers fix 
it: http://ibphoenix.com/resources/documents/development/doc_35


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Deadlock error from firebird during midnight

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

12.12.2017 13:28, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote:
> 1. I have generated DMP files for :
> (a) The Firebird server - size 62,028 KB and
> (b) My .NET Application - size 2,65,968 KB
> 
> 2. Please let me know how do I share these DMP files.

   If your database does not contain secrets, it is better to pack and upload 
them 
somewhere and post the URL into firebird-devel. Otherwise wait while someone of 
developers 
visit this thread and ask for sending them privately.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Re: Deadlock error from firebird during midnight

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

14.12.2017 9:00, hv...@users.sourceforge.net [firebird-support] wrote:
>> 1. The PID remains same: 4212, before and after the exception is caught.
> 
>    I.e. there was no crash of Firebird, very good.

   But still Firebird that just dropping connection instead of returning a 
proper error is 
not very good.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Re: Deadlock error from firebird during midnight

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

14.12.2017 11:25, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote:
> I need to keep my deployed application running, and would happily trade off 
> connection 
> pooling/SMP etc for robust connection. Any suggestions please ?

   First of all, look into firebird.log. Perhaps, disconnect reason is written 
there.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Re: Deadlock error from firebird during midnight

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

14.12.2017 11:34, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote:
>   INET/inet_error: read errno = 10054, client host = RajivPC, address = 
> 192.168.42.134/52754 , user = rdsc1

   If these data match your .NET application, then you have problem with 
network hardware 
or software: cables, routers, antivirus, firewall, etc.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Re: Deadlock error from firebird during midnight

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

14.12.2017 12:03, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote:
> 1. Here server and client both are on the same machine, RajivPC.

   It does not matter. Still there is software (and may be even hardware) 
between server 
and your application.

> 2. Execution of only one stored procedure has started to fail as the number 
> of records to be fetched increased. Rest are still executing fine. Older set 
> of records, lesser in number, are still fetched correctly.

   Did you try to make .NET provider to use native Firebird client for 
connections?


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Re: Deadlock error from firebird during midnight

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

14.12.2017 12:27, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote:
> 1. No, I did not. How do I do this?

   Google is your friend. For example: 
https://stackoverflow.com/questions/41980813/firebird-net-provider-and-embedded-server-3/41981523#41981523


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Lock Conflict

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

15.12.2017 12:04, OB1 oldbasf...@googlemail.com [firebird-support] wrote:
> Yes. A pre-insert on both that checks the data and assigns a PK from a 
> generator if one's 
> not assigned. Also checks valid data has been assigned and sets NEW.blah.  No 
> interaction 
> with other tables in anyway.

   You said that your transaction isolation is read committed, nowait. What 
about other 
flags? Do you use REC_VERSION or NO_REC_VERSION?

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Lock Conflict

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

15.12.2017 12:21, OB1 oldbasf...@googlemail.com [firebird-support] wrote:
> RecVersion = false

   That's bad. Change to true.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Info

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

19.12.2017 16:34, Nico Speleers nico.spele...@carfac.com [firebird-support] 
wrote:
> I want to know the next Id number in my table Addresses without an insert. In 
> my example 
> it will be 3. I want to reserve (without an insert) Id number 3 because 
> someone else can 
> also ask the next Id number. In that case it must be id number = 4, because 
> you've got 
> Number 1 and 2 in the table and number 3 is reserved.
> 
> How can I do that ?

   Use sequence.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Firebird 3.0.3 no longer compatible with InterBase 7.5.1 clients

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

19.12.2017 4:32, FSPAPA INCA Team i...@foodstuffs-si.co.nz [firebird-support] 
wrote:
> Wireshark traces show that the server is sending all the data from the query, 
> but the 
> client is not recognising it and waits forever

   So, you, actually, should ask Embarcadero why their client cannot work with 
Firebird 
anymore.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Firebird 3 client API to connect FB 2.5 database server

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

03.01.2018 11:51, Mauricio Junqueira mau...@gmail.com [firebird-support] wrote:
> Is there a way to change WireCrypt and AuthServer in the Database Params 
> Buffer?

   Use isc_dpb_config hack.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Firebird 3 client API to connect FB 2.5 database server

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

03.01.2018 21:38, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote:
>  > Use isc_dpb_config hack.
> 
> Which is? Please do not just drop vague hints, but actually provide an
> answer if you know it. Documentation and examples of the new API barely
> exist (or at least, I'm not aware of any).

   isc_dpb_config is used in exactly the same way as any other DPB tag: <1 
byte value 
length>. Value for it is a text from firebird.conf file, literally, in 
form 
= separated by new lines.
   Because of "hackish" nature of this tag, you'll get no indication if the 
value is 
well-formed and applied or contain mistypes and was silently ignored.

   But, actually, client library from Firebird 3.0 should work with server 2.5 
"out of 
box" without additional configuration.

> If this new API is going to get any use outside of the Firebird
> internals, then real answers will be helpful to fill the void of
> documentation/examples.

   At first, DPB is used in old API as well as in new one, no difference 
between them in 
this respect.
   At second, I personally think that in current form this new API must never 
leave internals.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Query and problem with nulls

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

04.01.2018 12:36, Luigi Siciliano luigi...@tiscalinet.it [firebird-support] 
wrote:
> The following query works fine but returns*all nulls*  if no rows
> between :DaData and :AData

   Are you sure that your query really returns all nulls and this is not a 
visual bug in 
the tool you run this query in? Show log from isql, please.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Query and problem with nulls

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

04.01.2018 16:55, Luigi Siciliano luigi...@tiscalinet.it [firebird-support] 
wrote:
> As you see:
> - if I select between 01/01/2018 and 31/12/2018 the are not rows in DT
> - if I select between 01/01/2017 and 31/12/2017 works fine because the
> are at least 1 row in DT

   So, where is the problem? I can't see "all nulls".


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Query and problem with nulls

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

04.01.2018 17:13, Luigi Siciliano luigi...@tiscalinet.it [firebird-support] 
wrote:
> if I select between 01/01/2018 and 31/12/2018 I not have results! this 
> because there are no rows in DT between 01/01/2018 and 31/12/2018.

   That's right. No rows - no result. If you want this result, add into year 
2018 a record 
with DEPOSITO_ID = 1.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] garbage problem

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

05.01.2018 18:09, HuI HaO huihaoc...@hotmail.com [firebird-support] wrote:
> currently i have an application at client side runing a timer 5s keep do the 
> select sql 
> read the Table as status on server DB. after few day run the fb service hang 
> up and slow 
> respond the DB file size also incease
> any solution？

   You must monitor health of your database using gstat, monitoring tables and 
other DBA 
tools to locate problem and solve it.
   Also OS monitoring tools must be used to diagnose whole system.


-- 
   WBR, SD.

Re: [firebird-support] Using a selectable stored procedure

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

06.01.2018 15:19, m_brahi...@yahoo.fr [firebird-support] wrote:
> Heres is a sample code of the SP

   There is no point in such SP. You'll get only bad performance and no 
advantages.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Activate all indexes

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

08.01.2018 23:09, fredf...@hotmail.com [firebird-support] wrote:
> No exception raised but indexes ar e not ac tivated! What is wrong? How can I 
> activate all 
> indexes correctly?

1. Indexes are activated on commit.
2. You don't need to use script component in Delphi, "execute block" is a 
single statement.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Firebird 3.0.1 freezes on one table for some 10-20 minutes during backup after gfix/mend

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

11.01.2018 9:14, jonatan.laurit...@yahoo.dk [firebird-support] wrote:
> Are there any ideas what happens and how to prevent it?

   Do you run gbak with -g switch?


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Firebird 3.0.1 freezes on one table for some 10-20 minutes during backup after gfix/mend

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

11.01.2018 11:29, jonatan.laurit...@yahoo.dk [firebird-support] wrote:
> No, we don't use -g.

   You should.

> We are doing immedate restore anyway after each backup.

   It is very doubtful practice. Immediate restore into different place is good 
for many 
reasons, but need in replacing original database with restored one mean that 
you have 
badly designed and written application.

> I have experience that such freeze happened once to the database that soon 
> got corrupted.

   Did you analyze output of "gstat -r"?

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Firebird 3.0.1 freezes on one table for some 10-20 minutes during backup after gfix/mend

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

11.01.2018 13:21, jonatan.laurit...@yahoo.dk [firebird-support] wrote:
> My understanding is that mend can not and it should not cause any troubles.

   Your understanding is wrong. This switch is intended to save at least some 
data from a 
dead database with gbak. After you used it, database is broken beyond repair.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] "Over the wire" Connection Encryption: AES

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

26.01.2018 13:37, daniel.acherm...@logismos.com [firebird-support] wrote:
> One of our customer is interested in the Firebird 3 feature of a "over the 
> wire" 
> connection encryption. This customer however prefers the AES-protocol instead 
> of the 
> default plug in with arc4.

   AES can hardly be used for wire encryption because wire block size is not 
always match 
AES encryption block size and plugin interface does not allow rounding up.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Miscalculation of floating points in Firebird

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

26.01.2018 16:17, Salim Naufal s.nau...@softnet.me [firebird-support] wrote:
> I am not familiar with the details of the SQL standard, is this the proper 
> was to round 
> and calculate numeric values in SQL?

   Yes. In your first examples you don't use floating point numbers, but exact 
decimals. 
SQL standard rules say that result of calculations on decimals is a decimal of 
appropriate 
precision.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Does gstat "max version">1000 indicates about problems?

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

09.02.2018 13:54, jonatan.laurit...@yahoo.dk [firebird-support] wrote:
> Are such values for max version dangerous? What can I do and what should I do 
> not to avoid 
> such large max version values?

   They are not dangerous, but very unpleasant because make your database slow. 
You must 
carefully design your database and application to a) avoid multiple updates of 
the same 
record again and again and b) don't run long lasting transactions that prevent 
garbage 
collector from working.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Adding a field with NOT NULL constraint

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

10.02.2018 16:32, Aldo Caruso aldo.car...@argencasas.com [firebird-support] 
wrote:
> I discovered that when a field is added to a table with a NOT NULL
> constraint and a default value, it is automatically filled with that
> default value.

   No, it isn't. It would be too slow.
   Default value is returned by select if no field value exists in returned 
record 
version. Engine works about this way:
1) Prepare buffer for returned values and fill it with default values.
2) Replace values in the buffer with values extracted from storage.
3) Send the buffer to client side.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Firebird:Search All Fields In All Tables For A Specific Value

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

11.02.2018 22:03, iorip...@sina.com [firebird-support] wrote:
> How to find out witch tables and fields include this Value?

   Dump whole database into text file(s) with IBexpert then grep.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] FB 2.5 backed-up DB cannot be restored, msg about Malformed String and "Use -FIX_FSS_DATA option."

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

20.02.2018 16:36, dco...@sympatico.ca [firebird-support] wrote:
> I've Googled a lot about this and that -FIX_FSS_DATA option seems to only 
> really be 
> relevant when restoring DBs from much earlier versions of FB - but this is 
> from the same 
> version!

   Version of engine doesn't matter in this case. ODS does.
   ODS used in 2.0.1 allowed malformed string literals in stored objects and 
data tables, 
ODS for 2.5 prohibit that.
   If you see this error, it means that you'd better migrate database between 
version by 
creation of brand new database from script and then pump data from old 
database. During 
this process you'll encounter errors that you must fix by changing script or 
source database.
   -FIX_* switches must be used very carefully by experienced DBA only. In 
wrong hands 
they will lead to data corruption beyond recovery.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Cannot open database file in local hard disk

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

20.02.2018 0:31, Eduardo guse...@gmail.com [firebird-support] wrote:
> If I use C:\Test\MYDATABASE.FDB I get "unavailable database".
> If I use SERVERNAME:C:\Test\MYDATABASE.FDB I get "unavailable database".
> If I use \\SERVERNAME\C:\Test\MYDATABASE.FDB I get "unavailable database".
> 
> If I modify firebird.conf creating the alias 
> MYDATABASE=C:\Test\MYDATABASE.FDB, then using 
> MYDATABASE I can open the database.

   Check that disk letter you used is really "C" and not just something that 
looks 
similar, like, for example, "С".


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] SecurityDatabase in FB3

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

21.02.2018 13:46, Alexander Tabakov a.taba...@eklektica.com [firebird-support] 
wrote:
> 
> What happens in case 3 (stored in the same database) when we move the 
> database on a 
> different server. Shall credentials stored in place take precedence over the 
> other 
> server's configuration?

   No.

> In case of a server running in /classic /mode and case 2 (credentials in a 
> separate 
> database), shall FB start a different process for each and every connection 
> just to verify 
> user credentials?

   No.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Re: SecurityDatabase in FB3

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

22.02.2018 6:22, Alexander Tabakov a.taba...@eklektica.com [firebird-support] 
wrote:
> So, generally speaking are there any benefits of embedding the credentials 
> into the 
> database - performance, security, other ?

   You don't need to backup/replicate two databases, one is enough.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] No permission to remote access to database

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

22.02.2018 11:15, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] 
wrote:
> How to add permission to login into security3.fdb?

   Locally you don't need any special permission. Remotely you must edit 
databases.conf to 
enable that.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Read only user for Firebird 3.

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

22.02.2018 20:07, Alexandre Vinhaes - Tecnico - Tecnologia 
alexandre.vinh...@cipa.com.br 
[firebird-support] wrote:
> I need to have a read only login (read all views and tables) for specifc 
> application 
> connection. Some those views executes procedures internally. So, in this 
> case, select 
> grant is not enough.

   Grants are enough. In Firebird rights can be granted not only to users, but 
to database 
objects as well: views, stored procedures, etc.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Execute Block: too many inserts

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

01.03.2018 19:43, ho...@agencybusys.com [firebird-support] wrote:
> What is the best way to accomplish very large batches?

   If data is plain (without BLOBs) then using of external tables is the 
fastest way.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Execute Block: too many inserts

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

01.03.2018 20:37, ho...@agencybusys.com [firebird-support] wrote:
> I suspect it would be true if the source data was already in a table on the 
> server, but 
> mine is newly entered data by a user on a network client.

   In this case I'd suggest to use prepared statement in single transaction.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] C++/C compiler for Firebird 3 UDF on Windows - free version?

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

08.03.2018 12:44, jonatan.laurit...@yahoo.dk [firebird-support] wrote:
> Just wanted to know if there is available free (of charge) C++/C compiler for 
> Firebird 3 
> UDFs on Windows - 32 bit and 64 bit?

   GCC (MinGW).


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Re: Can many Execute Blocks be within a Transaction.

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

13.03.2018 9:30, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote:
> and in Firebird 3 when using the old API (most applications use
> the old API).

   Actually 64k limit is applied to statement in ISC API only if length of 
statement is 
indicated explicitly and function declarations are unmodified. Otherwise it is 
the same as 
in the new API.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] BLOB Not Found error

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

16.03.2018 14:47, shg_siste...@yahoo.com.ar [firebird-support] wrote:
> Since some days ago I'm getting (it seems very occasionally and randomly) a 
> "blob not 
> found" error.
> As far as I remember the problem happens during read operations: with 
> "locate" commands or 
> inside a "while not eof" loop...

   You should use "Repeatable Read" or "Snapshot" transaction isolation mode. 
In "Read 
Committed" you can get this error if record has been deleted and garbage 
collected before 
you start reading the BLOB.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] BLOB Not Found error

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

16.03.2018 15:26, shg_siste...@yahoo.com.ar [firebird-support] wrote:
> The same applies if the record wasn't deleted but changed by another 
> transaction?

   Yes. From technical POV there is no difference between update and delete in 
Firebird.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Impossible to create a new database from a script

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

17.03.2018 14:50, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote:
>  >   DEFAULT CHARACTER SET ISO8859_1
>  >   COLLATION ES_ES;
>  >
> 
> What character set is the script file using? Is it using UTF-8 or
> WIN1252? You are currently probably connecting using NONE.
> 
> If the script file is in UTF-8, add a SET NAMES UTF8;, if the script is
> WIN1252, try adding SET NAMES WIN1252; Add this **before** creating the
> database.

   I would guess that script is also in ISO8859_1. SET NAMES verb can be added 
directly to 
CREATE DATABASE statement too though this feature is not documented.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Impossible to create a new database from a script

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

17.03.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.

   Exactly because if that it has a definite encoding. And you, as its author, 
must know 
what encoding you used when press "Save" button in editor. And you must inform 
Firebird 
which encoding it is. You must do all this right otherwise you'll get the error 
which you 
actually got.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Network disconnection

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

19.03.2018 10:34, atuncce...@duzen.com.tr [firebird-support] wrote:
> Sometimes, on some computers the application crashes with this error, which 
> can be seen in 
> the event log:
> 
> 
> Faulting application name: duzen_test.exe, version: 1.5.5.9106, time stamp: 
> 0x2a425e19
> Faulting module name: KERNELBASE.dll, version: 10.0.16299.309, time stamp: 
> 0xd3aa915c
> Exception code: 0x0eedfade
> Fault offset: 0x001008f2
> Faulting process id: 0x1a50
> Faulting application start time: 0x01d3bf53640714a3
> Faulting application path: C:\Program Files\duzenlab\duzen_test.exe
> Faulting module path: C:\WINDOWS\System32\KERNELBASE.dll
> Report Id: fc986cb6-6732-4a28-94e5-46c05fc04f5f
> 
> I can replicate this error by disconnecting and reconnecting the cat5 network 
> cable or by 
> disabling-enabling the network adapter.

   No Firebird is mentioned anywhere. eedfade is Delphi exception that is 
raised when 
accessing already freed memory.
   Use built-in FastMM debug capacities to debug your application.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Trailing spaces behaviour

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

20.03.2018 15:34, Alexander Tabakov a.taba...@eklektica.com [firebird-support] 
wrote:
> 
> Is this by design :)

   Yes, it is by SQL standard.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Firebird UDF Access configuration failing

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

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.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Re: Firebird UDF Access configuration failing

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

27.03.2018 11:46, rgilland1...@gmail.com [firebird-support] wrote:
> Have read closely the comments on the parameter, and cannot see how it 
> violates them

   "If you choose Restrict, *provide _';'_ -separated trees list*, where UDF 
libraries".


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Re: Firebird UDF Access configuration failing

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

27.03.2018 12:10, rgilland1...@gmail.com [firebird-support] wrote:
> So how should I format the below?
> 
> UdfAccess = Restrict UDF C:\Program Files (x86)\Firebird\Firebird_2_1\UDF

   Quoting Firebird.conf:

> # DatabaseAccess = Restrict C:\DataBase
> # DatabaseAccess = Restrict C:\DataBase;D:\Mirror
> # DatabaseAccess = Restrict /db
> # DatabaseAccess = Restrict /db;/mnt/mirrordb


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Firebird UDF Access configuration failing

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

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 hints.

   Yes, but giving a fish to a man used to be considered less helpful than 
teaching him 
how to fish.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Firebird log, error

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

29.03.2018 15:32, atuncce...@duzen.com.tr [firebird-support] wrote:
> What might be causing this, any ideas?

   NULL pointer to an object most likely. See call stack for details.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Auto-increment generating old ID's for insertion

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

03.04.2018 7:19, 'Joje' j...@codework-solutions.com [firebird-support] wrote:
> _Trigger that calls generator is fired on insertion:_

   Try to add some logging into this trigger to detect cases when record is 
inserted with 
application-provided _ID and thus generator is not used.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] segfault

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

06.04.2018 13:57, atuncce...@duzen.com.tr [firebird-support] wrote:
> Is the IP expression in the logs show the IP of the client? If yes, how do I 
> decode it? :)

   It shows IP register of CPU at the moment of crash.

You can track the crashes using core dump as described in 
http://ibphoenix.com/resources/documents/search/doc_36


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] IB XE7 to FB 3 Migration

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

10.04.2018 22:16, j...@firstduews.com [firebird-support] wrote:
> I am trying to migrate my IB database to FB. When I do the backup/restore 
> process It 
> errors on on a table.

   You cannot migrate database between Interbase and Firebird using 
backup-restore. They 
are different DBMS now.
   Create empty database from scratch and pump data.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Book on T-SQL

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

18.04.2018 12:24, Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] 
wrote:
> I want to use TSQL in Firebird

   Give up. Firebird supports standard SQL to some extend. T-SQL supports 
standard SQL to 
some extend. Firebird has no support for T-SQL.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Write UDF for 3.0 - Linux 64bit vs Windows 32bit

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

19.04.2018 13:16, Gabor Boros mlngl...@bgss.hu [firebird-support] wrote:
> What I am doing wrong?

   Your function does not match its definition: "RETURNS PARAMETER 1" is not 
what you think.
   Use nm to check that TEST_UDF is really exported (remember about case 
sensitivity) and 
library is really libMY_UDF.so (case sensitivity again).


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Write UDF for 3.0 - Linux 64bit vs Windows 32bit

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

19.04.2018 15:34, Gabor Boros mlngl...@bgss.hu [firebird-support] wrote:
> I found it! :-) Works on Linux too if "... MODULE_NAME
> '/opt/firebird/UDF/MY_UDF';"

   It means that in your firebird.conf you have "UDFAccess = Full" which is not 
default 
and a very bad idea from security POV.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] UDF "returning" BLOB slow after first call

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

23.04.2018 16:18, tvd...@ymail.com [firebird-support] wrote:
> It seems to be that call to blob_put_segment that becomes slow. At first 
> usage of the UDF 
> it's almost instant, and after that it takes 15ms for every invocation.
> 
> What causes this and can I avoid it?

   Data, returned from UDF as a BLOB, are stored in database and kept there 
until end of 
transaction where UDF has been called. More returned data - bigger database, 
slower access 
to it.
   Think twice if you really need return BLOB from UDF.
   Commit the transaction as soon as possible.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Re: aliases.conf ignored?

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

25.04.2018 14:42, Harald Wolf leaw...@gmx.de [firebird-support] wrote:
> What the heck is going wrong here?

   Process Monitor will show where Firebird look for aliases.conf, if at all.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Dynamic PSQL (Execute Statement) in Stored Procedure With "SELECT / INTO"

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

25.04.2018 22:33, blackfalconsoftw...@outlook.com [firebird-support] wrote:
> It seems that no matter how I try to implement the "INTO" clause against the 
> return 
> variable, when I run the procedure from my DB-Manager it yields an error...

   INTO belongs to EXECUTE STATEMENT clause, not to executed SQL. Read Language 
Reference.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Transaction ID overflow

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

01.05.2018 9:19, Brian Dunstan brian.duns...@health.telstra.com 
[firebird-support] wrote:
> If we move to dialect 3, does the TID become 64 bits?

   It is 48 bits in Firebird 3.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] gbak of encrypted database

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

01.05.2018 7:57, 'Alexey Kovyazin (ak)' a...@ib-aid.com [firebird-support] 
wrote:
> If you're implementing your own plugin,  you can implement whatever you need.

   Oh, really? How server plugin can affect what client utility does?


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Measure the effectiveness of incrementing page buffer...

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

03.05.2018 7:56, Javier Cintron fcintr...@yahoo.com [firebird-support] wrote:
> Firebird ver 2.5.7.27050 64 bits
> Windows Server 2012R2
> 
> ¿Is there a way to calculate the effectiveness of incrementing the page cache 
> buffer ?

   select cast(mon$page_reads as double precision)/mon$page_fetches from 
mon$io_stats 
where mon$stat_group=0
   If the value is getting lower - you are on the right way.


-- 
   WBR, SD.

Re: [firebird-support] Proper way to handle an open Firebird database...

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

03.05.2018 16:11, Javier Cintron fcintr...@yahoo.com [firebird-support] wrote:
>  1. When I need to copy my Firebird database: Do I need to shutdown the 
> Firebird instance
> first? and If y es, what is the proper way to shutdown and startup it?

   You may shut it down or use nbackup or use ALTER DATABASE BEGIN BACKUP 
query. nbackup 
is the simplest way.

>  2. When I need to restart Windows Server, Do I need to shutdown the Firebird 
> instance first? 

   No. Windows correctly shut every service down before restart.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Problem returning multiple rows from a CTE-recursive procedure

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

03.05.2018 23:04, blackfalconsoftw...@outlook.com [firebird-support] wrote:
> However, I though only the issuance one "SUSPEND" was enough to flush the 
> entire buffer of 
> all records...

   No. One SUSPEND - one record in result set. Two SUSPENDs - two records and 
so on.

   Watch this in isql:

SQL> set term GO;
SQL> EXECUTE BLOCK RETURNS (A INTEGER)
CON> AS
CON> begin
CON>  a = 1;
CON>  SUSPEND; -- return a record containing 1
CON>  a = 2;
CON>  SUSPEND; -- return a record containing 2
CON>  SUSPEND; -- return another record containing 2
CON> end
CON> GO

A

1
2
2

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] What regular maintenance actions does Firebird need in order to function properly?

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

04.05.2018 4:55, Javier Cintron fcintr...@yahoo.com [firebird-support] wrote:
> what other regular maintenance actions does Firebird need in order to 
> function properly?

   It may be a good idea to recalculate index statistics from time to time.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Measure the effectiveness of incrementing page buffer...

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

04.05.2018 11:42, Alexey Kovyazin a...@ib-aid.com [firebird-support] wrote:
> the single badly designed query with many page fetches can "improve" this 
> parameter a lot, 
> without any real improvement in the performance, of course.

   The question was about cache effectiveness which is always measured as "hit 
ratio", not 
about abstract "performance" which has no formal metrics.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Create a table from Query

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

04.05.2018 14:04, antoedinchar...@gmail.com [firebird-support] wrote:
> Is there any way we could create a table in Firebird using the query?

   No. Firebird cursors (implicit and explicit) are more powerful than MS SQL's 
ones and 
let developers avoid local temporary tables completely.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Problem returning multiple rows from a CTE-recursive procedure

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

04.05.2018 18:13, Steve Naidamast blackfalconsoftw...@outlook.com 
[firebird-support] wrote:
> If you look at my procedure below, you will note that there is only a single 
> "SUSPEND" 
> statement.

   If you look a little more, you'll see that it is called in a loop.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Problem returning multiple rows from a CTE-recursive procedure

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

04.05.2018 20:10, blackfalconsoftw...@outlook.com [firebird-support] wrote:
> Nonetheless, I have worked with Oracle, Sybase, MySQL, and a little 
> PostgreSQL and SQLite.

   I can't believe that you never looked at Oracle's FOR LOOP syntax in 
pipelined 
functions which difference from Firebird is subtle.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

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

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

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 calling 
> triggers

   Modify your trigger to check some context variable and skip actions. Then do 
something 
like that:

EXECUTE BLOCK AS
declare variable dummy integer;
BEGIN
  dummy = RDB$SET_CONTEXT('USER_TRANSACTION', 'DO_NOT_FIRE_TRIGGERS', 'YES');
  UPDATE TABLE1 set FIELD1=0 WHERE FIELD1=1;
  dummy = RDB$SET_CONTEXT('USER_TRANSACTION', 'DO_NOT_FIRE_TRIGGERS', 'NO');
END


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Strange SIMILAR TO result

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

07.05.2018 12:19, Gabor Boros mlngl...@bgss.hu [firebird-support] wrote:
> A simple example: SELECT ''='' SIMILAR TO '[A-Z]{2}[0-9A-Z]{2,13}' FROM
> RDB$DATABASE
> 
> Why is the result true?

   Your expression is actually calculated as "CAST(''='' as CHAR(5)) SIMILAR TO 
'[A-Z]{2}[0-9A-Z]{2,13}'".
   (''='') is true and string representation of true is 'TRUE ' that matches 
your patters.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Strange SIMILAR TO result

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

07.05.2018 13:57, Gabor Boros mlngl...@bgss.hu [firebird-support] wrote:
> So I see what you say. But result of
> 
> SELECT CAST(''='' AS CHAR(5)) SIMILAR TO  '[A-Z]{2}[0-9A-Z]{2,13}' FROM
> RDB$DATABASE;
> 
> is
> 
> ===
> 

   Perhaps, it must be CHAR(4) or VARCHAR. I'm not sure in type of implicit 
cast result.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Guid in firebird

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

08.05.2018 16:28, ymak1...@yahoo.com [firebird-support] wrote:
> Any ideas?

   Do not use CHAR_TO_UUID(). Store and use GUIDs in binary form using 
parametrized queries.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/