>>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,
Whoa! Ok, didn't think of that... So - that begs the question as to why an index isn't allowed when it is in table buffering mode if you can simply work around it. Any idea?
Renoir