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

-2147217842 Operation was canceled

From: "Ryan C(dot) Bonham" <Ryan(at)srfarms(dot)com>
To: "Hiroshi Inoue (E-mail)" <Inoue(at)tpf(dot)co(dot)jp>
Cc: "Pgsql-Odbc (E-mail)" <pgsql-odbc(at)postgresql(dot)org>
Subject: -2147217842 Operation was canceled
Date: 2001-10-19 18:15:45
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc

This might not be directly related to the ODBC Driver, but my brain isn't
working well today, TGIF, so I am going to ask.. 
I have a connection setup in VB6SP4. I am using a Data environment to
connect a form to a Postgre SQL Table. I am using a select statement "Select
* from table where current_date - noticed <100 order by noticed" If on the
form I delete information out of a field or if I type in information then
erase it, before updating the underlying table, then I try and move off the
form with a blank field I get this error. 
-2147217842   Operation was canceled.

Is this an error in the ODBC Driver, or am I doing something really
stupid... I posted the VB Code below. It dies on line 106. It also isn't
saving the changes if I delete something out of the field, even though it
runs the .update after I get the error message, the text reappears in the

Private Sub cmdNext_Click()
104         DataEnvironment1.rscmdRecentHeats.Update
106         DataEnvironment1.rscmdRecentHeats.MoveNext
End sub



pgsql-odbc by date

Next:From: Ryan C. BonhamDate: 2001-10-19 18:51:59
Subject: Re: -2147217842 Operation was canceled
Previous:From: Denis GasparinDate: 2001-10-19 16:20:14
Subject: Writing BLOBS to pgsql via ODBC using VB

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