Ken,

this is a killer! The new sql makes is possible to create reporting views (in xCase) that will have sql length that will surely outstrip the 8192 limit. But then we won't be able to generate them! We have reporting views that, before we deconstructed them into concatenating views, had 20+ joins, with perhaps 150+ fields (the model has some 300 entities). VFP9 was going to be the way to reunify our views. And keep in mind that xCase aliases views with the name of the relational path, so these added fields typically have aliases that are 20-characters each -- that's 3000 characters right there!

We don't need 8192 lifted as a limit for command lines: we need the ability to create views that have SQL > 8192. If there is a way to include a function that accepts a string > 8192 and runs the create sql view process from it, it would greatly enhance the value of the product.

BTW: this is not a last-minute request. I noted in the UT VFP9 wishlist this same issue.

thanks,

Hank

>>as has been noted on some blogs, the 8192-character limit in building SQL Views will limit the ability to implement the (wonderful!) changes to the SQL engine: will some kind of change be coming for that in the final release?
>
>There are no plans to change/increase this limit, so you know.