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

Re: -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: Re: -2147217842 Operation was canceled
Date: 2001-10-19 18:51:59
Message-ID: 19AB8F9FA07FB0409732402B4817D75A038BAE@FILESERVER.SRF.srfarms.com (view raw or flat)
Thread:
Lists: pgsql-odbc
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
> 

Responses

pgsql-odbc by date

Next:From: Jim DickensonDate: 2001-10-19 20:01:38
Subject: Mac OS X problem
Previous:From: Ryan C. BonhamDate: 2001-10-19 18:15:45
Subject: -2147217842 Operation was canceled

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