Hi,

I'm using LLBLGen Pro v. 1.5, with SQL Server 2000. In some queries I'm using a typed view, with ordering clause.

This worked fine, but because of the server migration to the Windows Server 2008 at one of our customers, we had to migrate the database to the MS SQL Server 2005.

The migration succeded, and the program continues to work, but unfortunately on doesn't recognize ordering in the typed view henceforward.

The program coded at 2004, and we don't wish to update the LLBLGen pro until the new release of our softwer.

Does anybody experienced this behavior, or anybody has a proposal, how to solve the issue?

Thanks in advance

Gabriel

Gabriel wrote:

The migration succeded, and the program continues to work, but unfortunately on doesn't recognize ordering in the typed view henceforward.

Hi Gabriel.

• Please be more specific on the "doesn't recognize ordering" part. An exception? doesn't sort?

• What LLBLGen runtime library version are you using (http://llblgen.com/tinyforum/Messages.aspx?ThreadID=7720)?

• If possible, please post a code snippet where you perform the fetch with the SortExpresion. Also the Generated Sql produced (see manual for details).