2. ASPRunnerPro General questions
  3. [SOLVED]  ASPRunner was unable to parse your SQL query. Designer tab is not available
This topic is locked
[SOLVED]

 ASPRunner was unable to parse your SQL query. Designer tab is not available

 		12/27/2013 15:22:22
ASPRunnerPro General questions
K
 kleanthis author

Hi to all. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=21779&image=1&table=forumtopics' class='bbc_emoticon' alt=':D' />
I have the following SQL code for a report page.

SELECT

dbo.UsersCa.PMP,

dbo.UsersCa.UsName,

dbo.UsersCa.UsSurname,

dbo.UsersCa.[Position],

dbo.Dates.DateCA,

dbo.InfoCa.IDUser,

dbo.InfoCa.IDCa,

dbo.InfoCa.Description

FROM dbo.UsersCa cross join

dbo.Dates left outer join

dbo.InfoCa

ON dbo.Dates.DateCA = dbo.InfoCa.DateField;


I place it in the Query page, SQL tab. In the Result tab it show the correct recorts but in the Query Desinger tab an error show ( ASPRunner was unable to parse your SQL query. Designer tab is not available.)
When I bulit the project i get the following error for the report page

(Microsoft SQL Server Native Client 10.0 error '80040e14'

Incorrect syntax near ';'.

/include/aspfunctions.asp, line 1343)
Please help.
Kleanthis
Sergey Kornilov admin 12/27/2013

Remove semicolon from the end of your SQL query.
K
 		kleanthis author 12/28/2013

Thank you. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=73410&image=1&table=forumreplies' class='bbc_emoticon' alt=':P' />
I did not notice the semicolon. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=73410&image=2&table=forumreplies' class='bbc_emoticon' alt=':blink:' />