RE: [firebird-support] Save database in table name format - Split database into table files? - Email found in subject

2012-08-16 Thread Evan Williams
Thank you for your response Sean but I think you misunderstood me. I am very familiar with cloud services and Dropbox. The database will live on a local computer, in the Dropbox folder. Is it possible to split the database into smaller files matching the respective file names within the

[firebird-support] Re: How firebird use indexes with inner join

2012-08-16 Thread leroyarnaud29
No. IMHO, the optimizer is doing a good job. It uses indexes with a good selectivity and first horizontally filter table A by using A_IDX1 and uses that already filtered stream to join table B via index B_IDX1. Just for the records: Firebird can join two indexes on the same table via

RE: [firebird-support] Save database in table name format - Split database into table files? - Email found in subject

2012-08-16 Thread Evan Williams
Thanks you for your response Mark, I meant using it for backups, because Dropbox only writes changes to the cloud and I wouldn't need to manually do backups in that case. I have my answer now. Thanks! I will look at other backup options..

[firebird-support] Help, how to connect to firebird via Internet

2012-08-16 Thread trskopo
Hi all, I have setup a dynamic ip address via www.no-ip.com and got a domain name. I can ping from windows this domain(by its name or ip address), but when I using flamerobin to connect to this domain, it failed. In flamerobin, i enter this domain name as a hostname in Server registration

Re: [firebird-support] Help, how to connect to firebird via Internet

2012-08-16 Thread Yanto asnawi
1. Test local conection first 2. conect to internet via modem/router ? 3. setting modem/router DMZ/virtual server to ip server? --- On Thu, 8/16/12, trskopo trsk...@yahoo.com wrote: From: trskopo trsk...@yahoo.com Subject: [firebird-support] Help, how to connect to firebird via Internet To:

[firebird-support] Re: Help, how to connect to firebird via Internet

2012-08-16 Thread trskopo
Thanks for your answer. Problem solved by setup a port forwarding on my router. --- In firebird-support@yahoogroups.com, Yanto asnawi yanto_asnawi@... wrote: 1. Test local conection first 2. conect to internet via modem/router ? 3. setting modem/router DMZ/virtual server to ip server?

Re: [firebird-support] Re: How firebird use indexes with inner join

2012-08-16 Thread Thomas Steinmaurer
No. IMHO, the optimizer is doing a good job. It uses indexes with a good selectivity and first horizontally filter table A by using A_IDX1 and uses that already filtered stream to join table B via index B_IDX1. Just for the records: Firebird can join two indexes on the same table via a

[firebird-support] Re: How firebird use indexes with inner join

2012-08-16 Thread leroyarnaud29
http://www.slideshare.net/ibsurgeon/undestandung-firebird-optimizer-by-dmitry-yemanov-in-english http://www.slideshare.net/ibsurgeon/firebird-costbased-optimization-and-statistics-by-dmitry-yemanov-in-english I'm afraid not that much help for newbies without the speakers voice. Thank

Re: [firebird-support] What is the maximum number of lines an SQL statement can have in FB 1.5 and 2.5

2012-08-16 Thread Thomas Steinmaurer
I have an application that builds dynamic queries for users as they progress through a series of forms and choose items to include. The query is then fed to and FB 1.5 database. I have a situation where the SQL statement causes an error, even though there does not appear to be anything

RE: [firebird-support] Transactions exception trapping

2012-08-16 Thread Rick Debay
The handler is not embedded in the loop that it handles: it follows directly after What I originally posted is exactly what our code looks like. The WHEN handler is the last statement INSIDE the loop. If an insert statement throws an exception, we see the loop continue and the exception logged.

Re: [firebird-support] What is the maximum number of lines an SQL statement can have in FB 1.5 and 2.5

2012-08-16 Thread Hannes Streicher
Guten Tag Thomas Steinmaurer, I have an application that builds dynamic queries for users as they progress through a series of forms and choose items to include. The query is then fed to and FB 1.5 database. I have a situation where the SQL statement causes an error, even though there

Re: [firebird-support] What is the maximum number of lines an SQL statement can have in FB 1.5 and 2.5

2012-08-16 Thread Thomas Steinmaurer
I have an application that builds dynamic queries for users as they progress through a series of forms and choose items to include. The query is then fed to and FB 1.5 database. I have a situation where the SQL statement causes an error, even though there does not appear to be anything

[firebird-support] Re: What is the maximum number of lines an SQL statement can have in FB 1.5 and 2.5

2012-08-16 Thread Craig Cox
Thanks everyone! That provided the answer I needed. --- In firebird-support@yahoogroups.com, Thomas Steinmaurer ts@... wrote: I have an application that builds dynamic queries for users as they progress through a series of forms and choose items to include. The query is then fed to and

Re: [firebird-support] Howto compile Firebird C-API examples

2012-08-16 Thread Tomasz Tyrakowski
On 2012-08-16 13:24, christian.moelders wrote: I am using Ubuntu 11.10 and try to compile the firebird C-API examples. I does not know what is wrong in my command: gcc -L/usr/lib -lfbclient -I../include api1.c Just put -lfbclient at the end and you'll be fine. cheers Tomasz --

RE: [firebird-support] Howto compile Firebird C-API examples

2012-08-16 Thread Leyne, Sean
Christian, -Original Message- From: firebird-support@yahoogroups.com [mailto:firebird- supp...@yahoogroups.com] On Behalf Of christian.moelders Sent: Thursday, August 16, 2012 7:25 AM To: firebird-support@yahoogroups.com Subject: [firebird-support] Howto compile Firebird C-API