I get "Line 1: Incorrect syntax near ')'." when using SqlClient ExecuteScalar

Hi Marc,

I have a similar problem as mentioned in the first mail of this chain. I am getting Line 202:Incorrect syntax near 'end'" while I try to execute the procedure from my VC++ code using

ExecuteNonQuery method.

can you guide me about solving this issue?

Regards,

Anni

Anni wrote:

Hi Marc,

I have a similar problem as mentioned in the first mail of this chain. I am getting Line 202:Incorrect syntax near 'end'" while I try to execute the procedure from my VC++ code using

ExecuteNonQuery method.

can you guide me about solving this issue?

Regards,

Anni

Hi Anni,

There must be sth wrong in your procedure. Pls paste the whole procedure here and you'll get your answer.

|||Yes, this is just a sql syntax error. Usually it is best to get the sql and try to run it from query analyzer (or SQL Server Management Studio) until you get the syntax correct.

I am getting Line 202:Incorrect syntax near 'end'"

Hi Marc,

I have a similar problem as mentioned in the first mail of this chain. I am getting Line 202:Incorrect syntax near 'end'" while I try to execute the procedure from my VC++ code using

ExecuteNonQuery method.

can you guide me about solving this issue?

Regards,

Anni

Anni wrote:

Hi Marc,

I have a similar problem as mentioned in the first mail of this chain. I am getting Line 202:Incorrect syntax near 'end'" while I try to execute the procedure from my VC++ code using

ExecuteNonQuery method.

can you guide me about solving this issue?

Regards,

Anni

Hi Anni,

There must be sth wrong in your procedure. Pls paste the whole procedure here and you'll get your answer.

|||Yes, this is just a sql syntax error. Usually it is best to get the sql and try to run it from query analyzer (or SQL Server Management Studio) until you get the syntax correct.

Hyperlinks Within Report

Hi All,
Is there a way to add hyprlinks from a location in the top of the report to
locations elsewhere in the report (similar to how HTML bookmarks are used).
I'm creating a report that will have summary information at the top of the
first page. I'd like to create links to get the user to the details for
specific detailed sections within the report (most likely these will be
sub-reports).
Thanks in advance for your help!
Kind regards - FredHi Amarnath,
> Yes very much, you need to create Bookmarks and refer the bookmark using
> "jump to Bookmark" and see to that the bookmark is unique.
Thanks - is this only supported when the report is opened "online" with the
report server? Or... is there a way to make these work in an emailed copy of
the report (for recipients of the reports via subscriptions)?
Thanks again in advance!
Kind regards - Fred