Hello... I just did an install of Firebird 2.0.3. I am following the installation instructions, and where it tells me to use the gsec command to verify that it was installed properly, I'm get...
Hello I have a problem with update text in ib 5.6
read is no problem.
first I tried this:
Set RS=myadoDBconn.Execute("UPDATE PMMEMO SET TEKST='jaap'")
I get the error
Error Type:
...
Hi! I am new to Interbase / firebird.
I wonder, if I need to use Ib for multiuser database, do I need to assign each user a user name & password? and how can the user change his / her passw...
hi interbase experts,
i have developed an interbase 5.5 application with delphi.
now a customer installed another software,
which uses firebird (v6.2.2).
since this installation the...
I have installed Interbase 7.1 on Linux.But I can't start the Interbase server using Ibmgr -start'. There are some information in the Interbase.log:
localhost.localdomain(server) web nov ...
Hi, Folks!
I would like to know some good(free) tools for modeling compatible with FireBird.
Regards!
Hederglan
Hello, I'm just looking for guidance on the best way to achieve a
desired result on a Firebird 1.5 server.
First I'll describe the situation:
- I Have two main tables A and B Joined on a ...
Hello, does anyone know a place to seek for
good documentation on clustering a Firebird DB on linux using
shared storage (scsi disk array)?
What I'd like to do is a fail over configuration,...
Good day,
I need the following returned from a procedure. There a two tables involed.
Here is a example of the data how I need it.
Week Owner Date Guest Nights
01 aaaa ...
On of the table from DB in Delphi is damaged. How repare th table. Table cannot be opened. Message: Header damaged, Table/Index. I tried to open in Delphi Database. But I cannot open due to th...
org.firebirdsql.jdbc.FBSQLException: GDS Exception. 65. internal error
I am using JAVA as following.....
FBBackupManager fb = new FBBackupManager();
fb.setUser("sysdba");
fb.setPasswor...
Good day
I have the following Sp
CREATE PROCEDURE SP_TEST
RETURNS (
VAL CHAR (10) CHARACTER SET WIN1251)
BEGIN
/* Procedure body */
Val = null;
for
select
Tit...
I want to programmatically restore a database; to do so, I have to disconnect from the server. How do I do that?
Hi
I've got a client app written in C++Builder 5 using IBExpress components
(5.02) to talk to a Firebird SS database (1.0.0 I think) running on RedHat
7.1
Everything works fine until t...
Hello, I need your help, I have problems with dates, do you know how can i get the actual date from BD,
select Cast("TODAY" as DATE) from mybd.mytable
I'm using Interbase 5.0
Does Int...
I'm using a Domain to define money fields in tables as follows:
CREATE DOMAIN "MONEY" AS NUMERIC(15, 2);
The large number of digits are needed to track corporate total yearly sales, e...
If I connect to a remote server, then create a new database I would like it registered with the remote server.
If use TIBServerProperties then FetchDatabaseInfo, how do I get the new datab...
When I try to connect to my Interbase database using server manager on Win NT I get this error : "unsupported on-disk structure for file <path> found 10, support 9". What does it mean? Thanx ...
Hi,
what is the equivalents of ORACLE NVL(Field,0) in Interbase
Hi there,
I have a couple of tables that have duplicate records.
I do NOT want to delete the duplicate records.
All I want to do, is add a primary key to the table so that the records c...
I would like to know if there are any relevant settings to manage/improve the performance of Interbase (both on the server and client side). I have an application with over 25 concurrent conne...
Hello Experts.
1. I've downloaded Firebird-1.5.0.4290_win32.zip.
2. Unpacked it on my Windows 98 to D:\download\FireBird\Firebird-1.5.0.4290_win32.unpacked
3. Ran: install_classic.bat fr...
The following statement
String q3 = "insert into gr_longtext (longtext_id, longtext_reference, longtext_order,
longtext_value) values ('297e734c0648bf13010148c1ee180046', NULL, 0, '}{tiles.m...
I am trying to declare some of the UDF's from the IB library here is the SQL I am using.
DECLARE EXTERNAL FUNCTION div
INTEGER, INTEGER
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT ...
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...
