[firebird-support] XE4, Interbase Express, 32/64bit, Firebird 2.5.2

2013-06-24 Thread ma_golyo
Hi! Are there any known incompability issues? Thank you!

[firebird-support] Server specs

2013-06-24 Thread Mags Phangisa
Hi everyone, I have a web-based application (front-end in PHP). One of my clients has about 6000 locations but between 1000 and 1500 will be connecting at the same time at any given stage. Most transactions will be selects for reports on a daily basis and inserts (with file attachments) will

Re: [firebird-support] XE4, Interbase Express, 32/64bit, Firebird 2.5.2

2013-06-24 Thread Alexey Kovyazin
Hi! Firebird and InterBase are different databases. Regards, Alexey Kovyazin IBSurgeon Hi! Are there any known incompability issues? Thank you! [Non-text portions of this message have been removed]

[firebird-support] Re: XE4, Interbase Express, 32/64bit, Firebird 2.5.2

2013-06-24 Thread ma_golyo
I'm aware of that. We're using Firebird (since 1.5.0 up to the latest 2.5.2) + IBX (Delphi 7) without problems. Currenty I'm testing XE4 with the latest IBX. My first tests are working with no problem both on x32 and x64. So maybe its officially not supported. I'm interested in unofficial

AW: [firebird-support] firebird sql alias for condition

2013-06-24 Thread Olaf Kluge
Hello, thanks @ all. I just have one question. One dataset includes a date + time to switch on and a date + time to switch off. I would like to get the timestamp next time on and next time off. In the simplest case both times from one dataset are in the future. Now it can be, that the

AW: [firebird-support] Check previous records in the table before table update

2013-06-24 Thread Olaf Kluge
Hello Kukiejko. You mean that you can only update a dataset with time is not null? First, you should not use a column-name like time. In this case you mean ID 233 is possible and ID 234 not? If you use a trigger, you'll never can update the time-column because it is never possible if the old

RE: [firebird-support] firebird sql alias for condition

2013-06-24 Thread Svein Erling Tysvær
One dataset includes a date + time to switch on and a date + time to switch off. I would like to get the timestamp next time on and next time off. In the simplest case both times from one dataset are in the future. Now it can be, that the next time to switch on listed in one, the time to switch

[firebird-support] Can I use any version of gbak to backup/restore any version of firebird database

2013-06-24 Thread Chee Yang
Each release of Firebird has it own gbak.exe. I am just wondering if I can use any version of gbak to backup/restore any version of firebird database? For example, can I use gbak.exe from Firebird 1.5 to backup/restore Firebird 1.5/2.0/2.5 database? Or can I use gbak.exe from Firebird 2.5 to

RE: [firebird-support] Check previous records in the table before table update

2013-06-24 Thread Svein Erling Tysvær
I use Firebird 2.5 for Windows. I need to create UPDATE TRIGGER for Table A, but UPDATE for the Table A for row ID=x is only possible if TIME column for IDx is not [null]. For example I can update Time column for row ID=234 but it should be not possible to update Time column for row ID=235.

Re: [firebird-support] Re: XE4, Interbase Express, 32/64bit, Firebird 2.5.2

2013-06-24 Thread Iwan Cahyadi Sugeng
If you are using just standard query, you might be able to force using ibx, but i suggest you changed it to FireDAC or dbexpress, it has much better support for firebird spesific syntax. On Mon, Jun 24, 2013 at 5:02 PM, ma_golyo ma_go...@yahoo.com wrote: ** I'm aware of that. We're using

RE: [firebird-support] Re: XE4, Interbase Express, 32/64bit, Firebird 2.5.2

2013-06-24 Thread Maya Opperman
If you are using just standard query, you might be able to force using ibx, but i suggest you changed it to FireDAC or dbexpress, it has much better support for firebird spesific syntax. Or FIBPlus (which is based on the original IBX source code so is quite similar), or IBObjects.

[firebird-support] Disconecting the shadow

2013-06-24 Thread Aldo Caruso
Hi, I had a database with its shadow in a secondary disk. Suddenly, the secondary disk failed and became unavailable. I tried to disconnect the shadow from the database using the gfix -kill option in order to continue to use the database. It run at once with no output error, but

[firebird-support] Re: Can I use any version of gbak to backup/restore any version of firebird database

2013-06-24 Thread Chee Yang
Hi Dmitry, Thanks for your clarification. I try to explain to you why I use gbak. My application use to work with Firebird 1.5, 2.0, 2.1 and 2.5. Before Firebird 2.5.2, the only way to get firebird database backup from remote server is thru gbak. The Firebird Service Manager doesn't