Login | Register   
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


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

Time Data

Question:
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?

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

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap