I have uninstalled v1.5(FB) and installed v2(FB) as well as the latest
version(Personal) of IBExpert, and still have the same problem. I have also
established that it is not ibexpert, as I got the same results with
FlameRobin, using FB2.







_____

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]