From: | Stephen Davies <scldad(at)sdc(dot)com(dot)au> |
---|---|
To: | Byron Nikolaidis <byronn(at)insightdist(dot)com> |
Cc: | "pgsql-interfaces(at)postgreSQL(dot)org" <pgsql-interfaces(at)postgreSQL(dot)org> |
Subject: | ODBC: dates (again) and passthrough |
Date: | 1998-05-01 05:09:21 |
Message-ID: | 199805010509.OAA09526@mustang.sdc.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
G'day Byron.
I have just been modifying one of my VB5/ODBC 6.30.10/PostgreSQL 6.3.2 apps
and ran into a couple of funnies.
I thought that you had said that the default date format was now US so I
changed my code to say the following:
insert into quote (id,qdate,price) values (12,'05/01/1998',123)
(that is, I reversed dd/mm/yyyy to mm/dd/yyyy) and what arrived in the
database was Jan 5, 1998. I switched it back and got the correct result.
My postmaster is running in default US mode and I have removed the registry
entry that I had before.
Also, my app originally used the DB.Execute S$,passthrough option.
This worked with the old driver but fails with an "Out of memory" error with
your driver. Removing the passthrough option fixes the app.
Cheers and thanks,
Stephen.
========================================================================
Stephen Davies Consulting scldad(at)sdc(dot)com(dot)au
Adelaide, South Australia. Voice: 61-8-82728863
Computing & Network solutions. Fax: 61-8-82741015
From | Date | Subject | |
---|---|---|---|
Next Message | Peter T Mount | 1998-05-01 05:40:00 | Re: Platform-Problems with the jdbc:postgresql Driver |
Previous Message | Thomas G. Lockhart | 1998-05-01 01:46:54 | Re: [INTERFACES] Re: [HACKERS] Revised proposal for libpq and FE/BE protocol changes |