Subject RE: [firebird-support] isql doesn't show latest info
Author Marc-Antoine Desroches
Does that mean that if I have two apps hitting the same database I should
always 'commit' before a select? I find this quite counter-intuitive. If
there are two applications, one writer and one reader, the reader should not
have anything to commit to and always see the latest commited transactions.
Is there a way to force this behaviour?


-----Original Message-----
From: Francesco Lamonica [mailto:franci@...]
Sent: 29 aoƻt, 2003 18:03
To:; hay77772000
Subject: Re: [firebird-support] isql doesn't show latest info

Hash: SHA1

On Friday 29 August 2003 22:27, hay77772000 wrote:
> Hi,
> I connect to my database using isql, and do a "select count(id) from
> metrics" and get the current count back.
> However if I add some more records using my app, and try the select
> count again, it shows me the same count!
> Is this expected behavior?!
try executing commit; within isql

- --
Francesco Lamonica: f DOT lamonica AT tin DOT it

PGP Fingerprint: 5870 92BA 8DFF 1ACF DE2E B94D 46EC 5505 7C64 4EF1
Favourite quote: There's no spoon
Version: GnuPG v1.2.3 (GNU/Linux)


To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to