Message-Id: <199805010509.OAA09526@mustang.sdc.com.au>
To: Byron Nikolaidis <byronn@insightdist.com>
cc: "pgsql-interfaces@postgreSQL.org" <pgsql-interfaces@postgreSQL.org>
Subject: ODBC: dates (again) and passthrough
Date: Fri, 01 May 1998 14:39:21 +0930
From: Stephen Davies <scldad@sdc.com.au>

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@sdc.com.au
Adelaide, South Australia.     			                            Voice: 61-8-82728863
Computing & Network solutions.	 	                            Fax: 61-8-82741015