英文:
Is Aliasing works for Quickbooks sdk?
问题
我正在使用JAVA从QuickBooks SDK中获取数据。我可以运行以下类型的查询：
选择 * from invoice。
选择 * from invoice where id =1;
但是当我使用别名 'as' 时
选择 id as myid from invoice。
它会抛出以下错误
线程中的异常 "main" com.intuit.ipp.exception.FMSException: 错误代码:4000, 错误消息:解析查询时出错, 错误详情:QueryParserError: 在第1行，第11列遇到 "as" "as " 的错误。
预期是以下之一：
"," ...
".*" ...
"from" ...
"iterator" ...
"maxresults" ...
"order" ...
"orderby" ...
"startposition" ...
"where" ..
是否有任何替代查询，以便我可以使用别名？
英文:
I am Working on fetching data from quickbooks SDK through JAVA.
I am able to run these type of queries
select * from invoice.
select * from invoice where id =1;
but when i am using aliases 'as'
select id as myid from invoice.
it is throwing below error
Exception in thread "main" com.intuit.ipp.exception.FMSException: ERROR CODE:4000, ERROR MESSAGE:Error parsing query, ERROR DETAIL:QueryParserError: Encountered " "as" "as "" at line 1, column 11.
Was expecting one of:
<EOF>
"," ...
".*" ...
"from" ...
"iterator" ...
"maxresults" ...
"order" ...
"orderby" ...
"startposition" ...
"where" ..
IS there any alternative query so that i can uses aliasing??
答案1
得分: 1
以下是要翻译的内容：
有效的语法在此文档中描述：
别名（例如使用 AS 关键字）不受支持。
英文:
Valid syntax is described in the docs here:
Aliasing (e.g. use of the AS keyword) is not supported.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论