Hi Adam,



Providing the meta data script is easy. Is there an easy way to generate a
script to populate a new database with precisely the same data I have in my
current one. I have not FK's, only primary key constraints.







_____

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Adam
Sent: 23 November 2005 05:55 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: SQL NOT IN

--- In firebird-support@yahoogroups.com, "Dion" <27824912424@v...> wrote:
>
> I tried your suggestion, Alexandre, and the records I am looking for are
> returned, although the EXISTS script(like the IN) also returns an empty
> result set.
>
>
>
> Thanks.
>

Dion,

I think the script looks fine. Are you sure this isn't just an
isolation level problem where your select statement cant see the
inserted records because they were not committed until after the
transaction started?

Otherwise, create a sql script to duplicate what you are experiencing.
If you can't duplicate the problem, then you need to fix up your
transaction management there. If you do duplicate it, post the script
and we can check if there are any runs.

The script should create the tables, insert the data then run the select.

Adam









++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++





_____

YAHOO! GROUPS LINKS



* Visit your group "firebird-support
<http://groups.yahoo.com/group/firebird-support> " on the web.


* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.



_____



[Non-text portions of this message have been removed]