Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: Informix
Expertise: Beginner
Sep 22, 2000



Building the Right Environment to Support AI, Machine Learning and Deep Learning

Time Data

I am using Windows 2000 and ADO 2.5 with VB6.0 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 only time; no date is entered. When I retrieve the data, 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. I also get the original values when I use Microsoft Access and link the Informix table. 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?

I'm not sure how Informix views such a date-time. Why don't you use a time field instead?

DevX Pro
Thanks for your registration, follow us on our social networks to keep up-to-date