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?

Thanks.

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


-----BEGIN PGP SIGNED MESSAGE-----
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
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQE/T82nRuxVBXxkTvERAjJDAJ9JjJVaT1t0idCqFg7aCxAEyk55hwCfa+ka
zN6fTIVPhSdOupy3yXgIQOo=
=vz6l
-----END PGP SIGNATURE-----


To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/