You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When creating a SQL query to Excel tables, if the column names are not in Latin, then you cannot sort using 'order by' if the column name is used without quotes (a syntax error occurs): let sql="select recordset * from xlsx('c:\\MyTable.xlsx') order by Поле";//syntax error
In the case of using quotes, this function simply does not work, since it is not the contents of the field that are compared, but its name, and they are always equal to each other for the compared rows when sorting inside AlaSQL: let sql="select recordset * from xlsx('c:\\MyTable.xlsx') order by 'Поле'";//Sorting does not occur!
The text was updated successfully, but these errors were encountered:
I think I found a solution. It works if you pack the name of the required columns in square brackets: let sql="select recordset * from xlsx('c:\\MyTable.xlsx') order by [Поле]";//All ok!
I agree! You have a great library, but sometimes you have needs like the one I described, and it would be great to be able to make queries without escaping the column names!
When creating a SQL query to Excel tables, if the column names are not in Latin, then you cannot sort using 'order by' if the column name is used without quotes (a syntax error occurs):
let sql="select recordset * from xlsx('c:\\MyTable.xlsx') order by Поле";//syntax error
In the case of using quotes, this function simply does not work, since it is not the contents of the field that are compared, but its name, and they are always equal to each other for the compared rows when sorting inside AlaSQL:
let sql="select recordset * from xlsx('c:\\MyTable.xlsx') order by 'Поле'";//Sorting does not occur!
The text was updated successfully, but these errors were encountered: