Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in Azure by (45.3k points)

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

1 Answer

0 votes
by (16.8k points)

Try assigning it to another variable:

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

Welcome to Intellipaat Community. Get your technical queries answered by top developers!

30.5k questions

32.5k answers

500 comments

108k users

Browse Categories

...