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...
I need to create a batch file that runs an sql query and prompts the user to enter in variables. Its really the simplest of queries.
update invoice set departmentid=1 where invoiceno=@userv...
Hello,
I have a query that picks out 1 random result from a table based on different factors; however, after that result is picked the field "Klubbint" needs to be updated to intklubb.capti...
Hi Experts,
I try to use a TIBEvents component but I don't know what kind of events are to be used. I have choosen logical events (for example EMP_NO>100) for the Events pro...
I need urgent help!! How do I extract data from Interbase 5.0 to Excel Spreadhseet?
Can you please provide details steps..I have no idea with Interbase 5.0. Thank you!
URGENT!!...
Hi
Does anybody know of a working backup scheduler for Firebird?
GBak is giving errors about gbak.exe missing.
I use this PROCEDURE to add new user.
I like to add GRANT statment to this PROCEDURE. (GRANT SELECT, UPDATE ON TBLCUST TO USER TBLCUST.CID;)
How can I do? I am using firebird 1.5.3
/* ---...
Hello,
when i try to limit my result set with the following query on a firebird database
SELECT FIRST 25 SKIP 0 IDARTICLE FROM ARTICLE1_1
then i get the following error:
SQL error cod...
Hi All,
I need to get all rows which expire within 30 days.
It seems like Firebird does not support GetDate() etc...
I was looking for something like this, for example:
SELECT * FROM...
I am trying to load a table that has about 150,000 records. At about 13,535 records, I get this message:
156 tBooksAdd(117CR11191) unable to allocate memory from operating system"
What ...
Hi,
The firebird database I had been running for a few months 24x7 now. I notice that the performance is degrading (slower data insertion) and file size is increasing quite a bit. I also no...
Ok I know this is a simple question, but after searching 4 or 5 interbase pdf files and google....
Can anyone please tell me how to do a LEFT JOIN in Interbase 5.5?
I am also using the...
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...
I'm trying to break apart a multipage tiff and have each page inserted into a firebird db as a separate blob for each page.
I've found examples of how to loop through each page of the tiff...
We have Interbase 7.1 installed on our server and need to retrieve, but not change, the SYSDBA password. Unfortuantely, there's software installed on the server that uses the current SYSDBA p...
Hi!
SQL has CASE WHEN statement, and it's very
efficent sometimes.
Interbase hasn't implemented it, anyway.
Do you know any workaround for this statement
in Interbase without using embe...
With SQL Server there is a way to send emails and other cool things is there a way to do this with triggers in EMS? Is there a way maybe to shell out another program?
Here is an Interbase backup dos.bat file I found. We do NOT have any Interbase.gdb database on our Windows 2000 server, only Interbase.ib or .ibu.......
Q. Can I use the following syntax to...
Good day
I am worried about database security issues.
I have just install my app and database at a client site. I am worried someone can copy my database and install fireibird on his/her m...
Hello, All
I use interbase and delphi fairly often. I am trying to insert a record into a table using a dataset and InsertSQL. The primary key (MID) uses a generator and trigger
begin ...
I'm looking to move a datbase project from desktop applications (which I am vastly familiar with) to web based (not so familar). I've got my database defiend, I've got the connection where the...
I am still working on my conversion of the SQL Server Express database to Firebird. In MS SQL, you can use the percent % sign as a wildcard in WHERE clauses.
What is the equivalent in Fir...
Good day Experts
I have a table with the following data.
Id DateFrom DateTo
1 10/03/08 12/03/08
2 15/03/08 18/03/08
3 15/03/08 17/03/08
I want...
I have a C# program that uses Firebird. I just installed 2.0.5, and now it's telling me that the user doesn't exist (it must have replaced the Security2.fdb file). From the C# program, I use...
I'm working w/ Interbase 7.5 for the first time, and all I can say is I didn't realize what I was missing out on before. I have a TIMESTAMP field, and the CURRENT_TIMESTAMP, and I'd like to k...
