On 31 Oct 2001, at 9:12, Ignace MARTIN wrote:

> Sandeep,
>
> here is an idea :
>
> DECLARE VARIABLE I SMALLINT
> I=0
> WHILE (I<12) DO
> BEGIN
> INSERT INTO MYTABLE VALUES(...,DATEADD('m',I,CAST('TODAY' AS DATE)),...)
> END
>
>
> where DATEADD is a UDF you have to write...

I got around it by calling a stored procedure from my application
and passing the date as parameter.

I've tried using udf's but cannot get them to work, and have given up
on them. I'm using Delphi5 and Firebird.

Thanx anyway

Regards




Sandeep

Software Developer
CFL
sandeep@...
http://www.cfl.co.nz