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: | -2147217842 Operation was canceled |
Date: | 2001-10-19 18:15:45 |
Message-ID: | 19AB8F9FA07FB0409732402B4817D75A038BAD@FILESERVER.SRF.srfarms.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Ryan C. Bonham | 2001-10-19 18:51:59 | Re: -2147217842 Operation was canceled |
Previous Message | Denis Gasparin | 2001-10-19 16:20:14 | Writing BLOBS to pgsql via ODBC using VB |