Error 1000: AFx Library library exception: Type Decimal is not supported

Question

I am trying to query a MS Access Web App (SQL Azure) using the Azure ML platform. The field I'm trying to capture is type Fixed-point number (6 decimal places), the default numeric field type in Azure SQL. When I try to query this field, I get the error:

Error 1000: AFx Library library exception: Type Decimal is not supported

I have tried casting it to another form as follows:

select cast(a) FROM b

And got the error:

Error 0069: SQL query "select cast("a" as float) from "b"" is not correct:

Column names cannot be null or empty.

What gives?

Furthermore, how isn't the default on Azure SQL supported in Azure ML???

Answer 1

Try assigning it to another variable:

Select cast("field" as float) as 'someAlias' FROM "Table"