Bruce,

Thanks I think you have hit the nail on the head :o) BTW I work in a nail factory by day and program by night....

Thnaks


>>I am trying to create an index on a view on the fly to sort a grid by the column clicked on. I can create the index on the command line but I get some weird errors when I try and do it in code. I have code to do it for a table.
>
>Indexing a view is fine, you can do it a couple ways. All at loading, or later on-the-fly as needed, just add some code like this to prevent the buffering error:
>
>=cursorsetprop('buffering',3,'myview')
>index on myfield tag mytag
>=cursorsetprop('buffering',5,'myview')