Hi i get this error (SQL Server Error: Invalid request BLR at offset 1015 column OBJID is not defined in table RDB$PAGES) when trying to execute query in delphi using TSQLQuery. Have anyone ex...
Hi,
If I need to obtain the list of tables, fields for a given table, list of views and list of stored procedures for an Access database using an OleDb connection, I use the following funct...
What is causing the above error? I have installed both client and server (SuperServer) on user's machines, and I see this error often.
Just installed Firebird ODBC driver 1.2.0 on Windows XP Pro Sp2 laptop without a Firebird Server.
An trying to open a Firebird Database thru Excel 2000 using MSQUERY and Firebird/Interbase ...
I have a trigger for saving the changes into a history table.
For DELETE and UPDATE i use the context variable "old", and for INSERT i have to use the "new" context variable.
I want to ...
Hi Xperts,
I'm having an SP which do
SELECT * from TBL_NOTE Where Note_ID = 1 FOR UPDATE WITH LOCK
and even I lock the record, I need to just read the entire table just to display its ...
I need to deactivate a trigger, upload data and then reactivate the trigger. I want to do everything with a stored procedure, but I get a sintax error. Is it possible to deactivate/reactivate ...
Hello,
i want to install firebird server on remote computer (not on other lan computer). Firebird database server would be in one town and my client program connect through Internet to it. I ...
I try to make procedure SQLScript (using Firebird 1.5, Linux) for executing multiple sql insert/update statements on low speed network.
Usage: execute procedure SQLSCRIPT('insert into aaa (1...
Firebird apparently does not have a function to find one string inside another. How do I implement this? I have the Free_UDF library (FBUDF.dll) loaded into Firebird.
Example: How would you...
Is there any GUI front-end for working with FireBird Database?
Good day
I would like to know if it is possible to select data from more then one database if I work in one connection currently.
In sql server I think the syntax is as follows
select ...
Hi,
I want to know if is there a way to import data from an sql or access database to a firebird db.
Is there any software that can automatically do that or maybe i have to extract to an e...
What is the syntax/method used to insert a field type blob into a table using SQL?
Hi,
I've several tables linked by foreign keys with Delete Rule restricted.
When I call a stored procedure within a transaction I delete the recors of the child tables first and when I delet...
I hava a table that has a field name Date_Time, it´s type is TimeStamp. In the field it has the Date and Time. I want to do a SQL to delete everything where the Date is smaller (<) then 2/4/20...
Hi fellow experts.
Is it possible to do crosstab/pivot style queries using Firebird?
If not, what is the best way to achieve similar results(are stored procedures my only option?)?
Re...
I have a .GDB database which i want to transfer to Excel. I dont have Interbase installed and I dont have any knowledge of Interbase.
I have setup an IIS web server on Windows Server 2000 and have installed an Interbase server on it. Could someone help me out with the settings I need to make to the server/client in order to ...
Hi,
I'm writiing a php script which will connect to a firebird server(all Linux). Firebird client is already installed on the webserver hosting the php. I need to configure PHP settings or ...
Hi experts,
A quick question. How do i use firebird gbak with delphi? i use firebird 2, delphi 7 and embedded firebird dll
Thanks.
Hi Experts
I'm not sure if this is the right forum to be asking this in, but I thought it looked the most appropriate. I've used a query similar to this successfully in MySQL, but I've been...
Whenever I try to run the interbase commands gfix or gbak in a command window against a database on a w2k3 server, I get the message "unavailable database".
The database exists, Interbase i...
I have a software that uses Borland interbase 7.1 as its database engine. But in windows vista the interbase does not work properly. In the interbase manager, when I switch off the option "Run...
Hi, Im trying to update one table with values from another:
update DetailLine set DetailLine.Price = (select Item.Price from Item where Item.ItemCode = DetailLine.ItemCode) where DetailLine.Q...
