Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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.

Hiroshi Inoue

In response to

pgsql-odbc by date

Next:From: Denis GasparinDate: 2001-10-22 11:02:05
Subject: Re: [ODBC] Writing BLOBS to pgsql via ODBC using VB
Previous:From: Jim DickensonDate: 2001-10-19 20:01:38
Subject: Mac OS X problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group