> How can I set input a NULL value into an IBOQuery? I'm trying to do the
> following:
>
> IBOQuery1.ParamByName('DATE1').AsDate := SomeDate;
> IBOQuery1.ParamByName('DATE2').AsDate := NULL;

IBOQuery1.ParamByName('DATE2').Clear;

> NULL can't be casted as a date, but when using IB_Query I can use
> AsVarient.
>
> How can you do this with IBOQuery?

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