--- d_dude_2003 wrote:

> I have the following statement
>
> DELETE FROM HRM_ATTENDANCERAW
> WHERE HRM_ATTENDANCERAW.ADATE <
> CURRENT_DATE - :DeleteRawAttendance;
>
> DeleteRawAttendance is declared as INTEGER

Where is it declared? Delphi?

> The statement results in conversion error.

Do you get the error from Firebird or by your connectivity library?

> How do i correct it?

Try:

CURRENT_DATE - cast(:DeleteRawAttendance as integer)


--

Milan Babuskov
http://www.guacosoft.com