Datetime Problem between Powerbuilder and Informix

Hi, Seems powerbuilder's functions is unable to convert datetime fields for informix database properly. When i use the update() function to physically update the datetime field to informix in a datawindow. It displays a message like this: -1264 Extra characters at the end of a datetime or interval However, if i use a INSERT statement, it works fine. Can anyone tell me how to deal with the -1264 problem? Seems it's already been a bug in earlier versions of powerbuilder. But powersoft just leave it unsolved. thanx for u help. rgds, Thenard -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading