modified SmartList results in SmartView error
When I run the list in SmartList, it runs fine. However when I attempt to launch an existing favorite in SmartView 12.0.25 I receive a syntax error. However, creating new favorties work fine.
Removing the added table from the SmartList does not resolve the issue.
Error message: Incorrect syntax near the keyword 'from'. Incorrect syntax near 'T1'.
From a SQL trace:
SET FMTONLY OFF; SET FMTONLY ON;select top 1000 T1.[CMPNTSEQ] K1, T1.[LNITMSEQ] K2, T1.[SOPNUMBE] K3, T1.[SOPTYPE] K4, from (select * from slbSalesOrderLines with (NOLOCK)) T1 where …
SET FMTONLY OFF;
It appears the process this is building the query is not surfacing columns after the T1.[SOPTYPE] K4 column. The comma after K4 throws the error.
Any assistance would be appreciated.
Has this been fixed yet? I thought I Was running the neest version, but am encoutnihgn the same error.
The offending SQL statement is :
SET FMTONLY OFF; SET FMTONLY ON;select top 10000000 T1.[POPRCTNM] K1, T1.[RCPTLNNM] K2, from (select * from svReceivingLine with (NOLOCK)) T1 SET FMTONLY OFF;
Throws the same error as noted above.
If you would like to submit an answer or comment, please sign in to the eOne portal.