Subject Re: [firebird-support] multi connection Meta data update
Author Martijn Tonies
> Dear Team ,

What team? :-)

> I opened two isql.exe prompt (let us assume name
> 'one' and 'two' repectively for those prompts.). Then
> via 'One' I created a Table 'A'. Then in same prompt
> 'one', I created table 'B' with FK to Table 'A'. But
> it has thrown meta data error.
> Since in prompt 'two' I don't have did any operation
> pertaining to table 'A' or 'B'. (not even select
> query) I thought there is no 'interseting' tansaction
> related to object of 'A' or 'B' , I expected there
> won't be any error. But I got a meta data error in
> prompt 'one'. When I exit prompt 'two' (i.e. when i
> used only one connection via prompt 'one'). Table B
> has got created sucessfully.

Let me tell you again... You cannot create a FK in a
database when there is more than 1 connection to
that database.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Upscene Productions