Hiya. I am new to Telerik, using Telerik 2011 Q3 in Visual Studios 2010 on a latop running Windows 7. Currently I am trying to create a Telerik report using Oracle data and am confused by what is happening with the query.
The query is fairly large, but executes properly in TOAD. When I move it to Visual Studios I get mixed results:
1. When I try to execute the query in Query Builder, I get an "SQL Syntax Errors Encountered" message that says
"Error in SELECT clause: expression near 'SELECT'.
Missing FROM clause.
Error in SELECT clause: expression near ','.
Error in SELECT clause: expression near 'FROM'.
Unable to parse query text."
2. If I bypass Query Builder and continue to the Preview Data Source Results and click Execute Query, the query completes consistantly in approx 2 min.
3. When I go to the Telerik Report Preview mode, enter the variables and click PREVIEW, the hour glass spins but the query never completes. I have waited 15 min by the clock and not gotten any results (remember the query completes in 2 min in the Preview Data Source Results pane.
I don't know Visual Studios well enough to understand the significance of it working in the Preview Data Source Results but failing in both the Query Builder and the Report Preview. It seems strange to me that the Query Builder reports multiple syntax errors, yet the query completes successfully in Preview Data Source Results. I've never seen an SQL query with syntax errors work before, so I am sceptical about the Query Builder error message. The report does have nested SELECTstatements, which I assume has something to do with the messages about problems near SELECT and FROM. At the same time, it isn't completing in PREVIEW mode in the report, so something is obviously wrong.
Can someone please shed some light on what is happening?
Thanks!
Kevin
The query is fairly large, but executes properly in TOAD. When I move it to Visual Studios I get mixed results:
1. When I try to execute the query in Query Builder, I get an "SQL Syntax Errors Encountered" message that says
"Error in SELECT clause: expression near 'SELECT'.
Missing FROM clause.
Error in SELECT clause: expression near ','.
Error in SELECT clause: expression near 'FROM'.
Unable to parse query text."
2. If I bypass Query Builder and continue to the Preview Data Source Results and click Execute Query, the query completes consistantly in approx 2 min.
3. When I go to the Telerik Report Preview mode, enter the variables and click PREVIEW, the hour glass spins but the query never completes. I have waited 15 min by the clock and not gotten any results (remember the query completes in 2 min in the Preview Data Source Results pane.
I don't know Visual Studios well enough to understand the significance of it working in the Preview Data Source Results but failing in both the Query Builder and the Report Preview. It seems strange to me that the Query Builder reports multiple syntax errors, yet the query completes successfully in Preview Data Source Results. I've never seen an SQL query with syntax errors work before, so I am sceptical about the Query Builder error message. The report does have nested SELECTstatements, which I assume has something to do with the messages about problems near SELECT and FROM. At the same time, it isn't completing in PREVIEW mode in the report, so something is obviously wrong.
Can someone please shed some light on what is happening?
Thanks!
Kevin