firebird2.1 Questions

7

I have installed Firebird 2.1 on windows Xp and using firebirdsql.jdbc-2.1.6 driver to connect with java. Code: Class.forName("org.firebirdsql.jdbc.FBDriver"); connection = DriverManager.getConn...
Teleprinter asked 6/8, 2010 at 13:28

1

I am having fb remote event with which I listen to database and I start it with my app load inside thread. When I run it on my Windows 10 (local pc) it works normally and perfect BUT when I run it...
Dowling asked 26/6, 2018 at 13:4

1

Solved

Say I have a table with the following data: Now I want to filter by the primary keys department and number. I have a list of department and number combinations that have to be filtered in code. ...
Menagerie asked 16/5, 2017 at 9:27

2

Solved

I have a production database, using Firebird 2.1, where I need to find out how much space is used by each table, including the blobs. The blob-part is the tricky one, because it is not covered usin...
Depside asked 13/9, 2010 at 11:23

2

Solved

I want to return the error message from a procedure when an exception happens. In SQL Server you would select the Error_Number() and Error_Message(). How would I do it in FirebirdSql SET TERM ^ ; ...
Penny asked 12/12, 2013 at 21:59

2

Solved

I have 2 fdb databases company.fdb and timeAtt.fdb company.fdb contains staffDetail table staffId - 001 staffName - Andy staffStatus - Active timeAtt.fdbcontains staffAtt table staffId - 001 s...
Cimon asked 19/5, 2015 at 8:54

3

Solved

I'm using Firebird 2.1. There is a table: IDs, Labels There can be multiple labels for the same ID: 10 Peach 10 Pear 10 Apple 11 Apple 12 Pear 13 Peach 13 Apple Let's say I have a set of label...
Jointress asked 5/9, 2014 at 16:5

1

Solved

Can we do bitwise and in a firebird procedure without using a UDF? is there one of the built in function or is there a way to get the same results with standard built in commands? I tried http://w...
Irvingirwin asked 13/9, 2011 at 13:58

1

Solved

I'm using Firebird 2.1. There is a table name Folders, with the fields: FolderID ParentFolderID FolderName ParentFolderID is -1 if it's the root folder -- otherwise it contains the parent folde...
Kun asked 5/7, 2011 at 16:6

3

Solved

Consider this table (from http://www.tizag.com/mysqlTutorial/mysqlmax.php): Id name type price 123451 Park's Great Hits Music 19.99 123452 Silly Puddy Toy 3.99 123453 Playstation Toy 89.95 123...
Athirst asked 23/5, 2010 at 23:18

2

Solved

I want to disable all Foreign key constraints and re-enable them after, is there some way to do that? I know that SQLServer allows that, but what about Firebird?
Aweather asked 30/6, 2009 at 13:13
1

© 2022 - 2024 — McMap. All rights reserved.