I tried that, but that only seems to work when you have a single
connection. As I explained earlier, I'm using a connection pool. Even
when I close and reconnect all the connections this doesn't work. It
only seems to be possible with only one connection. Clearly this is
very impractical. I'd really appreciate a solution that could be used
without Firebird-specific code modifications just to be able to use
foreign keys.

Thanks a lot.

On 17 Jul 2004, at 01:34, Alexandre Benson Smith wrote:

> Geert Bevin wrote:
>
>> Well I have auto commit on, and it doesn't work. I also tried it in
>> isql by executing the commit command explicitly while some other
>> connections are going on. No luck.
>> Any other ideas?
>>
>>
> Try:
>
> Disconnecting and then re-connecting and then create the FK.
>
> see you !
>
> --
>
> Alexandre Benson Smith
> Development
> THOR Software e Comercial Ltda.
> Santo Andre - Sao Paulo - Brazil
> www.thorsoftware.com.br
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
--
Geert Bevin Uwyn bvba
"Use what you need" Avenue de Scailmont 34
http://www.uwyn.com 7170 Manage
gbevin[remove] at uwyn dot com Tel +32 64 84 80 03

PGP Fingerprint : 4E21 6399 CD9E A384 6619 719A C8F4 D40D 309F D6A9
Public PGP key : available at servers pgp.mit.edu, wwwkeys.pgp.net