Page 1 of 1

Method: [ExecuteCommandTextErrorHandling]

Posted: Tue Jul 04, 2006 3:03 am
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

Method: [ExecuteCommandTextErrorHandling]

Posted: Tue Jul 04, 2006 3:29 am
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.

Method: [ExecuteCommandTextErrorHandling]

Posted: Wed Jul 05, 2006 10:07 am
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.