From: | "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | "Ryan C(dot) Bonham" <Ryan(at)srfarms(dot)com> |
Cc: | "Pgsql-Odbc \(E-mail\)" <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: -2147217842 Operation was canceled |
Date: | 2001-10-19 21:13:09 |
Message-ID: | EKEJJICOHDIEMGPNIFIJEEIKFKAA.Inoue@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
> -----Original Message-----
> From: Ryan C. Bonham [mailto:Ryan(at)srfarms(dot)com]
>
> Ok,
> On exploring this issue some more here is what have. The field I
> was having
> this problem with was a date field, so I believe what was happening was it
> was trying to insert a value of '' into a date field, and
> actually returning
> a "Bad date external representation." so I added the following
> commands to
> the form.
> If txtdate3ties.Text = Empty Then
> DataEnvironment1.rscmdRecentHeats.Fields("date3ties").Value = Null
> End If
>
> Now is actually does make the change to that field, but it still fails on
> the move, and spits out the error.. Weird..
Please start the postmaster with -d option and see what queries are
issued at server side in the log.
regards,
Hiroshi Inoue
From | Date | Subject | |
---|---|---|---|
Next Message | Denis Gasparin | 2001-10-22 11:02:05 | Re: [ODBC] Writing BLOBS to pgsql via ODBC using VB |
Previous Message | Jim Dickenson | 2001-10-19 20:01:38 | Mac OS X problem |