User 'b' not seeing user 'a's changes

[delphi6BDE]

I have created an application using Delphi 6 and Firebird. Everything works perfectly; records can be added and modified but there's a problem. When a user makes a change nobody else can see it until they exit and restart their copy. Why is this?

 

[DelphiAaron]

dont know about firebird but like most databases you need to do a refresh to load the current dataset.

Aaron

 

[roo0047]

Is Firebird one of those that needs a "commit" after a "post"?

Roo
Delphi Rules!

 

[delphi6BDE]

Thanks for the replies.

aaronjme - There doesn't appear to be a refresh command for firebird that I can find. I tried connDB.Refresh but it wasn't recognized.

roo0047 - Yes, firebird needs a commit after each post, and according to the SQL Monitor it does; it always shows XACT: Commit when I test the program