I have managed to create a table with no name and possibly no fields!
There is a record in RDB$RELATIONS where all of the fields are null except
RDB$OWNER_NAME
and RDB$DEFAULT_CLASS both of which have values in them. Validating the
database finds no
errors and trying to mend the database
Hi Gang,
preparing finally for the leap of faith and switch from 1.5.6 to 2.5.2
on all applications and databases. So far everything is still nice. I
followed documentations and postings on the -Fix_FSS_M switch.
I never made too wide use of UDFs, so I don't expect too many problems
there.
No I
Hi,I use FB 2.5 !
I'm writing a store procedure,and there I need some sets of data stored
temporary to use only in my SP,I also need to update/delete it
Is there is a easy way to do this with firebird?
I also found there are temporary tables,but I don't know how to use or if is
what I need.
On Mon, Nov 26, 2012 at 6:53 AM, paultugwell pa...@guardbase.co.uk wrote:
I should have mentioned that this is FB1.5 and is a test DB. I have since
found that deleting the blank record from RDB$RELATIONS allows a backup
and restore and the restored DB no longer has the table with a blank name
i am try to create PivotTable via ms excel using odbc drivers and errors come
sql error code = -104
token unknown -line 1, column 33
i am using ms excel 2010 64 bit, firebird 2.5.2 32 bit, odbc driver 2.0.1 64
bit, fbclient.dll 2.5.0.26074
can somebody help? thanks.
We need to do a lot of checking in update triggers to check for value changes.
ie if( OLD.FIELD1 NEW.FIELD1 )OR( OLD.FIELD2 NEW.FIELD2 )THEN
DO SOMETHING;
However if either value is NULL then the response will be NULL.
Is there an easy way to compare values, taking into account these
At 03:16 p.m. 27/11/2012, Robert Gilland wrote:
We need to do a lot of checking in update triggers to check for value changes.
ie if( OLD.FIELD1 NEW.FIELD1 )OR( OLD.FIELD2 NEW.FIELD2 )THEN
DO SOMETHING;
However if either value is NULL then the response will be NULL.
Is there an easy way
Dear all,
I am newbie to Firebird, I am working on Oracle and porting a small module
to Firebird. We face with very strang problem:
When session A and B update a row in a table at the same time. If A goes
first, and while A does not commit or rollback yet, B will update the same
row. In Oracle,