Hi Grant,

--- In firebird-support@yahoogroups.com, Grant Brown <grant@s...>
wrote:

> Hi all,
>
> Using Delphi 5, FB 1.5 (ss mode) and FIBPlus
>
> We have an app that has custom drop down lists that any user can

edit as

> required ie they can edit the contents of the drop down lists to

suit

> there own needs.
>
> A problem has arisen in that when one user changes the contents of

the

> drop down list the other users dont see the new list contents

until they

> re-log in to the database.

don't need to reconnect to database,
renewing the transaction is enough.

Or use a read-commited transaction and do close and open your query.

>
> Now I know that I can resolve this using Firebird "events" but I

am not

> sure how to go about this.

it is too easy,
first u should read The Firebird Book, written by another aussie.
(did i read? no, i havent so much money to buy it ;) )

>
> Could someone send me some details of how to do this from within a

SP as

> the event notification needs to go to all current users logged in

except

> the user that made the change.
>
> Also will this cause any network traffic issues ?

Dont refresh the list boxes, grids etc automatically.
warn the user to do it via attractiviness LED or Button.
so if the user dont need the new items or he/she in coffee time then
he/she wont refresh it. there wont be refresh traffic.
also, if it is refresh byself when i working on that screen, it
makes me angry, creates swearword traffic..

>
> --
> Regards,
> Grant Brown

Regards,

Ali

VETA Ltd.
izmir/TR