syntax error
Hi
I wrote a report in SAI using a microsoft SQL database. Everything worked and ran 100%.
I have then imported the report to another database that is using Pervasive sql database.
i now get the following error when running it:
Description : [Pervasive][ODBC Client Interface][Pervasive][ODBC Engine Interface]Syntax Error: SELECT
"CBBTHD"."REFERENCE",
"CBBTHD"."DATE",
"CBBTHD"."FISCYR",
"CBBTHD"."PERIOD",
"CBBTHD"."ENTRYTYPE",
"CBBTHD"."TEXTDESC",
"CBBTHD"."TOTAMOUNT",
"CBBTHD"."TOTTAX"
FROM ??? >>[CBBTHD]
Number : -2147217900
Source : Pervasive.SQL 10.00.0151 000
Driver Error : Unknown
SQL State : Unknown
any idea what the problem could be?
Views: 20
Replies to This Discussion
-
Permalink Reply by Stephen Coull on -
The SQL syntax between MS-SQL and Pervasive SQL is different, so the report would not work if created this way, although it should only require some very minor tweaks to get it working.
I suggest you join the Sage ERP Accpac INtelligence group on the BI Community at http://community.alchemex.com/group/sageaccpacintelligence and check out the data disctionaries for the standard reports that ship with Intelligence for MS-SQL and Pervasive SQL.
Hope this helps
Follow Alchemex on twitter
Like Alchemex on facebook
© 2012 Created by Admin.
