Subject | Re: [firebird-support] multi connection Meta data update |
---|---|
Author | Helen Borrie |
Post date | 2004-08-30T12:42:49Z |
At 05:12 AM 30/08/2004 -0700, you wrote:
Martijn has told you twice in this thread.
metadata changes...
./hb
>Dear Team ,Correct. You need exclusive access to create foreign keys, as I think
>
> 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.
Martijn has told you twice in this thread.
> Since in prompt 'two' I don't have did any operationNo, it's the rule for foreign keys. And you should make it a rule for any
>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.
>
> So I hope there is no relation to jay bird in this
>error.
metadata changes...
./hb