I vote for the enhancement to the SQL engine. This is huge for us: we have views we've had to split into 4 concatenating views. xCase does a great job at this; and with Frank Camp's hard work and insight we got it to work with remote views also (these are all parameterized); but maintenance, well,...

So, removing the 9-join limit; making the views capable of most of the complexity of SQL Server views; the ability to cast() to particular types. This is all huge for anyone working with Enterprise applications.

Hank

PS: plus I've been begging for it for two prior versions. <s>

>I've been monitoring this topic since downloading the beta this morning.
>
>So this question is this: What's your favorite enhancement? With 8.0 it was CursorAdapters.
>
>I've gone over the list of changes and I'd have to guess that it would be Intellisense within a WITH...ENDWITH block. I've got to admit, however, that Auto-Complete with a text box did catch my eye (not to hedge or anything < vbg >).