Hi,
I just installed FireBird2.0.4 and it has a funny behaviour. Somewhere in my application there's a pretty long transaction. The commit at the end of it about half the time (irregularly)...
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 a C# program that uses gsec.exe to set the user id and password. Under Vista, it shows up as not found, although the user says it's there... code snippet is below...
Any ideas why?
I would like to insert SQL error message in a log table within a stored procedure.
For example, I would like to know which columns causes error -625, and I only know that the error message co...
I have tried to add a role the a Firebird 2.0 DB. I keep getting this error:
ISC ERROR CODE:335544351
ISC ERROR MESSAGE:
unsuccessful metadata update
user name CHRONICLEALLACCESS could ...
Hello there.
I was working on Interbase 5-dot-something and the ISQL program promted me with some sort of interactive window, on the upper side was the space to enter SQL statements and on t...
Because the TYPE of the column PROCEDURE_ID in the Interbase's system table "RDB$PROCEDURES" is SMALL INT.
After a long time operation like "create procedure ..." and "drop procedure ....". T...
Hi, how can I set "ageneratorname" as a parameter for GEN_ID-routine. I have a lot of dynamically created tables and I hoped I could create only one stored procedure that can be used for reque...
My application uses Interbase 6. When it is installed in XP - it repeatedly gives a database error and it cannot find the server path - even if it is hardcoded.
Any solutions?
I need to upgrade my existing interbase db to unicode compliant, which is CHARACTER SET UNICODE_FSS stuff.
Are there any scripts to run for upgrade??
Are there any manual SQL commands to r...
Hi All,
What is the best book that I can Learn Using Interbase With delphi and working with interbase
Best Regards
Osama
I have 2 tables in a Firebird 1.5 database such as:
TABLE1
F1 F2 F3
============
1 AA 00
2 BB 10
3 CC 15
4 DD 20
TABLE2
F1 F...
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 ...
Hi,
I am using Delphi 7 with IBX and Interbase 6.0 Open Source
I have a program which needs to submit around 25 records consecutively
Here is some example code
DS1 is an IBX Datas...
Hi,
I am using firebird as a embedded database in c#.net desktop application.
I have SELECT and UPDATE queries of more than 100 fields for a table. It has no relations to any other table...
Just installed firebird and now everytime I try to access my database it says no username and password defined and I need to setup on up. Any ideas?
Hello all,
We are currently using a application that is using Interbase as its database. The problem that were having is that the database itself uses so much CPU and memory that it actuall...
Goodmorning,
I hope someone can help me with this, i am connecting to an embedded firebird database
via .NET 2.0 using FirebirdSql.Data.Firebird and my connectionstring is as follows
S...
I have two servers one is running firebird (on linux) and other have Oracle (on windows), firebird ODBC installed on windows(oracle) system.
Problem when we fetch data from firebird through...
Hi (basic I know, but frustrating) Just starting to port a Database over from SQL Server 2k to Firebird. (Some customers wont pay for SQL Server... so what can you do?.... I hope Bill is list...
Hi all,
I'm trying to create an index in interbase 7.5 but i'm getting an error. Is there any setting I can change which would allow me to create an index on this large column?
CREATE IN...
I've ported my Paradox database to Firebird and some instructions recommended that I make all Boolean fields a
DOMAIN called T_YESNO of type CHAR.
But how does thie help solve the problem...
Good day
I would like to know how can I do the following subquery.
I have two tables and my data looks like this
Table A
Suite [PK]
Week [PK]
RoomStatus
Table B
Suite [FK]
W...
Hello all,
Need help in getting a query to work. In order to get the 'value/result' I want I need a result which is based on two tables. I have tried several different alternatives, but fai...
I need to be able to pass in multiple values into a single parameter.
Example
Select EmployeeName
from employee
Where EmployeeID in (:ParameterValues)
Output would be multiple Em...
