[firebird-support] Question about an error during Create/Drop tables.

[amiya_s_hos...@yahoo.com [firebird-support]]

Hi. 
 
My name is Shingo. 
I got a trouble that Firebird does not create table correctly sometime 
when I create and drop so frequently. 
 
I actually execute the following steps. 
(Assume that the table is already in database.) 
 
Step1) Execute following query. 
 
DROP TABLE T_WORK; 
 
CREATE TABLE T_WORK 
( 
  WORK_DATE Char(10) NOT NULL, 
  TIME_UNIT Varchar(2), 
  SVR_NAME Varchar(1000), 
  ACS_COUNT Integer 
); 
 
 
Step2) After executing step1), execute following query in order to check 
a column in the table exist or not. 
 
select r.rdb$field_name from rdb$relation_fields r where 
r.rdb$relation_name='T_WORK' 
 
The system shows following results. 
 
WORK_DATE 
TIME_UNIT 
SVR_NAME 
ACS_COUNT 
 
 
Step3) Right after the step2, I get an error when I execute query like 
following. 
 
SELECT WORK_DATE FROM T_WORK 
 
ErrorCode: 
335544569 
ErrorMessage: 
Dynamic SQL Error 
SQL error code = -206 
Column unknown 
WORK_DATE 
At line 1, column 18 
 
Step4) At the time when I get the error, I also get the different error like 
following. 
(Once I get error like step3, I always get error like following.) 
 
SELECT * FROM T_WORK 
 
ErrorCode: 
335544343 
ErrorMessage: 
invalid request BLR at offset 24 
table id 7096 is not defined 
 
My question is that the error occurs *not* every time, it just occurs sometime 
so I can not see the cause of the error. 
Is there any tips for the phenomenon? 
I'd appreciate if anyone could give me a resolution for that.