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
If txtdate3ties.Text = Empty Then
DataEnvironment1.rscmdRecentHeats.Fields("date3ties").Value = Null
Now is actually does make the change to that field, but it still fails on
the move, and spits out the error.. Weird..
> -----Original Message-----
> From: Ryan C. Bonham
> Sent: Friday, October 19, 2001 2:16 PM
> To: Hiroshi Inoue (E-mail)
> Cc: Pgsql-Odbc (E-mail)
> Subject: -2147217842 Operation was canceled
> 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 field..
> Private Sub cmdNext_Click()
> 104 DataEnvironment1.rscmdRecentHeats.Update
> 106 DataEnvironment1.rscmdRecentHeats.MoveNext
> End sub
pgsql-odbc by date
|Next:||From: Jim Dickenson||Date: 2001-10-19 20:01:38|
|Subject: Mac OS X problem|
|Previous:||From: Ryan C. Bonham||Date: 2001-10-19 18:15:45|
|Subject: -2147217842 Operation was canceled |