Hello,
are there any restrictions for tables regarding field count and/or count of
fields with a certain datatype?
For instance:
would it be problematical to have a table with let's say 170 fields, 40-60 of
which are blob fields of subtype 0?
Also considering the recordcount, so that once
-- Original Message ---
From: patrick_marten patrick_mar...@yahoo.com
are there any restrictions for tables regarding field count and/or
count of fields with a certain datatype?
For instance:
would it be problematical to have a table with let's say 170 fields,
40-60 of
Configuration:
- Windows 7 64 Bit professional SP1 NL
- Firebird 2.5.1 64 Bit
Table:
CREATE TABLE TEST
(
TESTID INTEGER NOT NULL,
NAME VARCHAR(40),
CONSTRAINT TEST_PK PRIMARY KEY (TESTID)
);
2 records:
insert into TEST (TESTID, NAME) values(1, 'EEN')
insert into TEST (TESTID,
On Wed, Jun 27, 2012 at 12:22 PM, roydamman dam...@wxs.nl wrote:
2 records:
insert into TEST (TESTID, NAME) values(1, 'EEN')
insert into TEST (TESTID, NAME) values(2, 'twee')
First query:
select TESTID, NAME from test order by upper(2)
Answer (As expected):
1, EEN
2, twee
Second
I have converted 2 attributes on table from timestamp to time format, yesterday
. Engine didn't complain on that .
I'm trying to restore last night backup from Flamerobin and getting the
following error:
Database restore canceled 01:43:40 PM due to IBPP exception:
*** IBPP::SQLException ***
--- In firebird-support@yahoogroups.com, Ann Harrison aharrison@... wrote:
On Wed, Jun 27, 2012 at 12:22 PM, roydamman damman@... wrote:
2 records:
insert into TEST (TESTID, NAME) values(1, 'EEN')
insert into TEST (TESTID, NAME) values(2, 'twee')
First query:
select TESTID,
Hello, roydamman!
r Maybe I am wrong but I always thought the order by is applied on
r the results of the two selects in both the second and third union query. And
the order
r by clause does work in the second query (also an union query)
r order by 2 and does not work in the third query order by