> I have a query which contains a subquery. Subquery receives 2 date
> parameters, the problem is that when the query is activated,
> application raises an exception class EConvertError: "01/01/2006 is
> not a valid INTEGER value".
> I don't now why it's an integer value if I'm sending the parameter
> like a date value. If I execute the same query in ISQL there is no
> problem.
> Any suggestion?

Yes. Send queries and metadata. Mind you: this is a Delphi-side
error, so make sure if the (parameter) types are correct.

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