Hi!

It would be great to have a fast view which is always updated
with the correct data. That is:
I have 3 tables with 0 to 100,000 records each. (ON oracle 8.0.5)
For each there is a list of columns which the users sess as a browse list and can connect or choose from this list.

This list must be correct if another person add,deletes or changes a reocrd in it. And this must happen as fast as possible.

My current thoughts are:
1) I have a SQLSELECT statement that makes a cursor based on the brose fields. This is update by checking:
- That the max(lastedit) date is not greater than the local copy.
and that the number of records is the same.
-Otherwise it uses a local cached copy.

Problem: Not currect if other users change it.

2)Have a table with all changes in it. Update the local copy from these changes.
PRobelm: maintanance of this table.

3)Use remote views so that when I fetch I can continue to execute the program. Use requery it refresh the data.
Problem:Requery takes a long time on 100,000 records..

-Scrolling cursor are a problem with all ODBC drivers I've seen
for Oracle you can't use them

ANy ideas or comments?????

The program must work in this way so the obvious cutting down the number of records fetched is not an option.
-Storing the local copy helps but I can't keep it up to date.
-Only selecting the browse list fields also makes it faster.

Thanks in advance for any ideas or suggestions.