multi-user IBX application

Update

Delphi Developer

Sun, 21 Mar 2004 21:36:41 GMT

multi-user IBX application

When one user updates a record, other user cannot see it if he don't close
the application and open again.

How can I resolve this problem?

PS. I've used ibquery.cachedupdates = true and and
ibquery.datatabase.applyupdates([ibquery]) after ibquery.post

Thanks.

Team

Delphi Developer

Sun, 21 Mar 2004 21:59:53 GMT

Re:multi-user IBX application

Quote

Update wrote:

> When one user updates a record, other user cannot see it if he don't close
> the application and open again.

Your "other user" is probably using a SNAPSHOT transaction. Try
setting the transaction isolation mode to READ COMMITTED (double-click
on the TIBTransaction at design time).

You can read about transaction isolation modes here:

http://www.cvalde.com/document/TransactionOptions.htm

HTH,

-Craig

--
Craig Stuntz (TeamB) Vertex Systems Corp. Columbus, OH
We're hiring: http://www.vertexsoftware.com/careerops.htm#sd
Delphi/InterBase WebLog: http://delphi.weblogs.com

DA Brooke

Delphi Developer

Mon, 22 Mar 2004 22:30:43 GMT

Re:multi-user IBX application

I'm very new to Interbase and seem to be having the same problem.

I have set the transaction properties as suggested.. but I've obviously
missed something.

Regards

Dave

Quote

Update wrote in message <3bbb13b9$1_2@dnews>...
>When one user updates a record, other user cannot see it if he don't close
>the application and open again.

>How can I resolve this problem?

>PS. I've used ibquery.cachedupdates = true and and
>ibquery.datatabase.applyupdates([ibquery]) after ibquery.post

>Thanks.

Team

Delphi Developer

Mon, 22 Mar 2004 22:46:51 GMT

Re:multi-user IBX application

Are you committing the changes? Other users can not see uncommitted changes.
Just posting is not enough.

Quote

DA Brookes wrote:

> I'm very new to Interbase and seem to be having the same problem.

> I have set the transaction properties as suggested.. but I've obviously
> missed something.

> Regards

> Dave

--
Jeff Overcash (TeamB) | Talk about failure
(Please do not email | To fall is not to fail
me directly unless | Failure isn't about falling down
asked. Thank You) | Failure is staying down (Marillion)

Team

Delphi Developer

Mon, 22 Mar 2004 22:47:47 GMT

Re:multi-user IBX application

Quote

Update wrote:

> PS. I've used ibquery.cachedupdates = true and and
> ibquery.datatabase.applyupdates([ibquery]) after ibquery.post

There is no need for CachedUpdates if you are going to do this. You are adding
an unnecessary level of complication.

Quote

> Thanks.

--
Jeff Overcash (TeamB) | Talk about failure
(Please do not email | To fall is not to fail
me directly unless | Failure isn't about falling down
asked. Thank You) | Failure is staying down (Marillion)

DA Brooke

Delphi Developer

Mon, 22 Mar 2004 23:39:16 GMT

Re:multi-user IBX application

I've used ibtable2.applyupdates
and ibtransaction2.commit
in an afterpost operation, but get an error message "cannot perform this
operation on a closed dataset" when I try to click on post...

I'm used to dBASE tables, sorry..
Regards
Dave

Quote

Jeff Overcash (TeamB) wrote in message <3BBC765B.6C4EB...@onramp.net>...
>Are you committing the changes? Other users can not see uncommitted
changes.
>Just posting is not enough.

>DA Brookes wrote:

>> I'm very new to Interbase and seem to be having the same problem.

>> I have set the transaction properties as suggested.. but I've obviously
>> missed something.

>> Regards

>> Dave

>--
>Jeff Overcash (TeamB) | Talk about failure
>(Please do not email | To fall is not to fail
> me directly unless | Failure isn't about falling down
> asked. Thank You) | Failure is staying down (Marillion)

DA Brooke

Delphi Developer

Mon, 22 Mar 2004 23:50:52 GMT

Re:multi-user IBX application

Thanks for your help
Regards
Dave

DA Brooke

Delphi Developer

Mon, 22 Mar 2004 23:47:27 GMT

Re:multi-user IBX application

Sorted this I think..
I have to commit everything, post, delete, refresh etc.. (which makes sense
now)
Sorry If I look dim, this is my second day with interbase...

Thanks for your patience..

Other Threads

1. Multi-user IBX problem

2. Multi-tier application and IBX

3. Multi user application

4. How to write a database multi-user application

5. Need help: Cannot get multi-user D3 application running on my network

6. Multi users database application....

7. multi users database application.....

8. One user Application to Multiuser

9. Database application for multi-users

10. multi-user application: bde