Re: "Execution failed' Error when deleting no rows

#1

On 28 Jul 2003 04:13:21 -0700 in comp.databases.ms-access,
gilbert.george (AT) whoever (DOT) com (Gilbert) wrote:

Quote:

Hi,

I am talking to Access via ODBC from C++ code.

I have a problem when I try to delete rows using a where clause which
returns no rows.

For example DELETE FROM test_table WHERE id = 3 - if no rows have id =
3 this returns the error "Execution failed". Is this normal Access
behaviour?

BTW DELETE * FROM test_table WHERE id = 3 doesn't work either - same
error.

I would expect this statement to delete nothing and not throw an
error.

It doesn't throw an error from Access, if yours uses a criteria that
would delete something, would it delete without error?

--
Ride Free (but you still have to pay for the petrol)

(replace sithlord with trevor for email)

#2

On 29 Jul 2003 03:27:07 -0700 in comp.databases.ms-access,
gilbert.george (AT) whoever (DOT) com (Gilbert) wrote:

Quote:

I was just wondering if it was the usual behaviour of an Access DB
when you talk to it via ODBC for C/C++.

Last time I used C there was no ODBC :-)

--
Ride Free (but you still have to pay for the petrol)

(replace sithlord with trevor for email)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: "Execution failed' Error when deleting no rows

comp.databases.ms-access comp.databases.ms-access

Re: "Execution failed' Error when deleting no rows - 07-28-2003 , 12:29 PM

Re: "Execution failed' Error when deleting no rows - 07-29-2003 , 03:30 PM