Re: -2147217842 Operation was canceled

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

In response to

Browse pgsql-odbc by date

  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