Re: Datetime Problem between Powerbuilder and Informix

In article <6fq7i4$43p$1@nnrp1.dejanews.com>, Thenardier@POBoxes.com wrote: > > In article <6fpvud$u48$1@nnrp1.dejanews.com>, > zzavadil@hotmail.com (Zdenek Zavadil) wrote: > > > > In article <6fp9ec$a7n$1@nnrp1.dejanews.com>, > > Thenardier@POBoxes.com wrote: > > > 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 > > > > > > > Thenard, > > try to use the database column type DATETIME YEAR TO FRACTION(5). > > > > HTH, > > Zdenek > > Tried, but failed. :( Did u use it successfully before? Can u show > me ur way? Thanx!! > > Thenard > > -----== Posted via Deja News, The Leader in Internet Discussion ==----- > http://www.dejanews.com/ Now offering spam-free web-based newsreading > It's a strange thing. When I update table with column DATETIME YEAR TO DAY, I obtain error -1264. With DATETIME YEAR TO FRACTION(5) it works fine. This two cases are for SQLCA.DBParm = "DisableBind=0". For DisableBind=1 works everything fine, but it can reduce performance (see Online Books for details). So, this is the second possibility. I encountered the same problem aproximately one year ago with 16-bit PowerBuilder 5.0.01, but now I was testing this in 32-bit PB 5.0.03 without any trouble. Good luck! Zdenek -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading