>Is it true that views with row buffering can be indexed, but those with table buffering cannot? This is what it seems to me, but I wanted to check first. If so, any reason why? I have a situation where the views had row buffering, but it seemed much more logical for the form's purpose to use table buffering. Now I get an error when setting the index after changing the mode. If this is the case I will have to go back and figure out how to handle all the processes as they relied heavily on having indexes available. Thanks!
>
>Regards, Renoir
Renoir,
You can set the view to row buffering, create the index, and then change it back to table buffering.
cursorsetprop("buffering",3)
index on tableID to viewIndex
cursorsetprop("buffering",5)
HTH,
Steve Gibson