Method: [ExecuteCommandTextErrorHandling]

Stimulsoft Reports.NET discussion
Post Reply
scotty
Posts: 28
Joined: Tue Jul 04, 2006 2:05 am
Location: Austria

Method: [ExecuteCommandTextErrorHandling]

Post by scotty »

Hi! I've created a report like the report in your sample at http://www.stimulsoft.com/livedemos/Rep ... eters.html

On executing the report i get an error (in german - this is my translation):

Method [ExecuteCommandTextErrorHandling]
The variable @varStartDate must be declared

Please help
thanks
scotty
Edward
Posts: 2913
Joined: Fri Jun 09, 2006 4:02 am

Method: [ExecuteCommandTextErrorHandling]

Post by Edward »

scotty wrote:Hi! I've created a report like the report in your sample at http://www.stimulsoft.com/livedemos/Rep ... eters.html

On executing the report i get an error (in german - this is my translation):

Method [ExecuteCommandTextErrorHandling]
The variable @varStartDate must be declared

Please help
thanks
scotty
Please send your report for quick analysis to Image.
Thanks.
Vital
Posts: 1278
Joined: Fri Jun 09, 2006 4:04 am

Method: [ExecuteCommandTextErrorHandling]

Post by Vital »


When you are use OLEDB in some cases you can't use named parameters with @. In this case you need use unnamed parameters, for example:

select * from orders
where date > ? and date < ?


In parameters collection you need create two parameters with any name. Parameters must be created in right order.

Thanks.
Post Reply