Dear Team (I mean the members who are subscribed to
the forum),

I do understand that we cannot create FK when there
two connections. I am new to firebird. I am in the
process of learning firebird design/architecture. In
that process, I am just trying out to figure out the
reason which restricts meta data update , so what I
can follow a better alternative solution when I use
firebird in my application.


Thanks for your response,

with thanks & regards,
S.Karthick

--- Martijn Tonies <m.tonies@...> wrote:

>
>
> > 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
> Server.
> Upscene Productions
> http://www.upscene.com
>
>
>

__________________________________
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
http://promotions.yahoo.com/new_mail