This query uses natural for both tables, when I expected it to use an index for the join. select * from table1 t1 join table2 t2 on t2.indexed_char14 starting...
I have installed the latest 64-bit Firebird ODBC driver on a Windows 2008 R2 Server. My target database resides on this box as well. I have configured and...
Hi, I am using some tables (like sybase's temporary table) for report generation purpose. I usually delete all records from the table on calling the SP and...
Hi! When I run my UDF (udf_op), I get an error : "Bad written UDF detected: pointer returned in FREE_IT function was not allocated by ib_util_malloc"; I use...
Hi, I'm looking for suggestion as to the best way to monitor my installations for slow queries, etc the only options I have been able to identify is to write...
Hi guys, I am trying to setup a connection from flamerobin in window to Firebird installed in CentOS when I want to change password masterkey from username...
Hello We are trying to migrate some existing users to the new RDB$ADMIN using some dynamic SQL. We have the following SQL for --Gets a list of users from our...
Hello, it is possible to select the column by column-number? For example: Column1=ID, column2 = name, column3 = address. And now: "select column(2), column(3)...
Hello everybody I have (or had) a role calle R_ADMIN, I don't know, because when I write: DROP ROLE R_ADMIN Appears the message: "Statement failed, SQLSTATE =...
Hi all I have Parent-Child tables that contain Price List and are updated with the same items in them but with either a later date or a later batch no. filled...
Hi! I feel a bit overwhelmed by user rights in a database in respect to stored procedures. I have a database owned by user OWNER. I want to give limited access...
Hi all Can I use a CASE WHEN in the WHERE for a statement as below? The idea was to either pull out records from the tSaleInvoice based on a list of PKs in a...
Hi all I have tried the following query SELECT tSaleInvoice.* FROM tSaleInvoice WHERE tSaleInvoice.iID IN (SELECT tSaleInvoiceCvrLtr.cSaleInvIDs FROM...
Hello, I have tried various ways of connecting (Google) to an embedded firebird database and I just can't seem to get the connection string correct. Such as: ...
Hello guys, I developed application from Visual Basic 6 and created a database from firebird 1.5, I have installed embedded server 1.5,but i don't know how to...
I am running with 2 Firebirds, FB 2.0 in the 3050 port and FB2.5 in the 3051 port. When I create a ODBC connection, in the database path of the ODBC 2.0 driver...
Hello, i want to permit user to store their objects with price in their preferred currency. this is not a big problem, but i also want to permit users to...
Tools: Delphi 2006, IB Objects 4.9.14 Query: SELECT (COUNT(*)+0.00)/2 as "LabelsCount" FROM LABELS previously worked. Now I get an error: Invalid expression in...
Hello, Is it possible via the api to shard a database ? I mean to split the database in several database (this we do manually), and call the SQL in parallele...
Hello friends, I have a strange performance problem with fb 2.5.X. My friend told me that a program that he uses is working faster when database is on Windows...
Hi everyone, The following query works fine when called from the application: "SELECT MBRID,POLNO,PTYPE,BNKDT,AMUNT,ERROR,RECPT from PYMT where BNKDT>='$sttdt'...
Hi, I have an application which executes a stored procedure in Firebird 1.5.6 on a fairly regular basis (multiple times per day). Immediately following a...
I was wondering if there was any way to determine if there is a pending transaction outstanding. I have a single connection to a database and have something...
If B_TABLE.VALUE2 never contains 'X' and half of A_TABLE.VALUE1 are 'Y' what would be the cost of executing this statement? A_TABLE.VALUE1 is indexed and...
Hello, I've an old Firebird 1.5 database that has in one of its tables a field defined like this: ... myfield BLOB SUB_TYPE TEXT SEGMENT SIZE 512, ... The...
OK it's been probably 10 years since I played with some of this stuff. SO I need a bit of a sanity check. I'm running PHP most of the time, although the old...
Hi - I recently upgraded to RAD Studio XE2 and was daft enough to isntall Interbase (thinking it may solve a problem I was having with an Embecardo program.) ...
