Time Field
Posted in 2000
I am using Windows 2000 and ADO 2.5 and I am retrieving a datetime field from an Informix database 7.3. The field contains time only, when the record is entered that field is assigned time only no date is entered. When I retrieve the data using ADO 2.5 all I get is an empty field (not null). When I tried to print the value of that field I get the Run-time error '-2147217887 Multiple-step operation generated errors When I save the recordset using adoRecord.Save the original time values are in the saved file. Also when I use Microsoft Access and link the Informix table I get the original values. I am using the same ODBC driver for ADO and Access. How can I read the time from the datetime field when only time is entered in the field. Thanks Peter pczurak@bigfoot.com --------------------------- Microsoft Visual Basic --------------------------- Run-time error '-2147217887 (80040e21)': Multiple-step operation generated errors. Check each status value. --------------------------- OK Help ---------------------------