... No, it shouldn't. Fetch from empty result set doesn't change value of bind variable, so M_VAL_B still keeps value 80 from previous iteration. -- SY, SD....
Yes, I've noticed that after sending the email....but I was misled by the IBExpert procedure debugger by replacing M_VAL_B with NULL on the second iteration,...
... Get a better debugger ;-) With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server,...
... Yes, you can use RAID 0 or RAID5 or if you use Linux, you can also use LVM2. If downtime is important, use some filesystem that can grow while mounted,...
Hello, I have a currency's table and a history of how the value of each currency changes. I need to select all the currencys (they are less than 10) plus the...
... Hi Sergio! Firebird doesn't know that all currencies are likely to have changed lately and thus be early in the index. If the descending index had been on,...
Hi, I have installed Firebird CS 1.5.3 from package, all binary work well, but when I run isql I get error: "exec(): 0509-036 Cannot load program ./isql...
Hi All, Hope I'm doing this right ;-) We have a few sites, which are getting repeated index corruption (being an accounting application, noticed when the query...
I need to hot backup large Firebird databases to other physical locations. This databases are in LVM partitions. It's safe to snapshot the filesystem and copy...
Guten Tag Christian, ... NO , data keep in Memory may not be flushed out to disk yet , or still halfway thru ... Yes 100% -- Mit freundlichen Grüssen Hannes...
... But I have forced writes on, doesn't firebird flush writes when commit to have consistent transactions writed to disk? I was thinking that LVM is aware of...
2010/3/19 Christian <c_pradelli@...> ... Still you can corrupt your database, like say the previus mail. Check this faq (is safe to copy the database...
Hello Christian, ... i would not bet my data on that there are two right ways to do it a) backup, copy Back , and restore on the other end b) use replication ...
... hello! AFAIK, validating and fixing is a prepares to backup/restore. If you did it (like gfix -mend) you will need a backup/restore after. So it will not...
... A direct copy from an LVM snapshot should be OK, as long as you specify forced write and your hardware supports a real forced write. Firebird uses careful...
Can i insert to table without adding any field, there is fields in table take its values from triggers INSERT INTO TABLE or INSERT INTO TABLE RETURNING ID ...
Hello, I have a problem: FB 2.0.3, ODS 11 I have a BLOB SUB_TYPE 1 CHARSET UTF8 field. Data are stored in UTF8 format. In client application (IBX) I'm using...
Hi, I am trying to install multiple servers which listen to different ports on a single machine. Like so .... Install directories, /opt/firebird-1 with...
... Hi Set!! Thank you very much for your input! Thinking in your last idea I did this: 1. Add a new field into MONEDAS: CREATE TABLE MONEDAS ( [...] ...
Hi ... system or disk controller will not be consistent either. Usually right, but LVM snapshots are software-based snapshots and will therefore not suffer...
HI ... Can you explain this? I would like to understand the problem you are mentioning, as I do that frequently. Regards, Steffen [Non-text portions of this...