> > Did you try to change string dates to parameters for this block
> >
> > I have not tested but may be useful
> >
>
> yes i tested it before and yes it's useful thanks to u.
> but my problem i that this code generated in run time
> and i can't in easy way to know dates to compare so i can change them
> to parameters
>
> i think the problem is that in every loop there is a converting from
> string date to actual date for const dates(like '05/01/2006' ..)
>
> any chance to made the server do this converting just once before
> executing the block and manage these consts or any other soluation

You could assign the converted value to a locally declared variable.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com