Subject Re: [firebird-support] Re: Date compare in firebird
Author Martijn Tonies
> > 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
My thoughts:
Database development questions? Check the forum!