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()
pgsql-odbc by date
|Next:||From: Ryan C. Bonham||Date: 2001-10-19 18:51:59|
|Subject: Re: -2147217842 Operation was canceled |
|Previous:||From: Denis Gasparin||Date: 2001-10-19 16:20:14|
|Subject: Writing BLOBS to pgsql via ODBC using VB|