Otherwise, you will have to manually (i.e., not allow the DE to open them for you) open the view and create them yourself. If you put a view in the DE, the DE will open the view with buffering. At such point, you can not create an index on a buffered table or view. So, you are going to save effort by just doing this yourself.
Not so. I put my views in the DE with buffermode set to 3 and NoDataOnLoad=.T. Then, in the .Init of the form, I create the indices I need, set buffer mode to 5 and then REQUERY() the view to bring the data in. I found bringing in the data after creating the indices is faster than the other way round.
Colin Magee Team Leader, Systems Development Metroland Media Group Ltd. Mississauga, Ontario, Canada
