R: datetime type data

Subject: R: datetime type data Newsgroups: comp.databases.informix Jonathan: Thanks for your information. I used the same way to load data to sqlda as you showed in your program. However, the problem was not there. The problem occurred when I called dttoasc((dtime_t *)col->sqldata, buf); /* buf is a char string with size of 26 */ The data placed into buf was incorrect. The Informix version I'm using is 4.10. Could that be the problem? George Ma >1. Be careful with the version of ESQL/C you are using. There are bugs in > rtypemsize() and rtypmalign which are only fixed in 5.00 and above. > >2. The code below is what I use for handling sqlda structures. This has > code for both 5.00 and earlier versions. It is straight out of a > program of mine, so some of the headers may not be available, but it > should be a good starting point. You do not need to initialise the > dt_qual field in the allocated data space -- the interface code will > sort that out for you.