Re: [dabo-users] Y2K issue with date fields and multi line text fields

Author: Dave Kelly

Posted: 2012-06-20 at 12:55:45

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:johnf@jfcomputer.com]

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: Dabo-users@leafe.com

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/001901cd4f0d$eb28a110$c179e330$@theprioryinn.co.uk

©2012 Dave Kelly