Re: CURRENT not being SELECTED

Could you include the code and the product you are using to insert (ie ESQL, 4GL, ODBC...) I do it all the time and have never had a problem. The formatting is another thing -- it's going to come out as yyyy-mm-dd hh:mm:ss (asumming you defined as year to second), and it's been so long since I've worked with ace and perform screens I don't remember if you can do any formating. Of course you can with ESQL, 4GL, etc. Richard Hawkins wrote: > > I have written a program which loads a CURRENT into a table along with a few > other fields. > Now, I can retrieve the whole row using a select in sql, an ace report and > in a perform. But using 4gl it retrieves all fields except the DATETIME > CURRENT field, which is blank. > Does anyone know what causes this? > Plus, how can I format a DATETIME field. > I am unsure of the version of informix, but can find out. > Please reply to mailto:RichardH@the-accounting-house.co.uk > Thanks in advance. > > ATB, Rich > > -- > > Richard's UFO Thoughts. > You'll never know unless you look... > http://www.netcomuk.co.uk/~richh Tom Grenier