Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 4 of 4 total |
Editing none sensitive result sets |
Tue, Oct 27 2009 8:38 AM | Permanent Link |
Leslie | This a question for everyone:
I like the idea of sensitive result sets, especially sensitive views with lookup fields. But in most cases the data needs to be ordered for display purposes by looked up values stored in other tables, so there is no index in the base table --> insensitive result set. The big problem is not loosing sensitivity, but loosing edit-ability. Of course I can edit the base table and reopen the query/view again, but it may be too long for the user to wait for, plus there are issues like repositioning all grids/trees/... to the display exact same state as they were before editing. I was thinking about creating temporary tables / tables in memory DB and setting up a triggers for automatic data synchronization on the record level with the base table, but there maybe a better way. I was wondering how you guys would handle this situation? With Regards, Leslie |
Wed, Oct 28 2009 12:20 PM | Permanent Link |
Leslie | Tim,
What should happen if there is trigger for a regular table updating a temporary/Memory db table after a power fail? Does the engine some sort of direct or indirect referential integrity check at startup? Leslie |
Wed, Oct 28 2009 12:22 PM | Permanent Link |
Leslie | I mean on the system data.
|
Wed, Oct 28 2009 1:55 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Leslie,
<< What should happen if there is trigger for a regular table updating a temporary/Memory db table after a power fail? Does the engine some sort of direct or indirect referential integrity check at startup? >> I have no idea what you mean by those questions. Could you give me an example that will illustrate what you're talking about ? -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Saturday, May 4, 2024 at 12:54 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |