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..
Thank
> -----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
>
>
> Hi,
>
> 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
>
>
> Thanks,
>
>
> Ryan
>
