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