Propagating changes to a LookupEdit


Author
Message
Kirk M Sherhart
Kirk M Sherhart
StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)
Group: Forum Members
Posts: 41, Visits: 259
If I have a DevExpress LookupEdit bound to a BBS for its lookup values, will changes to the BBS's underlying BO (adds, delete, edits) be automatically propagated to the LookupEdit? For example, if a record is deleted from the BO, the next time the LookupEdit is selected, the value would not be presented for selection.



If not, what's the best way to capture and propagate the changes?

Reply
Edhy Rijo
E
StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)
Group: StrataFrame Users
Posts: 2.4K, Visits: 23K
Hi Kirk,



I have the same kind of scenario as yours but I don't use DevExpress, I have SF comboboxes in other forms, and what I do is in the DropDown to force a Combobox.Requery() to make sure the data is updated.



I know this may not be the most effective way to handle that, but if the lookup BO does not have many records it may be acceptable to you. On the other hand Trent suggestion to have some sort of mechanism to see if the data has changed via a SP looks interesting.

The approach that we generally use if automatic updates are necessary to the client cache, is to create a threaded timer (System.Threading.Timer) that calls a sproc on the server every X number of seconds and SUMs up all of the row versions and then we will do a compute of the local data table to see if these numbers match. If so, the cache is up to date, otherwise a query is necessary to get any missing records.



Edhy Rijo

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search