Sorry about the over enthusiastic use of the reply button. I too have recreated the table in another Postgresql database using the SQL I posted. I added no data. I ran the AppWizard on that database/table and then ran the application without making any modifications to the generated code. When I added a new record using Dabo, I changed the birth_date field to 01/01/65. This again showed up in the Postgres database as 01/01/2064. I added another recorde and changed the birthdate to 12/31/80 and it stored the correct date.
I have put a dump of this test database in my public dropbox folder at https://dl.dropbox.com/u/34624974/dabo_test.backup I am using Linux Mint Lisa on the client machine. I have PostgreSQL 9.1 on an Ubuntu 12.04 server. I am going to try to install on a Windows machine here tonight. Regards, Dave Kelly The Priory Inn 01666 502 251 www.theprioryinn.co.uk "Dining in a 30 Mile Food Zone" -----Original Message----- From: John Fabiani [mailto:[email protected]] Sent: 20 June 2012 17:13 To: Dave Kelly Cc: Dabo Users list Subject: Re: [dabo-users] Y2K issue with date fields and multi line text fields On 06/20/2012 08:29 AM, Dave Kelly wrote: > I pasted the PagEditPublic_Employees.py program in its entiriety to > the codepage.pad site. I also posted the SQL used to create the > table. The PyCon tutorial I used is from the dabodev.com/documents > website but it links to > https://docs.google.com/document/pub?id=1N01Wgj3L1iec8WzjlC3MsAIf2XmOc > uTRxCs > zCYd91uQ. > > My location, btw, is United Kingdom. > > Don't get me wrong, I think Dabo is great. So far, it's exactly what > I am looking for. First please reply to the list and NOT directly to me. Others maybe able to help. I just created a App using AppWizard using your table. I added a record since I had no data. I do NOT see the two year date??? I do not think this a locale setting (your response to Ed question matched my locale setting). If you have a place to post a snapshot (mine appears to be down) I can show you. You sure you did not change something or add something from the demo? Actually, I don't see how if you just followed the AppWizard instructions. I've forgotten what OS are you using? Johnf _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/[email protected]
