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???