Column aliases in SQLCE3.5

Jatvarthur · Post by **Jatvarthur** » Tue 02 Jun 2009 11:43

Hello, I encountered the following problem while working with SQL Server Compact Edition 3.5 in my application using TUniQuery: fields aliases doesn't seem to work. For example, when I execute this SQL in TUniQuery

Code: Select all

SELECT ID AS temp_id FROM [Templates]

I receive a dataset with one field named 'ID'. However, I expect to receive a field 'temp_id'. In SQL Server Management Studio this query works as expected. How can I fix this?

Dimon · Post by **Dimon** » Wed 03 Jun 2009 07:51

Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next UniDAC build.

Jatvarthur · Post by **Jatvarthur** » Wed 03 Jun 2009 10:04

When will this fix be available? We really need it, because with this bug we cannot continue development of our project. Thanks.