Retrieving Dates from Informix Into Powerbuilder

Posted in 1996

STEVE_LOYD@HP-SanJose-om1.om.hp.com — 24 Jul 1996 21:08:23 -0400 — source: Informix-list mailing list archive (1991-1998)

Item Subject: cc:Mail Text Hello... Any Informix / Powerbuilder developers, With my .profile informix DBDate=MDY4/ matching my NT International short date format on the client, I have the following symptoms: 1. Dates can be entered and retrieved correctly with DBACCESS. 2. Dates can be inserted via PowerBuilder DataWindow (or using embedded sql) into the database and then can be viewed correctly using DBACCESS. 3. When retrieving date values into Powerbuilder DataWindow, date formats return ??/??/0000 In addition to not being able to view the date (which is correct in DB using DBACCESS), updates from within Powerbuilder cannot be performed erroring with "bad date format" please help, Steve Loyd