On Fri, 29 Aug 2003 20:22:35 +0000 (UTC), hay77772000 wrote:

> 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?!

It could be. It depends on what you are doing, and how.
Is everything done in the same transaction? Probably not, since you are
talking of ISQL and 'your app'.
What is your transaction isolation?
Did you commit your additions?

--
Aage J.