firebird2.5 Questions
3
Solved
I am extending the data layer of an existing application to work with Firebird 2.5, in addition to SQL Server and SQLite, but I have hit a stumbling block.
I have a field called TimeStamp which sto...
Smithereens asked 26/11, 2009 at 0:10
2
Solved
I'm very new to WPF and the EF, and I'm trying to display some data from a table in a datagrid. I've got the entity model pulled from an existing database and simple operations seem to work (gettin...
Thapsus asked 12/11, 2010 at 19:4
2
Solved
How to check in which server mode (e.g. SuperClassic or Superserver) a Firebird database is running?
The latest Firebird 2.5.x database can run in either Classic, SuperClassic, or SuperServer mode. How can I check in which of these modes an installed database is running?
Aitch asked 6/3, 2013 at 11:15
3
Solved
How do you get a list of the column names in an specific table?
ie.
Firebird table:
| name | id | phone_number |
get list like this:
columnList = ['name', 'id', 'phone_number']
Ivie asked 8/10, 2013 at 21:25
2
Solved
I have a large query in Firebird (which I run using FlameRobin), using a parameter all over the place, but getting the query below to run will do:
SELECT * FROM customers WHERE customerid = 1234;
...
Seidel asked 10/10, 2013 at 14:0
2
Solved
I'm trying to setup a local firebird instance to test against but am unable to connect to it with even ISQL. I have tried to following by following the quick start guide here:
CONNECT ..\examples\...
Churning asked 17/3, 2014 at 17:16
6
Solved
How to split comma separated string into strings inside store procedure and insert them into a table field?
Using Firebird 2.5
Incarnadine asked 8/11, 2011 at 20:12
1
Solved
I'm not sure if this is a ColdFusion 2018 bug, or if it is something in the way ColdFusion 2018 implements the Jaybird 2.2.10 driver for Firebird 2.5.
I have a table that which contains a column n...
Nickell asked 2/10, 2019 at 20:30
2
Solved
I am trying to update table A with data from table B.
I thought I can do something like this
update A
set A.DISCOUNT = 3
from INVOICE_ITEMS A
join ITEM_PRICE_QUNTITY B on A.ITEM_PRICE_NO = B.ID
...
Novah asked 17/7, 2014 at 9:55
3
I've installed Firebird-Server 2.5 on FreeBsd 9.1 using:
pkg install firebird-server-2.5.2_1
It's working ok, since I can connect using FlameRobin from an external PC.
Now, when I try to restor...
Microfiche asked 27/6, 2013 at 22:23
4
Solved
I'm trying to create a Firebird database in my home directory through Flamerobin however I always get
*** IBPP::SQLException ***
Context: Database::Create
Message: isc_dsql_execute_immediate faile...
Glazing asked 29/4, 2015 at 11:40
5
Solved
When should I use index on table?
From how many rows index makes sense?
If I have table with constant rows, just edited come columns (not in 'where' clause), makes index sense even if table has j...
Skewness asked 16/8, 2012 at 9:50
8
I'm using Firebird Embedded v2.5. How to use procedures in query (SELECT) ?
My procedure:
SET TERM ^ ;
CREATE PROCEDURE FN_TEST( Y INTEGER )
RETURNS( X INTEGER)
AS
BEGIN
X = Y + 1;
END^
SET TERM ...
Unflinching asked 3/3, 2011 at 8:3
2
Solved
I am hacking around with IBPP on Visual Studio 2015 / VC++. IBPP is a c++ wrapper for the firebird / interbase API.
IBPP, a C++ Client Interface to Firebird Server
Part of this package is a little...
Kuehl asked 19/3, 2017 at 17:31
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
1
Solved
I'm trying to add a column to a firebird table. The column should have a default value 1 but initially for already existing rows the value should be set to 0. And that should happen in one transact...
Tungstite asked 1/7, 2016 at 14:43
1
I have a table with roughly 246k records. It has about 25 columns, all are integers except one small blob.
If I Query the table on all fields
select a.recordid, a.editcount, ect.. from ARTrans a
...
Fornof asked 15/1, 2016 at 17:2
3
Solved
In have table called "MYGROUP" in database. I display this table data in tree format in GUI as below:
Vishal Group
|
|-------Vishal Group1
| |-------Vishal Group1.1
| |-------Vishal Group1.1.1
|
|...
Teirtza asked 2/10, 2015 at 5:58
1
I want to build a connection between ODBC and Firebird. It has shown error messages like these:
[ODBC Firebird Driver] Unable to connect to data source; library'gds32.dll' failed to load
[...
Roundsman asked 6/5, 2015 at 1:53
1
Solved
It's a pretty straightforward question. Firebird has a backup tool called nbackup whereas you can make incremental backups.
The tool complains if you don't make the backup in the correct order (e....
Culminate asked 28/8, 2014 at 18:1
1
Solved
Is there a posibility to change the SUBTYPE of a BLOB field ?
I have a BLOB with SUBTYPE BINARY an need to change it to SUBTYPE TEXT, because i get some strange Characters into the BLOB and in a B...
Irradiate asked 18/7, 2014 at 6:41
1
I have two tables AUTHOR and BOOK connected by AUTHORID.
I need to create a trigger that in case of deleting an author, it deletes the books by that author first and after that deletes the author....
Depolarize asked 17/12, 2013 at 17:56
1
I use Delphi 2010, Firebird 2.5.2, IBExpress components.
Database charset is UTF8. In db-connection UTF8.
Database:
var
Database: TIBDatabase;
begin
...
Database.params.Clear;
Database.par...
Coppock asked 30/5, 2013 at 10:53
1
Solved
I see strange result when executing this query
update sd_invodt set line_type=iif(is_promo=1, 'campaign', 'item')
The value in line_type field will be "item ". There are whitespaces in value.
B...
Toiletry asked 2/11, 2013 at 5:42
2
Solved
I need to get all the values which changed in a row and post modifications on other 'audit' table. Can I accomplish this, without writing the conditions for each element from the row? I know the SQ...
Chloramphenicol asked 3/10, 2013 at 10:56
1 Next >
© 2022 - 2024 — McMap. All rights reserved.