Re: SQL submission through ODBC to Informix 7.13

If you send the datetime as string with double quotes surrounding the single quote "'1996-01-01 12:00:00'" that will take care of that problem. Haytham ______________________________ Reply Separator _________________________________ Subject: SQL submission through ODBC to Informix 7.13 Author: Manickam R Muthukumar <m_muthukumar@litle.net> at hcia-smtp Date: 9/12/96 4:07 PM Hello Folks, I am using Actuate reporting tool to work againts Informix v7.13 through ODBC. Problem I am facing is that when I submit a query with constants having ":" , it is assumed to be a variable and converted to a '?' for example if I want to check any datetime column I give constant like '1996-01-01 12:00:00' when this query is passed to ODBC/INET driver converts above constant to '1996-01-01 12??'. Is there any way we can by pass this conversion? Please post on the net !! I appreciate all your help. -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ M.R.Muthukumar Database Consultant Email:m_muthukumar@litle.net !! Strong believer in making things work !! (Opinion expressed here are mine only) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~