Subject Re: [IBO] Multi user - seeing updates
Author Jason Wharton
Your second app has a transaction that is using the tiConcurrency isolation.
Change it to tiCommitted.

Jason Wharton
CPS - Mesa AZ

-- We may not have it all together --
-- But together we have it all --

----- Original Message -----
From: "georgethenorge" <ghelmke@...>
To: <>
Sent: Tuesday, October 22, 2002 9:49 AM
Subject: [IBO] Multi user - seeing updates

> Client1: I have one IBO/D5 app that is updating a table on the
> server every 10 seconds - "How many items have been produced?"
> Client2: I have another IBO/D5 app that is looking at this same
> table, to see how far the first one has gotten.
> I get a good result the first time I run the query, but client 2 seems
stuck on that same first answer. I have to close the app on client2, and
reopen it to get the latest info on the server.
> I have looked at server wide DML caching, but would that be really
> necessary here? I don't need real time results, just something no
> more than a minute or two old.
> Thanks,
> George Helmke