... Next time just replace security database file with fresh one (from installation). ... The message"unavailable database" does not mean that database file...
I think this is all wrong and I hope the next version takes these comments into consideration. For a long time I have created DBs with non-SYSDBA ownership. ...
... Why? ... Well, if you must...you drop the constraint. Obviously, you will have to drop any referencing foreign key constraints first. But what do you...
Dear colleagues! I am glad to present to you the first issue of "The InterBase and Firebird Developer Magazine". It is a free electronic magazine in PDF. You...
... I think condition ("LogDate" BETWEEN 'Date1' and 'Date2') AND (("Field1"='String1') OR ("Field2"='string1')) will hardly use "LogDate","Field1","Field2"...
Guido, ... OK, then the bad table may be one of the user accessible system tables. I'd try select count (*) from RDB$RELATIONS, the RDB$RELATION_FIELDS, the...
... If this part of your query is reasonably selective "LogDate" BETWEEN 'Date1' and 'Date2' than simple index on LogDate should be enough. If you think that...
... Actually... There was an port of Firebird to Pocket PC back when it first was released as open source. Whoever did the port is no longer maintaining it,...
George P Boutwell
gboutwel@...
Sep 1, 2005 2:44 pm
65837
Thanks to HeLen, Adam and Alan for their replies. For information, tried dropping the constraints and re-adding the PK, set the sort order to descending and...
Hi friends: I want to do a SQL query like this in firebird: select A.nam, isnull(A.f1,0) from table1 as B left join table2 as A on A.f2=B.Cod Or select case...
... But existence of ascending or descending PK has nothing to do with the appearance of data. If you need them ordered, you always have to use ORDER BY. Ivan...
Hi there guys, I have a table like ID INTEGER TIMEIN TIME TIMEOUT TIME populates with records like 1 Time1 <Null> 2 <Null> Time2 3 Time3 <Null> 4 <Null> Time4...
Ok. We've discovered that the issue is due to the fact that a table has more than one row with the same primary key value in it. It sounds impossible but it is...
... No. There is no "default sort order". Changing the direction of an index does not "change sort order", since there is no "sort order" to begin with and...
... As Ivan points out, that won't work. Let me be even more clear. In the absence of an ORDER BY clause, data is returned in storage order, which is...
I'm creating a domain that's CHAR(11) and I'd like to add a check to make sure all the characters are numeric. I'm experiencing a brain freeze right now and...
Rick Debay
rdebay@...
Sep 1, 2005 4:17 pm
65847
... CHECK (Value BETWEEN '00000000000' AND '99999999999') Ivan...
d_dude_2003 wrote:
> Hi there guys,
> > I have a table like
> > ID INTEGER
> TIMEIN TIME
> TIMEOUT TIME
> > populates with records like
> 1 Time1 <Null>
> 2...
Hello What's the meaning of this log entry in the firebird.log: AAACHD111 (Server) Thu Sep 01 06:27:58 2005 Database: D:\A2318\DBINTERBASE\DATABASE.GDB ...
... Not quite ... this will allow '0A'. I have recently had to coerce some character columns with garbage data into numerics in another SQL dialect. I believe...
Deadlock is a situation when two processes, each having a lock on one piece of data, attempt to acquire a lock on the other's piece. Each process would wait...
I changed 'length' to 'strlen' and added the UDFs length and strlen. What's transform? ... From: firebird-support@yahoogroups.com ...
Rick Debay
rdebay@...
Sep 1, 2005 5:41 pm
65853
... oops, sorry. ... Long/ugly, but without UDF: CHECK ( SUBSTRING(Value FROM 1 FOR 1) BETWEEN '0' AND '9' AND SUBSTRING(Value FROM 2 FOR 1) BETWEEN '0' AND...
transform takes the data in the specified column and transforms all of the characters that are in the first set of arguments to the corresponding characters in...
