Page 1 of 1

Column aliases in SQLCE3.5

Posted: Tue 02 Jun 2009 11:43
by Jatvarthur
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?

Posted: Wed 03 Jun 2009 07:51
by Dimon
Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next UniDAC build.

Posted: Wed 03 Jun 2009 10:04
by Jatvarthur
When will this fix be available? We really need it, because with this bug we cannot continue development of our project. Thanks.