Forum Discussion
Solved
Using a Column with reserved words inside ODBC connector
Could someone help me? I am using ODBC connector to use a server where I query the following: Fonte = Odbc.Query("dsn=default-server", "select "from".taxid from clients") I have this databas...
After weeks of struggle I finally found out a solution.
One should use double double quotes to achieve what I wanted. Such as:
""from"".taxid
I found it really unusual and not friendly at all, but at least solved my problem.
Hi RaphaelPavanBR ,
You might consider using double quotes or square brackets to escape reserved words
Odbc.Query("dsn=default-server", "select \"from\".taxid from clients")OR
Odbc.Query("dsn=default-server", "select [from].taxid from clients")This is the related document, you can view this content:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Neither of your formats worked. Both gave the same error.
Brackets:
counter bars with double quotes: