>Times:
> the create sql view 1.36 seconds
> the select view without using nodata 1.2 minutes (passed the where variable)
> the select view using nodata .02 seconds
> indexing the above .06 seconds
> requery() with above 1.5 seconds (passed the where variable)
> multi requery's get faster.
>
>We have not checked tableupdate() yet.
>John

Looks much better!

Sownload the eView app from the files section. That will help you with your tabelupdates which get very hairy in all those dbsetprop()'s.

Another trick is to send a know BAD vp_param to open the view with nodata.
vp_custno = '' will bring back all
vp_custno = ' ' will bring back 0

That is a big difference in instanciating a form, waiting on data or not.

__Stephen