I am trying to insert records into a table using the SQL syntax: INSERT INTO TABLE(Field list) VALUES(Value list). My code is choking on the BLOB field. I get the error:
SQLState: HY000
Na...
I have a table that contains a date of birth field - I now want to create a view that has the age based on current date - date of birth
How do I do this?
Thanks
Anthony
Hi all,
I've been struggling with this problem for some time, and thought the IB gurus here may be able to assist.
Basically, I have a table in an Interbase 6 database that contains two ...
How I can get a procedure return value after executing procedure on vb.
I Store some small values in a single CHAR column.
When i retrive these char values in my C# code I can easily convert them to numerical values.
I have to perform some operation on the char...
Hi,
I am trying to install Firebird 1.5.2 onto one of the users machines in our office and although the install appears to go perfectly whenever i try to connect to the database i get the e...
I'm using a firebird 1.5 database and am trying to remove all dashes from a field in one of my table's. Is there a command that will do this in SQL. Like replace '-' with ''. I want all the ot...
Hey Everyone,
I am running a Linux server and using InterBase 6.0. I've lost my SYSDBA password and I can use some help about how to reset the same. Is there any tool or command as such to ...
I need to attach to a .GDB database for the purpose of creating custom reports. I've attached to other databases before but just can't quite figure out how to do it for Firebird. I've googled ...
How do you select the Top n records in a query or Stored Procedure.
my current Stored Procedure is as follows:
create Procedure nspTopDTMAchines (TopRecords Integer)
Returns (MachineNam...
On Firebird which function we can use instead of to_date function on oracle.
Hi,
I've been using MS Access for 2 years as the database in my VB.NET applications.
I've decided now to use Firebird or Interbase.
Can someone provide me with code to build and use, ...
How can I get the MONTH and YEAR from a Date field in an Interbase database (I believe it's 7)
Hi all,
I am using Interbase 6 and 7.I can reproduce the problem in both versions of IB
I have columns of data type TIMESTAMP.
I have a java program for inserting records, it seems that...
hi,
I have a BLOB field in one of my table. Below is the script I use to create the DB:
CREATE TABLE FILES (
FILEID INTEGER NOT NULL,
BIN_DATA BLOB SUB_TYPE 0 SEGMENT SIZE 65536,
FILENAME...
Good day,
I need to do a select statement where I can format a Date Field to a string field in the format of yyyy/mm/dd.
I have created a work table where I insert values into, my work t...
I have a working select statement.
When I add the select statement to the insert statement, it gets a general SQL error "Select".
Insert into table(col1,col2,col3.....)
values(Select st...
Hello Interbase Experts,
On the PROD machine, due to management decision, we ended up replacing database server from Interbase 7.5 to Firebird Interbase 1.5.
We stopped the IB 75 Guardia...
Hello all.
We have a problem that we've been working on with a client for several months that we cannot resolve. The environment is as follows.
Server (not sure of server details, but a...
Is there a way for me to ignore the time of the timestamp typed field. This is my query:
SELECT Tbl.FLD_SESSIONSTART, COUNT(*)
FROM TBL_WEBSESSIONS Tbl
WHERE ((Tbl.FLD_SESSIONSTART >= '...
Hi,
I'm wondering if there is a way to update a table (tableA) with another table's values (tableB) where the ID's equal. For example:
TableA TableB
I...
Hello,
Does interbase has string functions?
Looking for something like :
select left (myvar,10)
or
select substring(myvar,2,5)
Thanks a lot,
Tanya.
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...
Hi all,
I want to connect an internase database using an ODBC DSN.
i'm creating the DSN file using call for the ODBCCP32.DLL
but wen i try to connect following error occurs
i'm using
...
I am trying to access an external function in Firebird, but get this error:
invalid request BLR at offset 59
-function CALCEXPR is not defined
-module name or entrypoint could not be foun...
