Re: Passing Dates from VB 4.0 to INfx 7.2

Steve Smidowicz wrote: > > I'm trying to pass a date to an informix stored procedure from Visual > Basic. > I've defined the date on the VB side as a string, it's received by the > sp as a char(10), yet when Inserted into the date column, I get a > -1218. I can cut the execute procedure string from an onstat -g sql > (sesid), and execute the exact syntax via dbaccess, and the sp runs > fine. It seems that VB (or the ODBC driver) may be adding a control > character (or something) that is not 'visible' to the naked eye... > This also happens when the field on the VB side is defined as a > Date... Have you tried INSERTing DATE(passed_date) into your table? This will convert the string into a date. Hope that helps, -- Mark. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | The Informix FAQ is at http://www.iiug.org | |mailto:marks@west.co.za +------------------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work... force it! | |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+------------------------------------------------+