Thanks for the quick reply.
This is the create sql of the table PHONE:
CREATE TABLE PHONE(
PHONE_ID INTEGER NOT NULL,
PHONE_NUMBER VARCHAR(100),
UPDATED_DATE INTEGER,
EFFECTIVEFROM INTEGER,
EFFECTIVETO INTEGER,
OBJECTID VARCHAR(25),
MODE SMALLINT,
DEFAULT_EMAIL
Den 2012-02-24 10:13 skrev Bart Smissaert såhär:
I think I have figured this out now and it was just a display problem
to do with
Excel making numerics from text, so not showing a trailing or leading
space.
I've been working VERY MUCH with database data and Excel, by copying and
pasting
Can some problem exist when creating 2 indexes of the same records?
CREATE UNIQUE INDEX FK_SCEMMES_A ON SCEMMES (IDAC,IDREG,NUMC);
CREATE UNIQUE DESCENDING INDEX FK_SCEMMES_D ON SCEMMES (IDAC,IDREG,NUMC);
I make it because I need values max
select max(m.numc) as numc from scemmes m where
Hi!
This is a new one for me: I have a Firebird 2.5 database file with
corruption not in records, but in table structures themselves. After I
used GFIX -v -f, GFIX -m and backup/restore, I am left with a
database which basically works, but as soon as I try to access certain
tables, I get an
On 23.02.2012 19:23, Sergio Garcia wrote:
Hi. We created a DB with UTF8 as Default character set (SS v2.5.1.26351). In
FlameRobin we see the data correctly (Canadá), however from the Delphi (v6),
using native controls at palette Interbase, the data is not displayed
correctly (Canadá).
Hi,
I migrated from Firebird 2.0 to 2.5
The databas has a VIEW wich basically selects two fields: CODIGO (
Integer ) and NOMBRE (Varchar 50 ) from a table.
When in Firebird 2.0 there was no problem running SELECT * FROM
VIEW_NAME
Now, in Firebird 2.5 I got the following