I was not suggesting that your problem has anything to do with the
choice of tool. Do you understand transaction isolation levels?

It is normal for a transaction to not see uncommitted changes from
other transactions. In most isolation levels, you will not even see
changes made by other transactions that have been committed if you
started your transaction before you started your transactions.

Most tools implicitly start a transaction when you run the first query
if none is running.

So if you open two isql windows

in window 1:

insert into test (id) values (1);
commit;

and then in window 2:

select * from test where id = 1;

Unless the transaction in window 2 is read-committed, you will not get
any record returned in window 2.

Adam

--- In firebird-support@yahoogroups.com, "Dion" <27824912424@v...> wrote:
>
> 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]
>