Thread: -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

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
>

> -----Original Message-----
> From: Ryan C. Bonham [mailto:Ryan@srfarms.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.

regards,
Hiroshi Inoue