SQL submission through ODBC to Informix 7.13

Posted in 1996

Manickam R Muthukumar — Thu, 12 Sep 1996 11:22:39 -0400 — source: Informix-list mailing list archive (1991-1998)

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) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~