Sure dude.

Here we go.

CREATE TABLE MOVIMENTACAO
(
ID Integer NOT NULL,
TIP_ID Integer,
PRO_ID Integer,
FUN_ID Integer,
DATA Date,
QTD Integer,
VOLUMES Integer,
INS_EMBAL Char(1),
INS_FISC Char(1),
INS_INJE Char(1),
INS_IDENT Char(1),
INS_OLEO Char(1),
NF Varchar(30),
LOTE Integer,
CONSTRAINT PK_MOVIMENTACAO PRIMARY KEY (ID)
);

GRANT DELETE, INSERT, REFERENCES, SELECT, UPDATE
ON MOVIMENTACAO TO "ADMIN";

GRANT DELETE, INSERT, REFERENCES, SELECT, UPDATE
ON MOVIMENTACAO TO SYSDBA WITH GRANT OPTION;



From: emb_blaster
Sent: Monday, August 23, 2010 11:29 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: Problem with CASE.

--- In firebird-support@yahoogroups.com, João Luiz <jll.listas@...> wrote:
>
> Update.
>
> I've installed Firebird 2.5 in a virtual machine.
>
> Gbaked my database from 2.1, restore in the 2.5 and the case statement is now working everywhere.
>
> Maybe a 2.1 bug that just occour with me?
>

Hello there,

Can't you Extract Metadata of the Table "movimentacao" and put it here?
This will help people who want to reproduce the "error" and confirm it or discard it.





[Non-text portions of this message have been removed]